select open change scope Open full search

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

Extensions / Functions and aggregates

short_ids

PL/pgSQL generator for short random text IDs with collision checks and transaction advisory locks.

pgext.cloud · Source code · Website · Documentation · Control file

Overview

Packageshort_ids
Version0.1.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Project statusUnmaintained
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars3
Latest commit2017-02-06
Latest release2017-02-06
Catalogue updated2026-07-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

randomstringrandomstring: generate pseudo-random text and bytea values
pg_hashidsShort unique id generator for PostgreSQL, using hashids
pgquePure SQL PostgreSQL job queue that orders jobs by priority and claims them with advisory locks.
nextidGenerate Instagram-style sharded integer IDs.
snowflakeSnowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
sequential_uuidsgenerator of sequential UUIDs
pg_snowflake_idSnowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx
pg_lock_poolWait on a PostgreSQL advisory lock pool
pg_rand_extFunctions that generate random values for PostgreSQL
pg_testgenGenerate random integers, strings, and test-data rows for PostgreSQL development
base62Base62 extension for PostgreSQL