SEO

#1 (**permalink**) 04-09-2008, 11:10 PM

Hi

Is there any method of clearing the serial numbering so that ID references
can start afresh without rebuilding the database.

Of I use postgresql as part of my application I would like to use pgdump to
ensure that I have the latest version and starting the serial numbering at
#1 would be a good thing.

Bob

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#2 (**permalink**) 04-09-2008, 11:10 PM

On Nov 14, 2007 5:17 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
> Hi
>
> Is there any method of clearing the serial numbering so that ID references
> can start afresh without rebuilding the database.
>
> Of I use postgresql as part of my application I would like to use pgdump to
> ensure that I have the latest version and starting the serial numbering at
> #1 would be a good thing.

Look up setval(), currval() and nextval(), the sequence manipulation functions.

setval('seqname',1,true) will reset seqname back like new.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Serial IDs