pg_uuidv7

pig build pkg pg_uuidv7;		# build deb

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

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

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

CREATE EXTENSION pg_uuidv7;

CREATE EXTENSION pg_uuidv7;

-- Generate a UUIDv7
SELECT uuid_generate_v7();
-- 018570bb-4a7d-7c7e-8df4-6d47afd8c8fc

-- Extract timestamp from UUIDv7
SELECT uuid_v7_to_timestamptz('018570bb-4a7d-7c7e-8df4-6d47afd8c8fc');
-- 2023-01-02 04:26:40.637+00

-- Convert timestamp to UUIDv7
SELECT uuid_timestamptz_to_v7('2023-01-02 04:26:40.637+00');
-- 018570bb-4a7d-7630-a5c4-89b795024c5d

-- For date range queries, zero the random bits
SELECT uuid_timestamptz_to_v7('2023-01-02 04:26:40.637+00', true);
-- 018570bb-4a7d-7000-8000-000000000000

-- Use as primary key
CREATE TABLE events (
  id uuid NOT NULL DEFAULT uuid_generate_v7() PRIMARY KEY,
  data text
);