Postgres Pro
Downloads
Home   >   mailing lists

Re: setting serial start value - Mailing list pgsql-general

From Michael Fuhr
Subject Re: setting serial start value
Date
Msg-id 20060721024923.GA38451@winnie.fuhr.org
Whole thread Raw
In response to setting serial start value  (Greg Philpott <gphilpott@mdialogue.com>)
Responses Re: setting serial start value  (Greg Philpott <gphilpott@mdialogue.com>)
List pgsql-general
Tree view 
On Thu, Jul 20, 2006 at 09:32:56PM -0400, Greg Philpott wrote:
> I have a table with a field called "id" that is a serial field and
> pkey. I would like to set the the sequence to start at 10000 and
> increase sequentially from there but I can't seem to get that to
> work. any suggestions are greatly appreciated.

What have you tried?  ALTER SEQUENCE or setval() should work.

http://www.postgresql.org/docs/7.4/interactive/sql-altersequence.html
http://www.postgresql.org/docs/7.4/interactive/functions-sequence.html

--
Michael Fuhr

pgsql-general by date:

Previous
From: Greg Philpott
Date:
Subject: setting serial start value
Next
From: "Jasbinder Bali"
Date:
Subject: ECPG (usage of simple select statement)