Mega Code Archive

 

Categories / PostgreSQL / Sequence

 

Drop a sequence

postgres=# -- Creation of a sequence postgres=# postgres=# CREATE SEQUENCE shipments_ship_id_seq START 200 INCREMENT 1; CREATE SEQUENCE postgres=# postgres=# -- Select the next number from a sequence with the nextval() function: postgres=# postgres=# SELECT nextval ('shipments_ship_id_seq');  nextval ---------      200 (1 row) postgres=# postgres=# postgres=# drop sequence shipments_ship_id_seq; DROP SEQUENCE postgres=#