PostgreSQL (ADBC) → Parquet
Datatypes conversion mapping when exporting from PostgreSQL using the ADBC connector (--connectiontype adbc_pgsql) to Parquet format.
Platform availability
The ADBC FastDriver connectors (adbc_mssql, adbc_pgsql) are available on Windows x64 and Linux x64 only. They are not supported on Linux ARM64.
info
The ADBC connector does not map every type the way the standard pgsql driver does. Compare both pages before switching.
| Source | PostgreSQL (adbc_pgsql) |
| Format | Parquet |
| FastBCP | 1.1.4.0 |
| Test Status | PARTIAL (40/41 Nullable) |
Failed Types
The following datatype is not supported with this connector:
INTERVAL— export fails
Parquet Schema: testdatatypes_nullable
| name | physical_type | converted_type | logical_type |
|---|---|---|---|
| col_bigint | INT64 | — | — |
| col_integer | INT32 | — | — |
| col_smallint | INT32 | INT_16 | IntType(bitWidth=16, isSigned=1) |
| col_boolean | BOOLEAN | — | — |
| col_numeric | FIXED_LEN_BYTE_ARRAY | DECIMAL | DecimalType(scale=2, precision=18) |
| col_real | FLOAT | — | — |
| col_double_precision | DOUBLE | — | — |
| col_money | BYTE_ARRAY | — | — |
| col_date | INT32 | DATE | DateType() |
| col_time | INT64 | — | TimeType(isAdjustedToUTC=0, unit=MICROS) |
| col_timestamp | INT64 | TIMESTAMP_MICROS | TimestampType(isAdjustedToUTC=0, unit=MICROS) |
| col_timestamptz | INT64 | TIMESTAMP_MICROS | TimestampType(isAdjustedToUTC=1, unit=MICROS) |
| col_char | BYTE_ARRAY | UTF8 | StringType() |
| col_varchar | BYTE_ARRAY | UTF8 | StringType() |
| col_text | BYTE_ARRAY | UTF8 | StringType() |
| col_bytea | BYTE_ARRAY | — | — |
| col_uuid | BYTE_ARRAY | UTF8 | StringType() |
| col_json | BYTE_ARRAY | UTF8 | StringType() |
| col_jsonb | BYTE_ARRAY | UTF8 | StringType() |
| col_xml | BYTE_ARRAY | UTF8 | StringType() |
| col_inet | BYTE_ARRAY | UTF8 | StringType() |
| col_cidr | BYTE_ARRAY | UTF8 | StringType() |
| col_macaddr | BYTE_ARRAY | UTF8 | StringType() |
| col_point | BYTE_ARRAY | — | — |
| col_line | BYTE_ARRAY | — | — |
| col_lseg | BYTE_ARRAY | — | — |
| col_box | BYTE_ARRAY | — | — |
| col_path | BYTE_ARRAY | — | — |
| col_polygon | BYTE_ARRAY | — | — |
| col_circle | BYTE_ARRAY | — | — |
| col_int4range | BYTE_ARRAY | — | — |
| col_int8range | BYTE_ARRAY | — | — |
| col_numrange | BYTE_ARRAY | — | — |
| col_tsrange | BYTE_ARRAY | — | — |
| col_tstzrange | BYTE_ARRAY | — | — |
| col_daterange | BYTE_ARRAY | — | — |
| col_bit | BYTE_ARRAY | UTF8 | StringType() |
| col_bit_varying | BYTE_ARRAY | UTF8 | StringType() |
| col_oid | INT32 | — | — |
| col_int_array | BYTE_ARRAY | — | — |