Search PostgreSQL documentation

pg_deltaxExtensionsExtensionsFast time-series extension for PostgreSQL compression pgrx postgres postgresql postgresql-extension rust time-series pg_deltax Time seriesTime series · Extensions pg_dependManual ChaptersPG1852.18. pg_depend The catalog pg_depend records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dropped by DRO…pg_depend pg_dependCatalogs & ViewsReferencepg_depend System catalogs 10 The catalog pg_depend records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dr…System Catalogs · System catalogs pg_describeExtensionsExtensionsReport a query's parameters and result columns without executing it types introspection typescript codegen developer tools pg_describe UtilitiesUtilities · Extensions pg_describe_objectFunctionsReferencepg_describe_object System Information Functions And Operators 10 get description of a database object pg_describe_object ( classid oid, objid oid, objsubid integer ) → text get description o…Functions · System Information Functions And Operators pg_descriptionManual ChaptersPG1852.19. pg_description The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command and viewed with ps…pg_description pg_descriptionCatalogs & ViewsReferencepg_description System catalogs 10 The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command and vi…System Catalogs · System catalogs pg_diffixExtensionsExtensionsProvides strong dynamic anonymization for PostgreSQL query results. anonymization privacy pg_diffix SecuritySecurity · Extensions pg_digestExtensionsExtensionsData type for efficient storage of hash digests in PostgreSQL. pg_digest Data typesData types · Extensions pg_dirty_handsExtensionsExtensionsProvides functions to freeze individual heap tuples, including an unlogged variant. freeze storage tuple pg_dirty_hands AdministrationAdministration · Extensions pg_dirtyreadExtensionsExtensionsRead dead but unvacuumed rows from table pg_dirtyread AdministrationAdministration · Extensions pg_disable_data_checksumsFunctionsReferencepg_disable_data_checksums System Administration Functions 19 Disables data checksum calculation and validation for the cluster. This will set the data checksum state to inprogress-off while …Functions · System Administration Functions pg_diskannExtensionsExtensionsAzure Database for PostgreSQL extension for DiskANN approximate-nearest-neighbor vector indexes. pg_diskann AI and vectorsAI and vectors · Extensions pg_disorderExtensionsExtensionsPerturb unordered SELECT row order to expose order-dependent tests testing flaky tests order by random planner hook debugging pg_disorder FeaturesFeatures · Extensions pg_dispatchExtensionsExtensionsAsynchronous SQL dispatcher built on pg_cron pg_dispatch Time seriesTime series · Extensions pg_dmsExtensionsExtensionsDocument management system with custom ID, family, and reference types plus action tracking and JSON registry helpers. custom-type document-management registry pg_dms FeaturesFeatures · Extensions pg_doc_storeExtensionsExtensionsProvides a JSONB document-store API with full-text search. document-store full-text-search jsonb pg_doc_store FeaturesFeatures · Extensions pg_documentdb_gw_hostExtensionsExtensionspg documentdb gw host: Created by pgrx pgrx rust pg_documentdb_gw_host CompatibilityCompatibility · Extensions pg_documentsExtensionsExtensionsJSON access via HTTP server pg_documents FeaturesFeatures · Extensions pg_dphypExtensionsExtensionsPreload-only DPHyp hypergraph dynamic-programming join enumeration algorithm for PostgreSQL. pg_dphyp FeaturesFeatures · Extensions pg_drop_eventsExtensionsExtensionslogs transaction ids of drop table, drop column, drop materialized view statements pg_drop_events AdministrationAdministration · Extensions pg_drop_replication_slotFunctionsReferencepg_drop_replication_slot System Administration Functions 10 Drops the physical or logical replication slot named slot_name. Same as replication protocol command DROP_REPLICATION_SLOT. For lo…Functions · System Administration Functions pg_dropbuffersExtensionsExtensionsDrop PostgreSQL shared buffers and the operating-system page cache for testing buffer-cache cache-eviction testing pg_dropbuffers FeaturesFeatures · Extensions pg_dropcacheExtensionsExtensionsInvalidate PostgreSQL shared_buffers cache for a database or relation buffer-cache cache-eviction shared-buffers pg_dropcache AdministrationAdministration · Extensions pg_dsm_registry_allocationsCatalogs & ViewsReferencepg_dsm_registry_allocations System views 19 The pg_dsm_registry_allocations view shows shared memory allocations tracked in the dynamic shared memory (DSM) registry. This includes memory all…System Catalogs · System views pg_dtmExtensionsExtensionsPluggable distributed transaction manager using shared global snapshots distributed-transaction dtm shared-preload pg_dtm AdministrationAdministration · Extensions pg_duckdbExtensionsExtensionsDuckDB Embedded in Postgres duckdb pg_duckdb AnalyticsAnalytics · Extensions pg_ducklakeExtensionsExtensionsDuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet duckdb pg_ducklake AnalyticsAnalytics · Extensions pg_duckpipeExtensionsExtensionsCDC synchronization from heap tables to DuckLake columnar tables cdc ducklake logical-replication pgrx pg_duckpipe Replication and streamsReplication and streams · Extensions pg_dumpManual ChaptersPG18pg_dump pg_dump — export a PostgreSQL database as an SQL script or to other formats Synopsis pg_dump [connection-option...] [option...] [dbname]pg_dump pg_dump --attribute-insertsCommand-line ToolsPG18--column-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 u…pg_dump › Options pg_dump --binary-upgradeCommand-line ToolsPG18--binary-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 wi…pg_dump › Options pg_dump --blobsCommand-line ToolsPG18-b--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 specifi…pg_dump › Options pg_dump --cleanCommand-line ToolsPG18-c--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 datab…pg_dump › Options pg_dump --compress=methodCommand-line ToolsPG18-Z 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 › Options pg_dump --createCommand-line ToolsPG18-C--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 destinati…pg_dump › Options pg_dump --data-onlyCommand-line ToolsPG18-a--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 re…pg_dump › Options pg_dump --dbname=dbnameCommand-line ToolsPG18-d 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 c…pg_dump › Options pg_dump --disable-dollar-quotingCommand-line ToolsPG18--disable-dollar-quoting This option disables the use of dollar quoting for function bodies, and forces them to be quoted using SQL standard string syntax.pg_dump › Options pg_dump --disable-triggersCommand-line ToolsPG18--disable-triggers This option is relevant only when creating a dump that includes data but does not include schema. It instructs pg_dump to include commands to temporarily disable triggers …pg_dump › Options