Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

IntermediateBasic SELECT

Use a Sequence

SQL

SELECT nextval('order_number_seq');
SELECT currval('order_number_seq');

Tested against PostgreSQL 16

Note

“nextval() increments and returns the next number. currval() returns the last number generated in your current session.