pg_idkit documentation

Generate IDs inside Postgres and use them as table defaults. These docs describe the SQL shipped in version 0.0.4.

Task	Read
Understand the extension	Overview
Load the functions	Install
Create your first table	Quickstart
Compare UUIDs and KSUIDs	Choose an ID
Add defaults, constraints and pagination	Primary keys
Extract a UUIDv7 timestamp	Read timestamps
Look up UUID functions	UUID generators
Look up KSUID functions	KSUID generators
Look up the timestamp function	Timestamp extraction
Understand failures and guarantees	Errors and limits

Examples use the extensions schema, lowercase SQL and named arguments where functions accept arguments. Run each task page in order; generated values vary between calls.