SSC-FDM-PG0014
Unknown Pseudotype transformed to Text Type
Description
This functional difference message indicates that UNKNOWN Pseudo Type used in PostgreSQL is not supported in Snowflake and is transformed to a Text Type.
Code Example
Input Code:
CREATE TABLE PSEUDOTYPES
(
COL1 UNKNOWN
)
Output Code:
CREATE TABLE PSEUDOTYPES (
COL1 TEXT /*** SSC-FDM-PG0014 - UNKNOWN PSEUDOTYPE TRANSFORMED TO TEXT TYPE ***/
)
Recommendations
Carefully evaluate the usages for the columns with Unknown Data Types, as differences may occur in specific scenarios.
If you need more support, you can email us at [email protected]
Last updated