reinitialise serial counter

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 #
`************************************************************************/

Responses

Browse pgsql-sql by date

  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