reinitialise serial counter
От | Indraneel Majumdar |
---|---|
Тема | reinitialise serial counter |
Дата | |
Msg-id | Pine.SGI.3.96.1001107132740.1055197A-100000@www.cdfd.org.in обсуждение исходный текст |
Ответы |
RE: reinitialise serial counter
|
Список | 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@123india.com # # Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com # # Centre for DNA Fingerprinting and Diagnostics, # # Hyderabad, India - 500076 # `************************************************************************/
В списке pgsql-sql по дате отправления: