Skip to main content

Module types

Module types 

Source
Expand description

Arrow to PostgreSQL type mapping for sink operations.

Maps Apache Arrow DataType to PostgreSQL SQL type names for:

  • UNNEST array casts in upsert queries
  • CREATE TABLE DDL generation
  • COPY BINARY column type declarations

Functionsยง

arrow_column_to_pg_array
Converts an Arrow array column to a boxed PostgreSQL array parameter for UNNEST queries.
arrow_to_pg_ddl_type
Maps an Arrow DataType to a PostgreSQL DDL type for CREATE TABLE.
arrow_type_to_pg_array_cast
Returns the PostgreSQL array type suffix for UNNEST cast expressions.
arrow_type_to_pg_sql
Maps an Arrow DataType to a PostgreSQL SQL type name for UNNEST casts.