Data type considerations and exceptions
When replicating from one PostgreSQL database to another, source and target data types are identical for all supported PostgreSQL versions, with the following exceptions:
PostgreSQL Source | PostgreSQL Target |
---|---|
ENUM |
STRING |
COMPOSITE |
STRING |
NUMERIC |
NUMERIC (28,6) |
NUMERIC (p,s) A numeric array with precision and scale. |
NUMERIC A numeric array without precision and scale. |
TINTERVAL |
Information note
As PostgreSQL have discontinued support for the TINTERVAL data type, tables with this data type will not be created on the target if the target database version does not support it. |
See also the note about JSON data type replication in PostgreSQL source data types.