Обсуждение: setting next value of an established sequence

Поиск
Список
Период
Сортировка

setting next value of an established sequence

От
glenn
Дата:
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

От
Tom Lane
Дата:
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