pg_idkit

multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)

Overview

Package	Version	Category	License	Language
`pg_idkit`	`0.4.0`	FUNC	Apache-2.0	Rust

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
4500	`pg_idkit`	No	Yes	No	Yes	No	No	-

Related	`pg_uuidv7` `sequential_uuids` `snowflake` `pgx_ulid` `pg_uuid_v8` `uuid-ossp` `typeid` `permuteseq`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PIGSTY	`0.4.0`	1817161514	`pg_idkit`	-
RPM	PIGSTY	`0.4.0`	1817161514	`pg_idkit_$v`	-
DEB	PIGSTY	`0.4.0`	1817161514	`postgresql-$v-pg-idkit`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.4.0 el8.x86_64.pg18 : pg_idkit_18 pg_idkit_18-0.4.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el8.x86_64.pg17 : pg_idkit_17 pg_idkit_17-0.4.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el8.x86_64.pg16 : pg_idkit_16 pg_idkit_16-0.4.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el8.x86_64.pg15 : pg_idkit_15 pg_idkit_15-0.4.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el8.x86_64.pg14 : pg_idkit_14 pg_idkit_14-0.4.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB
el8.aarch64	PIGSTY 0.4.0 el8.aarch64.pg18 : pg_idkit_18 pg_idkit_18-0.4.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.4.0 · 1.0MiB	PIGSTY 0.4.0 el8.aarch64.pg17 : pg_idkit_17 pg_idkit_17-0.4.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.4.0 · 1.0MiB	PIGSTY 0.4.0 el8.aarch64.pg16 : pg_idkit_16 pg_idkit_16-0.4.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.4.0 · 1.0MiB	PIGSTY 0.4.0 el8.aarch64.pg15 : pg_idkit_15 pg_idkit_15-0.4.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.4.0 · 1021.1KiB	PIGSTY 0.4.0 el8.aarch64.pg14 : pg_idkit_14 pg_idkit_14-0.4.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.4.0 · 1018.9KiB
el9.x86_64	PIGSTY 0.4.0 el9.x86_64.pg18 : pg_idkit_18 pg_idkit_18-0.4.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el9.x86_64.pg17 : pg_idkit_17 pg_idkit_17-0.4.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el9.x86_64.pg16 : pg_idkit_16 pg_idkit_16-0.4.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el9.x86_64.pg15 : pg_idkit_15 pg_idkit_15-0.4.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el9.x86_64.pg14 : pg_idkit_14 pg_idkit_14-0.4.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB
el9.aarch64	PIGSTY 0.4.0 el9.aarch64.pg18 : pg_idkit_18 pg_idkit_18-0.4.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el9.aarch64.pg17 : pg_idkit_17 pg_idkit_17-0.4.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el9.aarch64.pg16 : pg_idkit_16 pg_idkit_16-0.4.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el9.aarch64.pg15 : pg_idkit_15 pg_idkit_15-0.4.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el9.aarch64.pg14 : pg_idkit_14 pg_idkit_14-0.4.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.4.0 · 1.1MiB
el10.x86_64	PIGSTY 0.4.0 el10.x86_64.pg18 : pg_idkit_18 pg_idkit_18-0.4.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el10.x86_64.pg17 : pg_idkit_17 pg_idkit_17-0.4.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el10.x86_64.pg16 : pg_idkit_16 pg_idkit_16-0.4.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el10.x86_64.pg15 : pg_idkit_15 pg_idkit_15-0.4.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB	PIGSTY 0.4.0 el10.x86_64.pg14 : pg_idkit_14 pg_idkit_14-0.4.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.4.0 · 1.1MiB
el10.aarch64	PIGSTY 0.4.0 el10.aarch64.pg18 : pg_idkit_18 pg_idkit_18-0.4.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.4.0 · 1.0MiB	PIGSTY 0.4.0 el10.aarch64.pg17 : pg_idkit_17 pg_idkit_17-0.4.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.4.0 · 1.0MiB	PIGSTY 0.4.0 el10.aarch64.pg16 : pg_idkit_16 pg_idkit_16-0.4.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.4.0 · 1.0MiB	PIGSTY 0.4.0 el10.aarch64.pg15 : pg_idkit_15 pg_idkit_15-0.4.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.4.0 · 1.0MiB	PIGSTY 0.4.0 el10.aarch64.pg14 : pg_idkit_14 pg_idkit_14-0.4.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.4.0 · 1.0MiB
d12.x86_64	PIGSTY 0.4.0 d12.x86_64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.4.0 · 910.5KiB	PIGSTY 0.4.0 d12.x86_64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.4.0 · 908.0KiB	PIGSTY 0.4.0 d12.x86_64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.4.0 · 907.6KiB	PIGSTY 0.4.0 d12.x86_64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.4.0 · 902.1KiB	PIGSTY 0.4.0 d12.x86_64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.4.0 · 899.5KiB
d12.aarch64	PIGSTY 0.4.0 d12.aarch64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.4.0 · 788.3KiB	PIGSTY 0.4.0 d12.aarch64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.4.0 · 787.1KiB	PIGSTY 0.4.0 d12.aarch64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.4.0 · 786.8KiB	PIGSTY 0.4.0 d12.aarch64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.4.0 · 781.6KiB	PIGSTY 0.4.0 d12.aarch64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.4.0 · 779.8KiB
d13.x86_64	PIGSTY 0.4.0 d13.x86_64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.4.0 · 909.9KiB	PIGSTY 0.4.0 d13.x86_64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.4.0 · 908.2KiB	PIGSTY 0.4.0 d13.x86_64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.4.0 · 907.5KiB	PIGSTY 0.4.0 d13.x86_64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.4.0 · 901.7KiB	PIGSTY 0.4.0 d13.x86_64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.4.0 · 899.9KiB
d13.aarch64	PIGSTY 0.4.0 d13.aarch64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.4.0 · 788.8KiB	PIGSTY 0.4.0 d13.aarch64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.4.0 · 787.9KiB	PIGSTY 0.4.0 d13.aarch64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.4.0 · 788.2KiB	PIGSTY 0.4.0 d13.aarch64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.4.0 · 782.4KiB	PIGSTY 0.4.0 d13.aarch64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.4.0 · 781.0KiB
u22.x86_64	PIGSTY 0.4.0 u22.x86_64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.4.0 · 1004.9KiB	PIGSTY 0.4.0 u22.x86_64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.4.0 · 1001.8KiB	PIGSTY 0.4.0 u22.x86_64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.4.0 · 1002.4KiB	PIGSTY 0.4.0 u22.x86_64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.4.0 · 993.7KiB	PIGSTY 0.4.0 u22.x86_64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.4.0 · 991.8KiB
u22.aarch64	PIGSTY 0.4.0 u22.aarch64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.4.0 · 919.3KiB	PIGSTY 0.4.0 u22.aarch64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.4.0 · 917.8KiB	PIGSTY 0.4.0 u22.aarch64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.4.0 · 917.0KiB	PIGSTY 0.4.0 u22.aarch64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.4.0 · 910.7KiB	PIGSTY 0.4.0 u22.aarch64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.4.0 · 908.5KiB
u24.x86_64	PIGSTY 0.4.0 u24.x86_64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.4.0 · 993.6KiB	PIGSTY 0.4.0 u24.x86_64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.4.0 · 991.6KiB	PIGSTY 0.4.0 u24.x86_64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.4.0 · 990.7KiB	PIGSTY 0.4.0 u24.x86_64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.4.0 · 983.6KiB	PIGSTY 0.4.0 u24.x86_64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.4.0 · 981.7KiB
u24.aarch64	PIGSTY 0.4.0 u24.aarch64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.4.0 · 910.2KiB	PIGSTY 0.4.0 u24.aarch64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.4.0 · 909.3KiB	PIGSTY 0.4.0 u24.aarch64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.4.0 · 907.8KiB	PIGSTY 0.4.0 u24.aarch64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.4.0 · 901.6KiB	PIGSTY 0.4.0 u24.aarch64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.4.0 · 899.9KiB
u26.x86_64	PIGSTY 0.4.0 u26.x86_64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.4.0 · 990.4KiB	PIGSTY 0.4.0 u26.x86_64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.4.0 · 988.5KiB	PIGSTY 0.4.0 u26.x86_64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.4.0 · 988.4KiB	PIGSTY 0.4.0 u26.x86_64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.4.0 · 979.0KiB	PIGSTY 0.4.0 u26.x86_64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.4.0 · 978.8KiB
u26.aarch64	PIGSTY 0.4.0 u26.aarch64.pg18 : postgresql-18-pg-idkit postgresql-18-pg-idkit_0.4.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.4.0 · 908.0KiB	PIGSTY 0.4.0 u26.aarch64.pg17 : postgresql-17-pg-idkit postgresql-17-pg-idkit_0.4.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.4.0 · 905.7KiB	PIGSTY 0.4.0 u26.aarch64.pg16 : postgresql-16-pg-idkit postgresql-16-pg-idkit_0.4.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.4.0 · 906.2KiB	PIGSTY 0.4.0 u26.aarch64.pg15 : postgresql-15-pg-idkit postgresql-15-pg-idkit_0.4.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.4.0 · 899.6KiB	PIGSTY 0.4.0 u26.aarch64.pg14 : postgresql-14-pg-idkit postgresql-14-pg-idkit_0.4.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.4.0 · 896.7KiB

