Docs
...
Supported PostgreSQL data types

Supported PostgreSQL data types

Last updated: Feb 25, 2025
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 in the target database 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. If a source table contains a column with an unsupported data type, the table is 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