Data types
Current Data types conversion for PostgreSQL to Snowconvert.
Last updated
Current Data types conversion for PostgreSQL to Snowconvert.
Last updated
Snowflake supports most basic (with some restrictions) for use in columns, local variables, expressions, parameters, and any other appropriate/suitable locations.
INT
INT
INT2
SMALLINT
INT4
INTEGER
INT8
INTEGER
INTEGER
INTEGER
BIGINT
BIGINT
DECIMAL
DECIMAL
DOUBLE PRECISION
DOUBLE PRECISION
NUMERIC​
NUMERIC
SMALLINT
SMALLINT
FLOAT
FLOAT
FLOAT4
FLOAT4
FLOAT8
FLOAT8
REAL
REAL​
BIGSERIAL/SERIAL8
INTEGER Note: Snowflake supports defining columns as IDENTITY, which automatically generates sequential values. This is the more concise and often preferred approach in Snowflake.
VARCHAR
VARCHAR Note: VARCHAR holds Unicode UTF-8 characters. If no length is specified, the default is the maximum allowed length (16,777,216).
CHAR
CHAR
CHARACTER
CHARACTER Note: Snowflake's CHARACTER is an alias for VARCHAR.
NCHAR
NCHAR
BPCHAR
CHARACTER VARYING
CHARACTER VARYING
NATIONAL CHARACTER
NCHAR
NATIONAL CHARACTER VARYING
NCHAR VARYING
TEXT
TEXT
VARCHAR
BOOL/BOOLEAN
BOOLEAN
BYTEA
BINARY
BIT
CHARACTER
BIT VARYING
CHARACTER VARYING
VARBIT
CHARACTER VARYING
DATE
DATE
TIME
TIME
TIME WITH TIME ZONE
TIME WITHOUT TIME ZONE
TIME
TIMESTAMP
TIMESTAMP
TIMESTAMPTZ
TIMESTAMP_TZ
TIMESTAMP WITH TIME ZONE
TIMESTAMP_TZ
TIMESTAMP WITHOUT TIME ZONE
TIMESTAMP_NTZ
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
UNKNOWN
type []
VARCHAR Note: BPCHAR data type is not supported in Snowflake. VARCHAR is used instead. For more information please refer to .
(Special character type)
TIME Note: Time zone not supported for time data type. For more information, please refer to .
VARCHAR Note: Data type is not supported in Snowflake. VARCHAR is used instead. For more information please refer to .
VARCHAR Note: Data type is not supported in Snowflake. VARCHAR is used instead. For more information please refer to .
TEXT Note: Data type is not supported in Snowflake. TEXT is used instead. For more information please refer to .
ARRAY Note: Strongly typed array transformed to ARRAY without type checking. For more information please refer to .
: Bpchar converted to varchar.
: Bytea Converted To Binary
: Unknown Pseudotype transformed to Text Type
: TIME ZONE not supported for time data type.
: Data type converted to another data type.
: Bit String Type converted to Varchar Type.
: Strongly typed array transformed to ARRAY without type checking.