select open change scope Open full search

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

Extensions / Functions and aggregates

pg_gen_uid

Adds a PL/pgSQL function that generates random lowercase alphanumeric identifiers using pgcrypto.

pgext.cloud · Source code · Control file

Overview

Packagepg_gen_uid
Version0.0.1
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemapublic
Stars0
Latest commit2018-10-16
Catalogue updated2026-08-30

Related extensions

Requires

pgcryptocryptographic functions
plpgsqlPL/pgSQL procedural language

See also

xataid_extensionGenerate Xata-style rec_ identifiers with a 20-character lowercase alphanumeric suffix.
xata_id_extensionGenerate Xata-style rec_ identifiers with a 20-character lowercase alphanumeric suffix.
pgrandGenerates random test data through a PostgreSQL FDW, with an experimental table access method.