Postgres
Supported Fields
🏷️ Array
#️⃣ Bigint
📝 Bit
☑️ Boolean
📝 Composite
📅 Date
📅 Daterange
🔗 Domain
🔘 Enum
🖇️ Foreign Key
#️⃣ Geometric
#️⃣ Integer
#️⃣ Interval
🗃️Json
💱 Money
📝 Network
#️⃣ Numeric
⏱️ Range
📝 Text
📝 Textsearch
⏱️ Time
⏱️ Timestamp
🆔 Uuid
🗃️ XML
Binary
Things to Keep in Mind
During Setup
All Postgres tables must have a primary key We use the primary key to keep your data in sync. See Postgres snippets for additional detail.
Primary keys must be auto-generated Make sure your primary keys are generated by your database (i.e. have a default value). See Postgres snippets for additional detail.
Double-check that the Postgres account you use with Whalesync has access to the tables you want to map.
After Setup
Renaming schema, tables, or columns will break Whalesync mappings If you rename a table or column, you'll need to remap the impacted table/column in Whalesync. Note - remapping an impacted table will lead to duplicates unless you reset your data as well.
Handy Tips
We support foreign keys (including two-way sync)! Make sure to map both tables and reach out for help if not sure how to set it up.
Adding ".html" or "_html" to the end of a column name will preserve HTML If you name a Postgres column something such as "text_html", Whalesync will preserve that column's values as HTML while syncing.
Last updated