select open change scope Open full search

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

Extensions / Functions and aggregates

uuid-ossp

generate universally unique identifiers (UUIDs)

pgext.cloud · Website · Documentation · License text · Control file

Overview

Packageuuid-ossp
Version1.1
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPostgreSQL contrib
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedYes
Latest commit2026-05-14
Latest release2026-05-14
Catalogue updated2026-07-29

Related extensions

Required by

babelfishpg_tsqlSQL Server Transact SQL compatibility
bundledata version control system
datalinkSQL/MED DATALINK data type and functions for controlled access to files outside PostgreSQL
launchql-extension-verifyPostgreSQL verification utilities
launchql-inflectioninflection is a port of the functionality from Ruby on Rails' Active Support Inflection classes into PostgreSQL
launchql-jwt-claimslaunchql-jwt-claims extension
npmSchema and tables for tracking npm package metadata and daily download counts.
pg_abrisAbris metadata extension that creates a meta schema with metadata tables, views, and helper functions.
pg_dmsDocument management system with custom ID, family, and reference types plus action tracking and JSON registry helpers.
provsqlSemiring provenance and probability management for PostgreSQL
ruidCompact 22-character Base64 representation of PostgreSQL UUID values.
skitch-extension-jobsAn asynchronous job queue schema for ACID compliant job creation
skitch-extension-verifyPL/pgSQL catalog-verification functions for checking PostgreSQL objects, roles, privileges, policies, and other schema properties.
supa_auditTrigger-based table audit history with stable UUID record identities and JSONB row versions.
typesReusable domains for attachments, email addresses, hostnames, images, uploads, and URLs.

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
snowflakeSnowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
pg_uuid_v8UUID v8 generator with embedded timestamps for PostgreSQL
typeidAllows to use TypeIDs in Postgres natively