PostgreSQL シーケンス操作 | 私的雑録

pgdb=# SELECT last_value FROM foo_seq; last_value ------------ 1000 (1 行) pgdb=# begin; BEGIN pgdb=# SELECT nextval('foo_seq'); nextval --------- 1001 (1 行) pgdb=# SELECT nextval('foo_seq'); nextval --------- 1002 (1 行) pgdb=# SELECT nextval('foo_seq'); nextval --------- 1003 (1 行) pgdb=# rollback; ROLLBACK pgdb=# SELECT last_value FROM foo_seq; last_value ------------ 1003 (1 行)