Postgres Pro
Downloads
Home   >   mailing lists

setting next value of an established sequence - Mailing list pgsql-novice

From glenn
Subject setting next value of an established sequence
Date
Msg-id 1062565654.3083.10.camel@odin.valhalla
Whole thread Raw
Responses Re: setting next value of an established sequence
List pgsql-novice
Tree view 
Hi all
I've imported data into an established database. The data is, off
course, held together by various keys (which don't duplicate any of the
few existing values we have).

Is it possible for me to change the nextvalue stored in the sequences to
one that is more appropriate for (i.e. next after)  the imported data?

Glenn

pgsql-novice by date:

Previous
From: Al Hulaton
Date:
Subject: Re: Can Postgresql run in MS Windows
Next
From: Tom Lane
Date:
Subject: Re: setting next value of an established sequence