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. If the data type of the target column
is not compatible, it will convert the target data type to a string-based data type (for example, varchar).
The following table shows the PostgreSQL data types that you can replicate. Unsupported data types are not replicated to the target database.
| Data Type | Aliases | Description | Supported |
|---|---|---|---|
| bigint | int8 | signed eight-byte integer | ✓ |
| bigserial | serial8 | autoincrementing eight-byte integer | ✓ |
| bit [ (n) ] | fixed-length bit string | ||
| bit varying [ (n) ] | varbit [ (n) ] | variable-length bit string | |
| boolean | bool | logical Boolean (true/false) | ✓ |
| box | rectangular box on a plane | ||
| bytea | binary data (“byte array”) | ✓ | |
| character [ (n) ] | char [ (n) ] | fixed-length character string | ✓ |
| character varying [ (n) ] | varchar [ (n) ] | variable-length character string | ✓ |
| cidr | IPv4 or IPv6 network address | ||
| circle | circle on a plane | ||
| date | calendar date (year, month, day) | ✓ | |
| double precision | float8 | double precision floating-point number (8 bytes) | ✓ |
| inet | IPv4 or IPv6 host address | ||
| integer | int, int4 | signed four-byte integer | ✓ |
| interval [ fields ] [ (p) ] | time span | ||
| json | textual JSON data | ✓ | |
| jsonb | binary JSON data, decomposed | ✓ | |
| line | infinite line on a plane | ||
| lseg | line segment on a plane | ||
| macaddr | MAC (Media Access Control) address | ||
| macaddr8 | MAC (Media Access Control) address (EUI-64 format) | ||
| money | currency amount | ||
| numeric [ (p, s) ] | decimal [ (p, s) ] | exact numeric of selectable precision | ✓ |
| path | geometric path on a plane | ||
| pg_lsn | PostgreSQL Log Sequence Number | ||
| point | geometric point on a plane | ||
| polygon | closed geometric path on a plane | ||
| real | float4 | single precision floating-point number (4 bytes) | ✓ |
| smallint | int2 | signed two-byte integer | ✓ |
| smallserial | serial2 | autoincrementing two-byte integer | ✓ |
| serial | serial4 | autoincrementing four-byte integer | ✓ |
| text | variable-length character string | ✓ | |
| time [ (p) ] [ without time zone ] | time of day (no time zone) | ✓ | |
| time [ (p) ] with time zone | timetz | time of day, including time zone | ✓ |
| timestamp [ (p) ] [ without time zone ] | date and time (no time zone) | ✓ | |
| timestamp [ (p) ] with time zone | timestamptz | date and time, including time zone | ✓ |
| tsquery | text search query | ||
| tsvector | text search document | ||
| txid_snapshot | user-level transaction ID snapshot (deprecated; see pg_snapshot) | ||
| uuid | universally unique identifier | ✓ | |
| xml | XML data | ✓ |
Parent topic: Replicating Amazon RDS for PostgreSQL data