Re: setting next value of an established sequence

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: glenn <gdavy(at)tpg(dot)com(dot)au>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: setting next value of an established sequence
Date: 2003-09-03 05:11:02
Message-ID: 9899.1062565862@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

glenn <gdavy(at)tpg(dot)com(dot)au> writes:
> Is it possible for me to change the nextvalue stored in the sequences

Sure, see setval().

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tomka Gergely 2003-09-03 06:30:09 Re: Using COPY
Previous Message glenn 2003-09-03 05:07:35 setting next value of an established sequence