Search PostgreSQL documentation

uniphantExtensionsExtensionsPostgreSQL-centric authentication and authorization demo integrating WebAuthn, PostgREST, and role-based access control. authentication authorization postgrest rbac webauthn uniphant Securit…Security · Extensions unique_idExtensionsExtensionsTime-based K-sorted unique identifier generators inspired by Instagram and Sonyflake designs. id k-sorted sonyflake instagram unique_id Functions and aggregatesFunctions and aggregates · Extensions uniqueidentifierExtensionsExtensionsLegacy 16-byte uniqueidentifier data type, comparison operators, casts, and newid() generation for PostgreSQL. data-type unique-identifier uuid uniqueidentifier Data typesData types · Extensions unitExtensionsExtensionsSI units extension pgunit Data typesData types · Extensions unitsExtensionsExtensionsUnit conversion table and PL/pgSQL conversion function for length units. unit-conversion units Functions and aggregatesFunctions and aggregates · Extensions unnest_ordinalityExtensionsExtensionsLegacy array unnest function that returns each element with its ordinal position. array ordinality row-number set-returning-function unnest unnest_ordinality Functions and aggregatesFunctions and aggregates · Extensions upid_pgExtensionsExtensionsPrefixed, sortable 128-bit identifier type and generator data-type identifier pgrx upid uuid upid_pg Data typesData types · Extensions uriExtensionsExtensionsURI Data type for PostgreSQL pg_uri Data typesData types · Extensions urlExtensionsExtensionsSQL and PL/pgSQL types and helper functions for URL parsing, encoding, decoding, and query-string key/value handling. encoding parsing query-string url url Data typesData types · Extensions url_encodeExtensionsExtensionsurl_encode, url_decode functions url_encode UtilitiesUtilities · Extensions us-statesExtensionsExtensionspgpm demo for the Postgres Conference 2026 us-states FeaturesFeatures · Extensions user_infoExtensionsExtensionsProvides user-related information including owned objects and granted roles. administration ownership roles user_info SecuritySecurity · Extensions utilsExtensionsExtensionsMinimal C extension example providing integer addition and multiplication functions. arithmetic c-extension example learning scalar-functions utils Functions and aggregatesFunctions and aggregates · Extensions utinyintExtensionsExtensionsOne-byte unsigned integer type with casts to smallint, integer, and boolean. datatype integer utinyint utinyint Data typesData types · Extensions uuid-freebsdExtensionsExtensionsUUID generation functions for PostgreSQL on FreeBSD. freebsd uuid uuid-freebsd Functions and aggregatesFunctions and aggregates · Extensions uuid-osspExtensionsPG18F.49. uuid-ossp — a UUID generator The uuid-ossp module provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms. There are also functio…uuid-ossp — a UUID generator uuid47ExtensionsExtensionsUUIDv7 storage with keyed UUIDv4-looking façade I/O brin btree data-type hash-index siphash uuid uuidv4 uuidv7 uuid47 Data typesData types · Extensions uuidv7-sqlExtensionsExtensionsPure SQL and PL/pgSQL functions for generating, inspecting, and transforming UUID version 7 values. uuid uuidv7 postgres-uuidv7-sql Functions and aggregatesFunctions and aggregates · Extensions vacuum_statisticsExtensionsExtensionsShared-memory table, database, and index statistics for VACUUM activity. vacuum statistics shared-memory monitoring vacuum_statistics MonitoringMonitoring · Extensions vacuum_utilsExtensionsExtensionsSQL functions for inspecting VACUUM and ANALYZE thresholds and activity and for invoking table maintenance. info maintenance vacuum_utils AdministrationAdministration · Extensions validadoresExtensionsExtensionsBrazilian CPF check-digit validator, operator, and domain brazilian-identifiers cnpj cpf validator validadores Functions and aggregatesFunctions and aggregates · Extensions valkey_fdwExtensionsExtensionsForeign data wrapper for querying a Valkey server fdw valkey valkey_fdw Foreign data wrappersForeign data wrappers · Extensions varbitxExtensionsExtensionsAlibaba Cloud RDS bitmap function extension for additional varbit operations bitmap bitstring vendor varbitx Functions and aggregatesFunctions and aggregates · Extensions variantExtensionsExtensionsVariant data type that can store values from other PostgreSQL types. data-type variant variant Data typesData types · Extensions varintExtensionsExtensionsA signed and unsigned 64 bit integer encoding scheme that saves disk space variable width integer encoding varint varint64 varuint varuint64 varint Data typesData types · Extensions varlena_alignmentExtensionsExtensionspgrx test extension documenting varlena alignment behavior in pgrx set_varsize helpers. alignment pgrx test unsafe varlena_alignment FeaturesFeatures · Extensions vasavgeomExtensionsExtensionsVague geometry handler - VASA geometry postgis spatial vaguegeometry GeospatialGeospatial · Extensions vascoExtensionsExtensionsdiscover hidden correlations in your data with MIC beta vasco Functions and aggregatesFunctions and aggregates · Extensions vastbase_sm4ExtensionsExtensionsSM4 encryption/decryption functions for VastBase using Java implementation via JNI vastbase_sm4 SecuritySecurity · Extensions vchordExtensionsExtensionsVector database plugin for Postgres, written in Rust pgrx vchord AI and vectorsAI and vectors · Extensions vchord_bm25ExtensionsExtensionsA postgresql extension for bm25 ranking algorithm pgrx vchord_bm25 Full-text searchFull-text search · Extensions vectoraggExtensionsExtensionsFloat-array range sum, clamp, and decimation functions aggregation array decimation float4 float8 vectoragg Functions and aggregatesFunctions and aggregates · Extensions vectorizeExtensionsExtensionsThe simplest way to do vector search on Postgres pgrx pg_vectorize AI and vectorsAI and vectors · Extensions vectorize_engineExtensionsExtensionsVectorized query execution extension for PostgreSQL custom-scan preload query-execution vectorized vectorize_engine AnalyticsAnalytics · Extensions vectorsExtensionsExtensionsVector database plugin for PostgreSQL, written in Rust, specifically designed for LLM pgrx vector-search vectors AI and vectorsAI and vectors · Extensions vectorscaleExtensionsExtensionsAdvanced indexing for vector data with DiskANN pgrx pgvectorscale AI and vectorsAI and vectors · Extensions veil2ExtensionsExtensionsProvides the basis for a Virtual Private Database implementation. security virtual private database veil2 SecuritySecurity · Extensions veil2_demoExtensionsExtensionsProvides a demo database for the veil2 extension. security virtual private database veil2 SecuritySecurity · Extensions veil2_minimal_demoExtensionsExtensionsProvides a minimal but complete demo database for the veil2 extension. security virtual private database veil2 SecuritySecurity · Extensions vercompExtensionsExtensionsDeprecated semantic-version data type and comparison operators btree data-type hash-index semver version vercomp Data typesData types · Extensions