Search PostgreSQL documentation

pgbrtypesExtensionsExtensionsBrazilian CPF and CNPJ data types with validation, formatting, casts, and indexing support pgbrtypes Data typesData types · Extensions pgbsonExtensionsExtensionsBSON data type and accessor functions for PostgreSQL bson json jsonb complex structures data type pgbson Data typesData types · Extensions pgbullyExtensionsExtensionsBully-algorithm leader election among PostgreSQL nodes leader-election coordination pgbully AdministrationAdministration · Extensions pgc_fdwExtensionsExtensionsAccess remote PostgreSQL tables through a postgres_fdw-derived wrapper with a FoundationDB-backed query cache cache fdw foundationdb postgresql pgc_fdw Foreign data wrappersForeign data wrappers · Extensions pgcacheExtensionsExtensionsSQL key/value cache with JSONB values and expiration cache key-value ttl pgeverything UtilitiesUtilities · Extensions pgcalendarExtensionsExtensionsRecurring calendar, schedule, and exception management for PostgreSQL pgcalendar Data typesData types · Extensions pgcaptureExtensionsExtensionsA scalable Netflix DBLog implementation for PostgreSQL backup cdc change-data-capture database dblog event-driven grpc logical-replicas migration netflix-dblog pglogical postgres postgresql …Replication and streams · Extensions pgcatExtensionsExtensionsEnhanced logical replication extension for per-table subscriptions, table mapping, and replica-identity tracking. logical-replication per-table replication table-mapping pgcat-pgxs Replicati…Replication and streams · Extensions pgchem_tigressExtensionsExtensionsLegacy molecule types, chemical fingerprints, operators, and GiST indexing. chemistry molecule fingerprint gist pgchem_tigress FeaturesFeatures · Extensions pgchessExtensionsExtensionsA Chess extension chess pgchess FeaturesFeatures · Extensions pgchronosExtensionsExtensionsSQL functions and operators for union, intersection, and difference over daterange and tstzrange arrays. pgchronos Time seriesTime series · Extensions pgchy_similarityExtensionsExtensionsChemical structure similarity functions for PostgreSQL using Chython and PL/Python. pgchy_similarity AI and vectorsAI and vectors · Extensions pgckExtensionsExtensionsConcept Kernel runtime with NATS transport, SHACL validation, and RDF materialization. concept-kernel nats shacl rdf pgck FeaturesFeatures · Extensions pgclawExtensionsExtensionsStore LLM or OpenClaw agents as PostgreSQL values and process watched rows with a background worker ai background-worker llm openclaw pgrx pgclaw AI and vectorsAI and vectors · Extensions pgcloneExtensionsExtensionsClone PostgreSQL databases, schemas, tables, and functions across environments pgclone Replication and streamsReplication and streams · Extensions pgcmpExtensionsExtensionsSupport extension for pg_comparator, providing checksum and cast functions for PostgreSQL data comparison. checksum compare etl pg_comparator Replication and streamsReplication and streams · Extensions pgcodec7ExtensionsExtensionsC extension that encodes and decodes bytea values using compact 7-bit or 6-bit text grouping. bytea codec encoding pgcodec7 UtilitiesUtilities · Extensions pgcolumnarExtensionsExtensionsNative column-oriented table access method with compression, vectorized scans, and Parquet workflows. columnar table-am compression analytics pgcolumnar AnalyticsAnalytics · Extensions pgcompressExtensionsExtensionsProvides deflate, inflate, gzip, and Brotli compression functions for bytea, text, json, and jsonb. pgcompress UtilitiesUtilities · Extensions pgcontextExtensionsExtensionsVector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables. vector hnsw postgresql retrieval rust pgrx pgcontext AI and vectorsAI and vectors · Extensions pgcontext_pgvectorExtensionsExtensionsOptional pgvector compatibility bridge for pgcontext HNSW indexes. vector hnsw postgresql retrieval rust pgrx pgcontext AI and vectorsAI and vectors · Extensions pgcovExtensionsExtensionsTracks test coverage in PL/PgSQL functions and requires shared_preload_libraries. coverage plpgsql testing pgcov Procedural languagesProcedural languages · Extensions pgcozyExtensionsExtensionsPre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. pgcozy AdministrationAdministration · Extensions pgcrypsiExtensionsExtensionsC Crypsi (https://github.com/telkomdev/c-crypsi) PostgreSQL Extension aes aes-gcm c crypto postgresql-extension pgcrypsi SecuritySecurity · Extensions pgcryptoExtensionsPG18F.26. pgcrypto — cryptographic functions The pgcrypto module provides cryptographic functions for PostgreSQL. This module is considered “trusted”, that is, it can be installed by non-superus…pgcrypto — cryptographic functions pgcryptokeyExtensionsExtensionscryptographic key management pgdg-flaw pgcryptokey SecuritySecurity · Extensions pgcuid2ExtensionsExtensionsGenerate CUID2 text identifiers inside PostgreSQL using the cuid2 Rust crate. cuid id-generator pgrx pgcuid2 Functions and aggregatesFunctions and aggregates · Extensions pgcurlExtensionsExtensionsCalls curl/libcurl from PostgreSQL through a SQL function. pgcurl UtilitiesUtilities · Extensions pgdamExtensionsExtensionsAWS Aurora PostgreSQL provider extension listed as pgdam version 1.7 for Aurora PostgreSQL 16 and 17. aws-aurora provider-only pgdam AdministrationAdministration · Extensions pgddExtensionsExtensionsIntrospect pg data dictionary via standard SQL pgrx pgdd AdministrationAdministration · Extensions pgdisablelogerrorExtensionsExtensionsDisable selected SQLSTATE error codes from PostgreSQL server logging. log error preload pgdisablelogerror AdministrationAdministration · Extensions pgdlExtensionsExtensionsPostgreSQL extension for deep learning model inference and vector storage inside the database. pgdl AI and vectorsAI and vectors · Extensions pgdmnExtensionsExtensionsDMN decision-model and FEEL expression evaluation inside PostgreSQL. dmn feel rules decision-table pgdmn FeaturesFeatures · Extensions pgdsExtensionsExtensionsdynamic statistics analyze dynamic statistics pgds AdministrationAdministration · Extensions pgduck_rsExtensionsExtensionspgrx prototype extension that uses DuckDB to read Parquet files and return rows as JSONB in PostgreSQL. duckdb parquet pgrx prototype pgduck_rs AnalyticsAnalytics · Extensions pgedge_safesessionExtensionsExtensionsEnforce read-only sessions for specified PostgreSQL roles. pgedge_safesession SecuritySecurity · Extensions pgedge_vectorizerExtensionsExtensionsAsynchronous text chunking and embedding generation for PostgreSQL using background workers and pgvector. background-worker embeddings rag vector-search pgedge_vectorizer AI and vectorsAI and vectors · Extensions pgelogExtensionsExtensionsExtended logging via pseudo-autonomous transactions pgelog AdministrationAdministration · Extensions pgembedExtensionsExtensionsGenerate vector embeddings through Ollama, OpenAI, or custom HTTP services embedding http python pgembed AI and vectorsAI and vectors · Extensions pgerrorExtensionsExtensionsTools for better error handling catch error exception try pgerror UtilitiesUtilities · Extensions