Build

You can build the RPM / DEB packages for pg_idkit using pig build:

pig build pkg pg_idkit         # build RPM / DEB packages

Install

You can install pg_idkit directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

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

Install the extension using pig or apt/yum/dnf:

Install

pig install pg_idkit;          # Install for current active PG version

pig

pig ext install -y pg_idkit -v 18  # PG 18
pig ext install -y pg_idkit -v 17  # PG 17
pig ext install -y pg_idkit -v 16  # PG 16
pig ext install -y pg_idkit -v 15  # PG 15
pig ext install -y pg_idkit -v 14  # PG 14

dnf

dnf install -y pg_idkit_18       # PG 18
dnf install -y pg_idkit_17       # PG 17
dnf install -y pg_idkit_16       # PG 16
dnf install -y pg_idkit_15       # PG 15
dnf install -y pg_idkit_14       # PG 14

apt

apt install -y postgresql-18-pg-idkit   # PG 18
apt install -y postgresql-17-pg-idkit   # PG 17
apt install -y postgresql-16-pg-idkit   # PG 16
apt install -y postgresql-15-pg-idkit   # PG 15
apt install -y postgresql-14-pg-idkit   # PG 14

Create Extension:

CREATE EXTENSION pg_idkit;

Usage

pg_idkit: multi-tool for generating new/niche universally unique identifiers

