Hari Patel wrote:
> 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 ?
See here in the documentation:
In response to
pgsql-novice by date
|Next:||From: Hari Patel||Date: 2006-05-09 01:59:07|
|Subject: Re: Setting sequence ids after importing data|
|Previous:||From: Hari Patel||Date: 2006-05-09 00:43:08|
|Subject: Setting sequence ids after importing data|