3 ms·
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 bu
by inglor 1y ago
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 1y agoIn 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/iceberg-tables.md#iceberg-table-options https://github.com/Snowflake-Labs/pg_lake/blob/main/docs/ice...