How Does Fivetran Sync PostgreSQL Extension Data Types?

Question

How does Fivetran handle PostgreSQL extension data types during sync?

Environment

Connector: PostgreSQL

Answer

Fivetran supports syncing the following PostgreSQL extension data types:

• citext
• ltree
• hstore

Fivetran syncs PostgreSQL extension type values as strings (for citext and ltree) or as canonical JSON objects (for hstore) in the destination, preserving all structural details.

JSON representation in destination

The following examples show how extension type values are synced and represented in the destination.

citext

Source value in PostgreSQL:

'HelloWorld'

Synced string value in destination:

'HelloWorld'

ltree

Source value in PostgreSQL:

'Top.Science.Astronomy.Stars'

Synced JSON value in destination:

'Top.Science.Astronomy.Stars'

hstore

Source value in PostgreSQL:

'"color"=>"blue","size"=>"large"'

Synced JSON value in destination:

{"color":"blue","size":"large"}