I use truncate table $table_name. This will delete all data from that table and reset the sequense number. ----- Original Message ----- From: "Marc" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 23, 2002 6:37 PM Subject: [ADMIN] Reset sequence number
> Hello, > > How can I reset a sequence number back to 0 ? > > Regards > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
