Search PostgreSQL documentation

pg_decode_infomaskExtensionsExtensionsAdministration · ExtensionsPostgreSQL 9.6 C functions that decode heap tuple infomask and infomask2 hint bits into queryable fields. heap infomask tuple-header pg_decode_infomask Administration pg_decode_recordExtensionsExtensionsAdministration · ExtensionsHacky extension to extract SQL from WAL INSERT records; Originally from https://github.com/rjuju pg_decode_record Administration pg_deeplakeExtensionsExtensionsAI and vectors · ExtensionsDeeplake is AI Data Runtime for Agents. It provides serverless postgres with a multimodal datalake, enabling scalable retrieval and training. agent agentic-rag ai clawbot computer-vision dat… pg_default_aclManual ChaptersPG18The catalog pg_default_acl stores initial privileges to be assigned to newly created objects. Table 52.17. pg_default_acl Columns Column Type Description oid oid Row identifier defaclrole oi… pg_deltaExtensionsExtensionsReplication and streams · ExtensionsDelta Lake streaming integration for PostgreSQL pg_delta Replication and streams pg_delta_amExtensionsExtensionsAnalytics · ExtensionsDelta table access method skeleton iceberg lakebase lakehouse postgresql postgresql-extension pg_delta_am Analytics pg_deltaxExtensionsExtensionsTime series · ExtensionsFast time-series extension for PostgreSQL compression pgrx postgres postgresql postgresql-extension rust time-series pg_deltax Time series pg_dependManual ChaptersPG18The catalog pg_depend records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dropped by DROP CASCADE or prev… pg_deribitExtensionsExtensionsFeatures · ExtensionsSQL wrapper for Deribit public and authenticated JSON-RPC APIs http api pg_deribit Features pg_describeExtensionsExtensionsUtilities · ExtensionsReport a query's parameters and result columns without executing it types introspection typescript codegen developer tools pg_describe Utilities pg_descriptionManual ChaptersPG18The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command and viewed with psql's \d commands. Desc… pg_diffixExtensionsExtensionsSecurity · ExtensionsProvides strong dynamic anonymization for PostgreSQL query results. anonymization privacy pg_diffix Security pg_digestExtensionsExtensionsData types · ExtensionsData type for efficient storage of hash digests in PostgreSQL. pg_digest Data types pg_dirty_handsExtensionsExtensionsAdministration · ExtensionsProvides functions to freeze individual heap tuples, including an unlogged variant. freeze storage tuple pg_dirty_hands Administration pg_dirtyreadExtensionsExtensionsAdministration · ExtensionsRead dead but unvacuumed rows from table pg_dirtyread Administration pg_diskannExtensionsExtensionsAI and vectors · ExtensionsAzure Database for PostgreSQL extension for DiskANN approximate-nearest-neighbor vector indexes. pg_diskann AI and vectors pg_disorderExtensionsExtensionsFeatures · ExtensionsPerturb unordered SELECT row order to expose order-dependent tests testing flaky tests order by random planner hook debugging pg_disorder Features pg_dispatchExtensionsExtensionsTime series · ExtensionsAsynchronous SQL dispatcher built on pg_cron pg_dispatch Time series pg_dmsExtensionsExtensionsFeatures · ExtensionsDocument management system with custom ID, family, and reference types plus action tracking and JSON registry helpers. custom-type document-management registry pg_dms Features pg_doc_storeExtensionsExtensionsFeatures · ExtensionsProvides a JSONB document-store API with full-text search. document-store full-text-search jsonb pg_doc_store Features pg_documentdb_gw_hostExtensionsExtensionsCompatibility · Extensionspg documentdb gw host: Created by pgrx pgrx rust pg_documentdb_gw_host Compatibility pg_documentsExtensionsExtensionsFeatures · ExtensionsJSON access via HTTP server pg_documents Features pg_dphypExtensionsExtensionsFeatures · ExtensionsPreload-only DPHyp hypergraph dynamic-programming join enumeration algorithm for PostgreSQL. pg_dphyp Features pg_drop_eventsExtensionsExtensionsAdministration · Extensionslogs transaction ids of drop table, drop column, drop materialized view statements pg_drop_events Administration pg_dropbuffersExtensionsExtensionsFeatures · ExtensionsDrop PostgreSQL shared buffers and the operating-system page cache for testing buffer-cache cache-eviction testing pg_dropbuffers Features pg_dropcacheExtensionsExtensionsAdministration · ExtensionsInvalidate PostgreSQL shared_buffers cache for a database or relation buffer-cache cache-eviction shared-buffers pg_dropcache Administration pg_dtmExtensionsExtensionsAdministration · ExtensionsPluggable distributed transaction manager using shared global snapshots distributed-transaction dtm shared-preload pg_dtm Administration pg_duckdbExtensionsExtensionsAnalytics · ExtensionsDuckDB Embedded in Postgres duckdb pg_duckdb Analytics pg_ducklakeExtensionsExtensionsAnalytics · ExtensionsDuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet duckdb pg_ducklake Analytics pg_duckpipeExtensionsExtensionsReplication and streams · ExtensionsCDC synchronization from heap tables to DuckLake columnar tables cdc ducklake logical-replication pgrx pg_duckpipe Replication and streams pg_dumpManual ChaptersPG18export a PostgreSQL database as an SQL script or to other formats Synopsis pg_dump [connection-option...] [option...] [dbname] pg_dump --attribute-insertsCommand-line ToolsPG18pg_dump › Optionscolumn-inserts--attribute-inserts Dump data as INSERT commands with explicit column names (INSERT INTO table (column, ...) VALUES ...). This will make restoration very slow; it is mainly use… pg_dump --binary-upgradeCommand-line ToolsPG18pg_dump › Optionsbinary-upgrade This option is for use by in-place upgrade utilities. Its use for other purposes is not recommended or supported. The behavior of the option may change in future releases with… pg_dump --blobsCommand-line ToolsPG18pg_dump › Optionsb--large-objects--blobs (deprecated) Include large objects in the dump. This is the default behavior except when --schema, --table, --schema-only, --statistics-only, or --no-data is specifie… pg_dump --cleanCommand-line ToolsPG18pg_dump › Optionsc--clean Output commands to DROP all the dumped database objects prior to outputting the commands for creating them. This option is useful when the restore is to overwrite an existing databa… pg_dump --compress=methodCommand-line ToolsPG18pg_dump › OptionsZ level-Z method[:detail]--compress=level--compress=method[:detail] Specify the compression method and/or the compression level to use. The compression method can be set to gzip, lz4, zstd, … pg_dump --createCommand-line ToolsPG18pg_dump › OptionsC--create Begin the output with a command to create the database itself and reconnect to the created database. (With a script of this form, it doesn't matter which database in the destinatio… pg_dump --data-onlyCommand-line ToolsPG18pg_dump › Optionsa--data-only Dump only the data, not the schema (data definitions) or statistics. Table data, large objects, and sequence values are dumped. This option is similar to, but for historical rea… pg_dump --dbname=dbnameCommand-line ToolsPG18pg_dump › Optionsd dbname--dbname=dbname Specifies the name of the database to connect to. This is equivalent to specifying dbname as the first non-option argument on the command line. The dbname can be a co… pg_dump --disable-dollar-quotingCommand-line ToolsPG18pg_dump › Optionsdisable-dollar-quoting This option disables the use of dollar quoting for function bodies, and forces them to be quoted using SQL standard string syntax.