DEFINITIONS
Definitions More Info.
Definition ID
906
Title
POSTGRESQL
Category
NOTES
Definition
Reset sequence with table seq ID
Definition Description
https://stackoverflow.com/questions/20781111/postgresql-9-1-primary-key-autoincrement
TRUNCATE TABLE "Label"
ALTER SEQUENCE label_seq RESTART WITH 1;
UPDATE "Label" SET "ID"=nextval('label_seq');
RecordBy
cunay
Record Date
20-12-2018 13:34:08
Düzenle
Kopyala
Sil