Remix.run Logo
pgguru 2 days ago

Hi, what types are you expecting to see that aren't supported? I believe we had support for most/all builtin postgres types.

inglor a day ago | parent [-]

Postgres has like 300+ types but mostly stuff like decimals should work the same way it does with Postgres (with the edge cases like NaN existing in Postgres but not parquets accordingly)

mslot a day ago | parent [-]

In principle, Postgres has an infinite number of possible types :).

pg_lake maps types into their Parquet equivalent and otherwise stores as text representation, there are a few limitations like very large numerics.

https://github.com/Snowflake-Labs/pg_lake/blob/main/docs/ice...