Extensions / Functions and aggregates
generate universally unique identifiers (UUIDs)
pgext.cloud · Website · Documentation · License text · Control file
| Package | uuid-ossp |
|---|---|
| Version | 1.1 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PostgreSQL contrib |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | Yes |
| Latest commit | 2026-05-14 |
| Latest release | 2026-05-14 |
| Catalogue updated | 2026-07-29 |
| babelfishpg_tsql | SQL Server Transact SQL compatibility |
| bundle | data version control system |
| datalink | SQL/MED DATALINK data type and functions for controlled access to files outside PostgreSQL |
| launchql-extension-verify | PostgreSQL verification utilities |
| launchql-inflection | inflection is a port of the functionality from Ruby on Rails' Active Support Inflection classes into PostgreSQL |
| launchql-jwt-claims | launchql-jwt-claims extension |
| npm | Schema and tables for tracking npm package metadata and daily download counts. |
| pg_abris | Abris metadata extension that creates a meta schema with metadata tables, views, and helper functions. |
| pg_dms | Document management system with custom ID, family, and reference types plus action tracking and JSON registry helpers. |
| provsql | Semiring provenance and probability management for PostgreSQL |
| ruid | Compact 22-character Base64 representation of PostgreSQL UUID values. |
| skitch-extension-jobs | An asynchronous job queue schema for ACID compliant job creation |
| skitch-extension-verify | PL/pgSQL catalog-verification functions for checking PostgreSQL objects, roles, privileges, policies, and other schema properties. |
| supa_audit | Trigger-based table audit history with stable UUID record identities and JSONB row versions. |
| types | Reusable domains for attachments, email addresses, hostnames, images, uploads, and URLs. |
| pg_uuidv7 | Create UUIDv7 values in postgres |
| sequential_uuids | generator of sequential UUIDs |
| pg_idkit | multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) |
| pgx_ulid | ulid type and methods |
| snowflake | Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL |
| pg_uuid_v8 | UUID v8 generator with embedded timestamps for PostgreSQL |
| typeid | Allows to use TypeIDs in Postgres natively |