POSTGRESQL: CREATE SEQUENCE
top of page
CerebroSQL

PostgreSQL:  

CREATE SEQUENCE

Topic

CREATE [ TEMPORARY | TEMP ] SEQUENCE [ IF NOT EXISTS ] name [ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
[ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
[ OWNED BY { table_name.column_name | NONE } ]

Example

CREATE SEQUENCE serial START 101;
SELECT nextval('serial');

bottom of page