Thread: setting next value of an established sequence

setting next value of an established sequence

From
glenn
Date:
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


Re: setting next value of an established sequence

From
Tom Lane
Date:
glenn <gdavy@tpg.com.au> writes:
> Is it possible for me to change the nextvalue stored in the sequences

Sure, see setval().

            regards, tom lane