Supported PostgreSQL data types
The Google Cloud AlloyDB for PostgreSQL endpoint for Qlik Replicate supports most PostgreSQL database data types. The following table shows the PostgreSQL database target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using. For additional information about Qlik Replicate data types, see Replicate data types.
| Qlik Replicate data types | PostgreSQL data types |
|---|---|
|
BOOL |
BOOL |
|
BYTES |
BYTEA |
|
DATE |
DATE |
|
TIME |
TIME |
|
DATETIME |
If scale is => 0 and =< 6, then: TIMESTAMP If scale is => 7 and =< 12, then: VARCHAR (37) |
|
INT1 |
SMALLINT |
|
INT2 |
SMALLINT |
|
INT4 |
INTEGER |
|
INT8 |
BIGINT |
|
NUMERIC |
DECIMAL (P, S) |
|
REAL4 |
FLOAT4 |
|
REAL8 |
FLOAT8 |
|
STRING |
If length is 1 - 21845, then: VARCHAR (Length) If length is 21846 - 2147483647, then: VARCHAR (65535) |
|
UINT1 |
SMALLINT |
|
UINT2 |
INTEGER |
|
UINT4 |
BIGINT |
|
UINT8 |
BIGINT |
|
WSTRING |
If length is 1 - 21845, then: VARCHAR (Length) If length is 21846 - 2147483647, then: VARCHAR (65535) |
|
BLOB |
BYTEA |
|
NCLOB |
TEXT |
|
CLOB |
TEXT |
Data types when replicating from a PostgreSQL source
When replicating from a PostgreSQL source, the target table will be created with the same data types for all columns, apart from columns with user-defined or PostGIS data types. In such cases, the data type will be created as "character varying" in the target.