I am importing data from sqlite db into postgres. The tables have an id column that is obtained from a sequence.
To preserve the foreign key relationships, I need to preserve the ids while importing into postgres.
The problem is that after import, the sequences don't get incremented which leads to unique constraint violation errors further down. How do I fix this ?
