select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Functions and aggregates

snowflake

Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL

pgext.cloud · Source code · Website · License text · Control file

Overview

Packagesnowflake
Version2.5.0
PostgreSQL versions15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeStandard
Distributionpgedge
VendorpgEdge
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemasnowflake
Stars95
Latest commit2026-08-25
Latest release2026-07-21
Catalogue updated2026-08-30

Related extensions

See also

pg_uuidv7Create UUIDv7 values in postgres
sequential_uuidsgenerator of sequential UUIDs
pg_idkitmulti-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pgx_ulidulid type and methods
pg_uuid_v8UUID v8 generator with embedded timestamps for PostgreSQL
uuid-osspgenerate universally unique identifiers (UUIDs)
typeidAllows to use TypeIDs in Postgres natively
permuteseqPseudo-randomly permute sequences with a format-preserving encryption on elements