sequential_uuids

pig build pkg sequential_uuids;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install sequential_uuids;		# install via package name, for the active PG version

pig install sequential_uuids -v 18;   # install for PG 18
pig install sequential_uuids -v 17;   # install for PG 17
pig install sequential_uuids -v 16;   # install for PG 16
pig install sequential_uuids -v 15;   # install for PG 15
pig install sequential_uuids -v 14;   # install for PG 14

CREATE EXTENSION sequential_uuids;

CREATE EXTENSION sequential_uuids;

CREATE SEQUENCE my_seq;

-- Sequence-based UUID generation
SELECT uuid_sequence_nextval('my_seq'::regclass);

-- Time-based UUID generation (wraps around every ~45 days with defaults)
SELECT uuid_time_nextval();

-- Use as default for a column
CREATE TABLE orders (
  id uuid DEFAULT uuid_time_nextval() PRIMARY KEY,
  data text
);

-- Custom block size and count
SELECT uuid_sequence_nextval('my_seq', 256, 65536);
SELECT uuid_time_nextval(120, 32768);