Openflow Connector for PostgreSQL: Data mapping¶
Note
This connector is subject to the Snowflake Connector Terms.
本主题介绍如何将 PostgreSQL 数据类型映射到 Snowflake 数据类型。
PostgreSQL 到 Snowflake 数据类型的映射¶
下表显示了在复制数据时，PostgreSQL 数据类型如何映射到 Snowflake 数据类型。
| PostgreSQL type | Snowflake type | Notes |
|---|---|---|
| SMALLINT / INT2 | INT | |
| INTEGER / INT / INT4 | INT | |
| BIGINT / INT8 | INT | |
| SMALLSERIAL / SERIAL2 | INT | |
| SERIAL / SERIAL4 | INT | |
| BIGSERIAL / SERIAL8 | INT | |
| NUMERIC / DECIMAL | NUMBER | Scale and precision are preserved within Snowflake limitations. Negative scale is converted to scale 0 with adjusted precision. |
| REAL / FLOAT4 | FLOAT | |
| DOUBLE PRECISION / FLOAT8 | FLOAT | |
| MONEY | FLOAT | |
| BOOLEAN / BOOL | BOOLEAN | |
| CHARACTER / CHAR / BPCHAR | TEXT | |
| CHARACTER VARYING / VARCHAR | TEXT | |
| TEXT | TEXT | |
| BYTEA | BINARY | Supported up to the maximum entry size in Snowflake (16 MB). |
| DATE | DATE | |
| TIME / TIME WITHOUT TIME ZONE | TIME | |
| TIME WITH TIME ZONE / TIMETZ | TIMESTAMP_TZ | |
| TIMESTAMP / TIMESTAMP WITHOUT TIME ZONE | TIMESTAMP_NTZ | |
| TIMESTAMP WITH TIME ZONE / TIMESTAMPTZ | TIMESTAMP_LTZ | |
| INTERVAL | TEXT | |
| JSON | VARIANT | Supported up to the maximum entry size in Snowflake (16 MB). |
| JSONB | VARIANT | Supported up to the maximum entry size in Snowflake (16 MB). |
| UUID | TEXT | |
| XML | TEXT | |
| BIT | TEXT | |
| BIT VARYING / VARBIT | TEXT | |
| POINT | TEXT | |
| LINE | TEXT | |
| LSEG | TEXT | |
| BOX | TEXT | |
| PATH | TEXT | |
| POLYGON | TEXT | |
| CIRCLE | TEXT | |
| CIDR | TEXT | |
| INET | TEXT | |
| MACADDR | TEXT | |
| MACADDR8 | TEXT | |
| TSVECTOR | TEXT | |
| TSQUERY | TEXT | |
| PG_LSN | TEXT |
Note
本表中未列出的任意 PostgreSQL 数据类型默认映射到 TEXT。