select open change scope Open full search

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

Extensions / Functions and aggregates

nextid

Generate Instagram-style sharded integer IDs.

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

Overview

Packagepg_nextid
Version0.1
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars3
Latest commit2020-03-02
Latest release2019-10-17
Catalogue updated2026-08-30

Related extensions

See also

snowflakeSnowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
pg_snowflake_idSnowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx
sequential_uuidsgenerator of sequential UUIDs
short_idsPL/pgSQL generator for short random text IDs with collision checks and transaction advisory locks.
pgcuid2Generate CUID2 text identifiers inside PostgreSQL using the cuid2 Rust crate.
uuid-osspgenerate universally unique identifiers (UUIDs)
pgx_ulidulid type and methods
pg_idkitmulti-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)