IBM Cloud Pak® for Data Version 4.6 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.
Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.6 reaches end of support. For more information, see Upgrading IBM Software Hub in the IBM Software Hub Version 5.1 documentation.
Supported PostgreSQL data types
When you use Amazon RDS for PostgreSQL as a source connection, you can replicate only some data types.
When you use the Amazon RDS for PostgreSQL connection with the Copy goal, Data Replication will attempt to create or replicate to a column with a similar column name and compatible data type, converting to a string if necessary.
The following table shows which PostgreSQL data types that you can replicate:
| Name | Aliases | Description | Supported Version |
|---|---|---|---|
| bigint | int8 | signed eight-byte integer | 4.6.0 and later |
| bigserial | serial8 | autoincrementing eight-byte integer | 4.6.0 and later |
| bit [ (n) ] | fixed-length bit string | Not supported | |
| bit varying [ (n) ] | varbit [ (n) ] | variable-length bit string | Not supported |
| boolean | bool | logical Boolean (true/false) | 4.6.0 and later |
| box | rectangular box on a plane | Not supported | |
| bytea | binary data (“byte array”) | 4.6.0 and later | |
| character [ (n) ] | char [ (n) ] | fixed-length character string | 4.6.0 and later |
| character varying [ (n) ] | varchar [ (n) ] | variable-length character string | 4.6.0 and later |
| cidr | IPv4 or IPv6 network address | Not supported | |
| circle | circle on a plane | Not supported | |
| date | calendar date (year, month, day) | 4.6.0 and later | |
| double precision | float8 | double precision floating-point number (8 bytes) | 4.6.0 and later |
| inet | IPv4 or IPv6 host address | Not supported | |
| integer | int, int4 | signed four-byte integer | 4.6.0 and later |
| interval [ fields ] [ (p) ] | time span | Not supported | |
| json | textual JSON data | 4.6.0 and later | |
| jsonb | binary JSON data, decomposed | 4.6.0 and later | |
| line | infinite line on a plane | Not supported | |
| lseg | line segment on a plane | Not supported | |
| macaddr | MAC (Media Access Control) address | Not supported | |
| macaddr8 | MAC (Media Access Control) address (EUI-64 format) | Not supported | |
| money | currency amount | Not supported | |
| numeric [ (p, s) ] | decimal [ (p, s) ] | exact numeric of selectable precision | 4.6.0 and later |
| path | geometric path on a plane | Not supported | |
| pg_lsn | PostgreSQL Log Sequence Number | Not supported | |
| pg_snapshot | user-level transaction ID snapshot | Not supported | |
| point | geometric point on a plane | Not supported | |
| polygon | closed geometric path on a plane | Not supported | |
| real | float4 | single precision floating-point number (4 bytes) | 4.6.0 and later |
| smallint | int2 | signed two-byte integer | 4.6.0 and later |
| smallserial | serial2 | autoincrementing two-byte integer | 4.6.0 and later |
| serial | serial4 | autoincrementing four-byte integer | 4.6.0 and later |
| text | variable-length character string | 4.6.0 and later | |
| time [ (p) ] [ without time zone ] | time of day (no time zone) | 4.6.0 and later | |
| time [ (p) ] with time zone | timetz | time of day, including time zone | 4.6.0 and later |
| timestamp [ (p) ] [ without time zone ] | date and time (no time zone) | 4.6.0 and later | |
| timestamp [ (p) ] with time zone | timestamptz | date and time, including time zone | 4.6.0 and later |
| tsquery | text search query | Not supported | |
| tsvector | text search document | Not supported | |
| txid_snapshot | user-level transaction ID snapshot (deprecated; see pg_snapshot) | Not supported | |
| uuid | universally unique identifier | 4.6.0 and later | |
| xml | XML data | 4.6.0 and later |
Parent topic: Replicating Amazon RDS for PostgreSQL data