From: | Indraneel Majumdar <indraneel(at)www(dot)cdfd(dot)org(dot)in> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | reinitialise serial counter |
Date: | 2000-11-07 21:30:51 |
Message-ID: | Pine.SGI.3.96.1001107132740.1055197A-100000@www.cdfd.org.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I have a table
create table test (id serial, name text);
after inserting values and doing delete from test if I try to insert
values again, the id starts from where it left off previously. How can I
get the serial counter to restart from 1 ? is it anything to do with
setval(). How to use the setval?
thanks,
Indraneel
/************************************************************************.
# Indraneel Majumdar ¡ E-mail: indraneel(at)123india(dot)com #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`************************************************************************/
From | Date | Subject | |
---|---|---|---|
Next Message | Forest Wilkinson | 2000-11-07 22:57:59 | how to index a numeric(12,2) column? |
Previous Message | Larry Rosenman | 2000-11-07 18:50:48 | Display of RI triggers |