LogoLogo
WelcomeGet Started
  • What is Whalesync?
  • Start Here
    • Quick start
    • Video tutorials
  • Popular Syncs
    • Webflow + Airtable
    • HubSpot + Notion
    • Supabase + Airtable
    • Notion + Google Sheets
  • Connectors
    • Affinity
      • Authorize Affinity
      • Full records vs. shallow records
      • List-specific fields
      • Notes in Affinity
    • Airtable
      • Airtable view sync
      • Airtable API quota
    • Attio
    • Google Sheets
      • Formatting columns
      • Foreign keys
      • Multi-select fields
      • Avoid sort range
      • Whalesync ID column
    • HubSpot
      • Associations
      • Webhooks
      • Merging records
    • Memberstack
      • Authorize Memberstack
      • Memberstack custom fields
    • Notion
      • Notion page sync
    • Postgres
      • Authorize Postgres
        • AWS (RDS)
        • Basedash
        • DigitalOcean
        • Heroku
        • Neon
        • Render
        • Supabase
      • SQL scripts
      • Primary key snippets
      • Foreign key snippets
      • Terminology
      • Multiple foreign keys in a single field
      • How to sync Postgres views
    • Salesforce
    • Stripe
      • Authorize Stripe
    • Supabase
      • Adding default values to primary keys
      • How to sync Airtable linked records with Supabase foreign keys
      • Why does Whalesync create a database user?
      • Why do I need an ID column?
      • SQL scripts
      • Primary key snippets
      • Foreign key snippets
      • Terminology
      • Multiple foreign keys in a single field
      • How to sync Postgres views
    • Webflow
      • Supported fields - (AT x WF)
      • Webflow Memberships sync
      • Webflow status field
  • Previous connectors
    • Bubble
      • Authorize Bubble
    • Close
    • Copper
    • MS Dynamics CRM
    • Outreach
    • Pipedrive
      • Pipelines
    • Shopify
      • Authorize Shopify
      • Syncing images
      • Syncing variants
      • Tutorial videos
      • Theme Template field
    • WordPress.com
    • WordPress.org
      • Quick Start Guide: WordPress.org
      • Authorize WordPress.org
      • Advanced Custom Fields (ACF)
      • How to sync images
      • Supporting tables
      • Tutorial
      • WordPress status field
    • Zoho CRM
  • Features
    • Two-way sync
    • Issues
    • Operations
    • Record matching
    • Filters
    • Auto-create tables
    • Additional features
      • Automapping
      • Creating users via Whalesync
      • Delete protection
      • File hosting
      • HTML and Markdown field extensions
      • Relation fields
      • Sync preview
  • Resources
    • Support
      • Sync behavior questions
      • Common errors - Airtable
      • Common errors - Notion
      • Common errors - Postgres
      • Common errors - Webflow
      • FAQ
      • Field compatibility
      • How to get record IDs
      • How to change your sign-in
      • How to change your email
      • How to add additional email addresses
      • How to update your tax ID number
      • How to create a slug field in Airtable
      • Known issues
      • Multi-select to multi-reference
      • Transfer Webflow site to another account
      • Troubleshooting attachment fields
      • Webflow deprecating v1 APIs
    • Template Packs
  • YouTube
  • Security
  • Changelog
Powered by GitBook
On this page
  • Supported Fields
  • Things to Keep in Mind
  • During Setup
  • After Setup
  • Handy Tips

Was this helpful?

  1. Connectors

Postgres

Supported Fields

Field
Status

🏷️ Array

βœ… Supported

#️⃣ Bigint

βœ… Supported

πŸ“ Bit

βœ… Supported

β˜‘οΈ Boolean

βœ… Supported

πŸ“ Composite

➑️ Supported (1-Way)

πŸ“… Date

βœ… Supported

πŸ“… Daterange

➑️ Supported (1-Way)

πŸ”— Domain

➑️ Supported (1-Way)

πŸ”˜ Enum

βœ… Supported

πŸ–‡οΈ Foreign Key

βœ… Supported

#️⃣ Geometric

➑️ Supported (1-Way)

#️⃣ Integer

βœ… Supported

#️⃣ Interval

➑️ Supported (1-Way)

πŸ—ƒοΈJson

βœ… Supported

πŸ’± Money

βœ… Supported

πŸ“ Network

βœ… Supported

#️⃣ Numeric

βœ… Supported

⏱️ Range

➑️ Supported (1-Way)

πŸ“ Text

βœ… Supported

πŸ“ Textsearch

➑️ Supported (1-Way)

⏱️ Time

➑️ Supported (1-Way)

⏱️ Timestamp

βœ… Supported

πŸ†” Uuid

βœ… Supported

πŸ—ƒοΈ XML

βœ… Supported

Binary

βœ–οΈ Not Yet

Things to Keep in Mind

During Setup

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.

PreviousNotion page syncNextAuthorize Postgres

Last updated 7 months ago

Was this helpful?

All Postgres tables must have a primary key We use the primary key to keep your data in sync. See 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 for additional detail.

Postgres snippets
Postgres snippets
Page cover image