I am in the process of writing a migration utility to move data from a
SQL Server to PostgreSQL. The original schema contains identity fields.
When converting the schema, I have 2 option - either make them serial
(or bigserisl) columns, with the associated automatic constraint, or
declaring the associated sequences separately and invoking the
generators in code.
If I were to use the former (use Serial/BigSerial), is there a command
which I can issue to keep PostgreSQL from using the sequence, and
therefore copying over the original identity field value? Something
equivalent to SQL Server's "SET IDENTITY_INSERT" command?