Resetting sequence
От | Keith Worthington |
---|---|
Тема | Resetting sequence |
Дата | |
Msg-id | 20050125221536.M53757@narrowpathinc.com обсуждение исходный текст |
Ответы |
Re: Resetting sequence
|
Список | pgsql-novice |
Hi All, In my database I have the following table with a serial column. All of the data has been deleted from the table. I would like to know if the sequence can be reset such that the next time a record is written into the table it will have a value of 1. TIA # \d inventory.tbl_detail Table "inventory.tbl_detail" Column | Type | Modifiers ----------------+------------------------+---------------------------- inventory_id | integer | not null default nextval('inventory.tbl_detail_inventory_id_seq'::text) inventory_date | date | not null inventory_type | character varying(20) | not null note | character varying(511) | Indexes: "tbl_detail_pkey" PRIMARY KEY, btree (inventory_id) Foreign-key constraints: "tbl_detail_fkey1" FOREIGN KEY (inventory_type) REFERENCES inventory.tbl_type(inventory_type) ON UPDATE CASCADE ON DELETE RESTRICT Kind Regards, Keith
В списке pgsql-novice по дате отправления: