[GENERAL] Serial IDs

2007-11-14 Thread Bob Pawley 

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

Re: [GENERAL] Serial IDs

2007-11-14 Thread Scott Marlowe 
On Nov 14, 2007 5:17 PM, Bob Pawley [EMAIL PROTECTED] 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