Cacher is the code snippet organizer for pro developers

CREATE SEQUENCE foo_seq;

SELECT currval('foo_seq'); -- ERROR

SELECT nextval('foo_seq'); -- 1
SELECT nextval('foo_seq'); -- 2
SELECT nextval('foo_seq'); -- 3

SELECT currval('foo_seq'); -- 3

SELECT setval('foo_seq', 0);    -- ERROR

SELECT setval('foo_seq', 1);    -- 1
SELECT nextval('foo_seq'); -- 2
SELECT nextval('foo_seq'); -- 3

DROP SEQUENCE foo_seq;