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 ?
pgsql-novice by date
|Next:||From: Sean Davis||Date: 2006-05-09 01:13:38|
|Subject: Re: Setting sequence ids after importing data|
|Previous:||From: John Purser||Date: 2006-05-08 23:57:46|
|Subject: Re: Command line option|