Postgres Surrogate Sync Generator

Enter a table, surrogate field, and primary key field. The SQL updates automatically.

Table name

Surrogate field name

Primary key field

1. Add Field SQL

2. Function / Trigger SQL

Assumes the table is in public, and the sequence is named <table>_<field>_seq. The unique constraint is created only if it does not already exist.