Search PostgreSQL documentation

pg_dumpall --versionCommand-line ToolsPG18-V--version Print the pg_dumpall version and exit.pg_dumpall › Options pg_durableExtensionsExtensionsSQL-native durable orchestrations for PostgreSQL durable-execution workflow orchestration background-worker pgrx pg_durable FeaturesFeatures · Extensions pg_durationExtensionsExtensionsdata type for representing durations pg_duration Data typesData types · Extensions pg_ecdsa_verifyExtensionsExtensionsECDSA signature verification functions for PostgreSQL cryptography ecdsa pgrx signature-verification pg_ecdsa_verify SecuritySecurity · Extensions pg_ed25519ExtensionsExtensionsEd25519 signing and signature-verification functions for PostgreSQL cryptography ed25519 signature pg_ed25519 SecuritySecurity · Extensions pg_eddyExtensionsExtensionsA Postgres extension for labeled property graphs with index-free adjacency and built-in materialized views. pg_eddy FeaturesFeatures · Extensions pg_elephantExtensionsExtensionsToy example extension exposing a pg_elephant() function that returns ASCII elephant text. ascii-art example toy pg_elephant Functions and aggregatesFunctions and aggregates · Extensions pg_elephantduckExtensionsExtensionsColumnar PostgreSQL table access method powered by DuckDB and Parquet storage. columnar duckdb parquet pgrx table-access-method pg_elephantduck AnalyticsAnalytics · Extensions pg_embedExtensionsExtensionsGenerate and store OpenAI embeddings in-place pg_embed AI and vectorsAI and vectors · Extensions pg_embedderExtensionsExtensionsIn-backend text embedding inference using Rust, Candle, and packaged models. embedding candle inference vector pg_embedder AI and vectorsAI and vectors · Extensions pg_emdExtensionsExtensionsFast approximate Earth Mover's Distance using dynamic tree embeddings earth-movers-distance emd pgrx similarity tree-embedding pg_emd AI and vectorsAI and vectors · Extensions pg_enable_data_checksumsFunctionsReferencepg_enable_data_checksums System Administration Functions 19 Initiates the process of enabling data checksums for the cluster. This will set the data checksums state to inprogress-on as well …Functions · System Administration Functions pg_encoding_to_charFunctionsReferencepg_encoding_to_char System Information Functions And Operators 15 Converts the integer used as the internal identifier of an encoding in some system catalog tables into a human-readable stri…Functions · System Information Functions And Operators pg_enigmaExtensionsExtensionsEncrypted postgres data type pgrx pg_enigma SecuritySecurity · Extensions pg_enquoExtensionsExtensionsPostgreSQL extension for encrypted query operations encrypted-query encryption pgrx searchable-encryption pg_enquo SecuritySecurity · Extensions pg_enumManual ChaptersPG1852.20. pg_enum The pg_enum catalog contains entries showing the values and labels for each enum type. The internal representation of a given enum value is actually the OID of its associated …pg_enum pg_enumCatalogs & ViewsReferencepg_enum System catalogs 10 The pg_enum catalog contains entries showing the values and labels for each enum type. The internal representation of a given enum value is actually the OID of its…System Catalogs · System catalogs pg_erlang_termExtensionsExtensionsPostgreSQL type for encoding, storing, and decoding Erlang External Term Format values. erlang external-term codec type pg_erlang_term Data typesData types · Extensions pg_etagExtensionsExtensionsFast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates. aggregate blake2 etag hash pg_etag Functions and aggregatesFunctions and aggregates · Extensions pg_ethiopian_calendarExtensionsExtensionsConvert between Gregorian and Ethiopian calendar dates calendar pg_ethiopian_calendar Time seriesTime series · Extensions pg_ethopicExtensionsExtensionsFormat Ethiopic dates and numbers in PostgreSQL. calendar pgrx pg_ethopic Functions and aggregatesFunctions and aggregates · Extensions pg_event_triggerManual ChaptersPG1852.21. pg_event_trigger The catalog pg_event_trigger stores event triggers. See Chapter 38 for more information. Table 52.21. pg_event_trigger Columns Column Type Description oid oid Row ide…pg_event_trigger pg_event_triggerCatalogs & ViewsReferencepg_event_trigger System catalogs 10 The catalog pg_event_trigger stores event triggers. See Chapter 39 for more information. evtname Trigger name (must be unique) evtevent Identifies the eve…System Catalogs · System catalogs pg_event_trigger_ddl_commandsFunctionsReferencepg_event_trigger_ddl_commands Event Trigger Functions 10 pg_event_trigger_ddl_commands returns a list of DDL commands executed by each user action, when invoked in a function attached to a d…Functions · Event Trigger Functions pg_event_trigger_dropped_objectsFunctionsReferencepg_event_trigger_dropped_objects Event Trigger Functions 10 pg_event_trigger_dropped_objects returns a list of all objects dropped by the command in whose sql_drop event it is called. If cal…Functions · Event Trigger Functions pg_event_trigger_table_rewrite_oidFunctionsReferencepg_event_trigger_table_rewrite_oid Event Trigger Functions 10 The OID of the table about to be rewritten. pg_event_trigger_table_rewrite_oid ( ) → Oid The OID of the table about to be rewrit…Functions · Event Trigger Functions pg_event_trigger_table_rewrite_reasonFunctionsReferencepg_event_trigger_table_rewrite_reason Event Trigger Functions 10 The reason code(s) explaining the reason for rewriting. The exact meaning of the codes is release dependent. pg_event_trigger…Functions · Event Trigger Functions pg_eviltransformExtensionsExtensionsCoordinate transforms for BD09/GCJ02 via PostGIS ST_Transform pgrx pg_eviltransform GeospatialGeospatial · Extensions pg_exclusive_backupExtensionsExtensionsCompatibility functions for exclusive-style physical backup on PostgreSQL 15 or later. backup exclusive compatibility pg15 pg_exclusive_backup AdministrationAdministration · Extensions pg_export_snapshotFunctionsReferencepg_export_snapshot System Administration Functions 10 Save the current snapshot and return its identifier pg_export_snapshot ( ) → text Save the current snapshot and return its identifier 11…Functions · System Administration Functions pg_extensionManual ChaptersPG1852.22. pg_extension The catalog pg_extension stores information about the installed extensions. See Section 36.17 for details about extensions. Table 52.22. pg_extension Columns Column Type …pg_extension pg_extensionExtensionsExtensionsIn-database model slicing and inference helper functions for structured data analytics. pgrx indices AI and vectorsAI and vectors · Extensions pg_extensionCatalogs & ViewsReferencepg_extension System catalogs 10 The catalog pg_extension stores information about the installed extensions. See Section 37.15 for details about extensions. oid Row identifier (hidden attribu…System Catalogs · System catalogs pg_extension_baseExtensionsExtensionsExtension development kit by Snowflake background-worker preload pg_lake AnalyticsAnalytics · Extensions pg_extension_updaterExtensionsExtensionsAutomatic extension updater background-worker preload update pg_lake AnalyticsAnalytics · Extensions pg_extismExtensionsExtensionsAn Extism sample showing how you can run Extism plugins from PostgreSQl using pgrx! extism pgrx postgresql rust wasm pg_extism Procedural languagesProcedural languages · Extensions pg_extra_timeExtensionsExtensionsSome date time functions and operators that, pg_extra_time UtilitiesUtilities · Extensions pg_eyesExtensionsExtensionsSQL monitoring functions and views for PostgreSQL database activity monitoring statistics pg_eyes MonitoringMonitoring · Extensions pg_fact_loaderExtensionsExtensionsbuild fact tables with Postgres pg_fact_loader Replication and streamsReplication and streams · Extensions pg_failover_slotsExtensionsExtensionsPG Failover Slots extension pg_failover_slots Replication and streamsReplication and streams · Extensions