select open change scope Open full search

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

Extensions / Data types

uniqueidentifier

Legacy 16-byte uniqueidentifier data type, comparison operators, casts, and newid() generation for PostgreSQL.

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

Overview

Packageuniqueidentifier
Version1.0
PostgreSQL versions16
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemapublic
Stars1
Latest commit2024-03-20
Latest release2024-03-20
Catalogue updated2026-08-30

Related extensions

See also

ulidEmbedded pgrx ULID type, generators, and casts
uuid47UUIDv7 storage with keyed UUIDv4-looking façade I/O
upid_pgPrefixed, sortable 128-bit identifier type and generator
ruidCompact 22-character Base64 representation of PostgreSQL UUID values.
suuidsmall UUID
uuidv7-sqlPure SQL and PL/pgSQL functions for generating, inspecting, and transforming UUID version 7 values.
uidsPostgreSQL extension to generate various types of universally unique IDs
pgx_uuidv7A PostgreSQL extension to generate and cast v7 UUIDs