PostgreSQL:Sequence

lastmod 2021-03-03created 2021-03-032 edits

Create

CREATE SEQUENCE [seq_name]

nextval

nextval('seq_name')

currval

currval('seq_name')

Reset value

setval('seq_name', seq_val, [true/false])

Drop

DROP SEQUENCE [seq_name]

AUTO INCREMENT

• PostgreSQL - SERIAL - Generate IDs (Identity, Auto-increment)
• Using AUTO INCREMENT in PostgreSQL
• How to handle AUTO INCREMENT in PostgreSQL
• Meta Developer Story :: Using the AUTO_INCREMENT feature in PostgreSQL
• Auto-increment columns in PostgreSQL like MySQL's AUTO_INCREMENT

See also

• PostgreSQL
• PostgreSQL:CreateTable

Favorite site

• PostgreSQL: Documentation: 9.5: CREATE SEQUENCE
• PostgreSQL) Creating, using, and resetting a Sequence
• (PostgreSQL) How to use a Sequence (nextval, currval)