setting next value of an established sequence

From: glenn <gdavy(at)tpg(dot)com(dot)au>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: setting next value of an established sequence
Date: 2003-09-03 05:07:35
Message-ID: 1062565654.3083.10.camel@odin.valhalla
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-09-03 05:11:02 Re: setting next value of an established sequence
Previous Message Christopher Browne 2003-09-03 03:15:11 Re: Number of rows in a table