PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.Hightouch requires a unique identifier in the destination Postgres table in order to add, remove, and update rows. The column must be either a
PRIMARY KEYcolumn. At least one Hightouch field must map to a unique column.If you're unsure whether your mapping includes a compatible column, just try it! Hightouch will error if you need to change your mappings.Hightouch works out of the box with all standard column types, including:
- Add/update/delete rows from the destination table.
- View the
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGEtables. This is used forgathering metadata needed for the sync.
9.5(Hightouch relies on
ON CONFLICTfor updating rows).