Vol. I · A Postgres Handbook

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

Create a custom Sequence

The query

SQL
CREATE SEQUENCE order_number_seq 
START 1000 
INCREMENT 5;
Tested against PostgreSQL 16

Note

“Sequences are independent objects that generate unique numbers. Useful when multiple tables need a shared ID pool.