CREATE EXTENSION pg_idkit;
SELECT idkit_uuidv7_generate();

Available Functions

Methodology	Function	Description
UUID v6	`idkit_uuidv6_generate()`	UUID v6 (RFC 4122)
	`idkit_uuidv6_generate_uuid()`	UUID v6 as native UUID type
	`idkit_uuidv6_extract_timestamptz(TEXT)`	Extract timestamp from UUID v6
UUID v7	`idkit_uuidv7_generate()`	UUID v7 (RFC 4122)
	`idkit_uuidv7_generate_uuid()`	UUID v7 as native UUID type
	`idkit_uuidv7_extract_timestamptz(TEXT)`	Extract timestamp from UUID v7
NanoID	`idkit_nanoid_generate()`	NanoID
	`idkit_nanoid_custom_generate_text()`	NanoID with custom length and alphabet
KSUID	`idkit_ksuid_generate()`	K-Sortable UID
	`idkit_ksuid_extract_timestamptz(TEXT)`	Extract timestamp from KSUID
	`idkit_ksuidms_generate()`	KSUID with millisecond precision
	`idkit_ksuidms_extract_timestamptz(TEXT)`	Extract timestamp from KSUID-ms
ULID	`idkit_ulid_generate()`	Universally Unique Lexicographically Sortable ID
	`idkit_ulid_extract_timestamptz(TEXT)`	Extract timestamp from ULID
Timeflake	`idkit_timeflake_generate()`	Snowflake + Instagram ID + Firebase PushID
	`idkit_timeflake_extract_timestamptz(TEXT)`	Extract timestamp from Timeflake
PushID	`idkit_pushid_generate()`	Google Firebase PushID
XID	`idkit_xid_generate()`	XID
	`idkit_xid_extract_timestamptz(TEXT)`	Extract timestamp from XID
CUID	`idkit_cuid_generate()`	CUID (deprecated)
	`idkit_cuid_extract_timestamptz(TEXT)`	Extract timestamp from CUID
CUID2	`idkit_cuid2_generate()`	CUID2
	`idkit_cuid2_generate_with_len(length)`	CUID2 with custom length
TypeID	`idkit_typeid_generate(TEXT)`	TypeID with prefix and UUIDv7
	`idkit_typeid_generate_text(TEXT)`	TypeID as text
	`idkit_typeid_from_uuid_v7(TEXT, TEXT)`	TypeID from a given UUID v7
	`idkit_typeid_extract_timestamptz(TEXT)`	Extract timestamp from TypeID

Examples

-- Generate different ID types
SELECT idkit_uuidv7_generate();           -- 018c106f-9304-79bb-b5be-4483b92b036c
SELECT idkit_nanoid_generate();            -- A8jFA0r3NC6FdalR4LEJ0
SELECT idkit_ksuid_generate();             -- 2HMQIBkTJmEN11JI7tvSTMwfYI3
SELECT idkit_ulid_generate();              -- 01HPYV2X17GM5SQP22M3DVFZY3
SELECT idkit_cuid2_generate();             -- clrjx3bwh0000fj3x4c2y1z0s

-- Extract timestamp
SELECT idkit_uuidv7_extract_timestamptz('018c106f-9304-79bb-b5be-4483b92b036c');

pg_idkit

Overview

Version

Build

Install

Usage

Available Functions

Examples

Was this page helpful?