Search PostgreSQL documentation

efm_extensionExtensionsExtensionsSQL interface for EDB Failover Manager cluster management background-worker efm failover high-availability monitoring efm_extension AdministrationAdministration · Extensions eidos_oauthExtensionsExtensionsOAuth 2.0 JWT validator for PostgreSQL 18 using the OAuth validator API. authentication jwt oauth2 pgrx eidos_oauth SecuritySecurity · Extensions eigenExtensionsExtensionsNew array types and linear-algebra functions based on the Eigen numerical template library. array math eigen Data typesData types · Extensions element_typesManual ChaptersPG1835.24. element_types The view element_types contains the data type descriptors of the elements of arrays. When a table column, composite-type attribute, domain, function parameter, or functi…element_types elementsExtensionsExtensionsChemical elements and isotope metadata exposed as PostgreSQL enum types through pgrx. chemistry data-type pgrx emi_monorepo Data typesData types · Extensions EmacsManual ChaptersPG18J.5.1. Emacs nXML Mode, which ships with Emacs, is the most common mode for editing XML documents with Emacs. It will allow you to use Emacs to insert tags and check markup consistency, and …Emacs emailExtensionsExtensionsEmail address data type with validation, equality operators, and user/domain helper functions. data-type email email Data typesData types · Extensions email_guardExtensionsExtensionsSupabase Auth signup guard that blocks disposable email domains and normalizes Gmail addresses. auth hook supabase tle email_guard SecuritySecurity · Extensions emailaddrExtensionsExtensionsEmail address type for PostgreSQL nil-lic pg_emailaddr Data typesData types · Extensions emajExtensionsExtensionsEnables fine-grained write logging and time travel on subsets of the database. emaj Time seriesTime series · Extensions Embedded SQL CommandsManual ChaptersPG1834.14. Embedded SQL Commands This section describes all SQL commands that are specific to embedded SQL. Also refer to the SQL commands listed in SQL Commands, which can also be used in embed…Embedded SQL Commands embeddingExtensionsExtensionsHNSW vector similarity search extension for PostgreSQL real[] embeddings. hnsw vector vector-search embedding AI and vectorsAI and vectors · Extensions embedding_searchExtensionsExtensionsLangChain/Supabase helper package for storing and searching document embeddings with pgvector. langchain tle vector langchain-embedding_search AI and vectorsAI and vectors · Extensions emojiExtensionsExtensionsPure SQL PostgreSQL extension to encode and decode bytea/text as emoji emoji UtilitiesUtilities · Extensions emojigresqlExtensionsExtensions🐘 EmojigreSQL: A pure SQL PostgreSQL extension to encode/decode binary data (bytea) and text into colorful emoji sequences! ✨ Includes basic checksum validation. bytea decoding emoji encodin…Utilities · Extensions emptyExtensionsExtensionsDemo C extension with sample functions, a matrix type, an FDW, logical-decoding callbacks, and shared-memory hooks. data-type demo fdw hook logical-decoding empty FeaturesFeatures · Extensions Empty SELECT ListsManual ChaptersPG18Empty SELECT Lists The list of output expressions after SELECT can be empty, producing a zero-column result table. This is not valid syntax according to the SQL standard. PostgreSQL allows i…Empty SELECT Lists enable_async_appendConfigurationReferenceenable_async_append Query Tuning 14 Enables or disables the query planner's use of async-aware append plan types. The default is on. 15 16 17 18 19 20 enable_async_append controls whether th…Configuration · Query Tuning enable_bitmapscanConfigurationReferenceenable_bitmapscan Query Tuning 10 Enables or disables the query planner's use of bitmap-scan plan types. The default is on. 11 12 13 14 15 16 17 18 19 20 9.0 9.1 9.2 9.3 9.4 9.5 9.6 enable_b…Configuration · Query Tuning enable_distinct_reorderingConfigurationReferenceenable_distinct_reordering Query Tuning 18 Enables or disables the query planner's ability to reorder DISTINCT keys to match the input path's pathkeys. The default is on. 19 20 enable_distin…Configuration · Query Tuning enable_eager_aggregateConfigurationReferenceenable_eager_aggregate Query Tuning 19 Enables or disables the query planner's ability to partially push aggregation past a join, and finalize it once all the relations are joined. The defau…Configuration · Query Tuning enable_gathermergeConfigurationReferenceenable_gathermerge Query Tuning 10 Enables or disables the query planner's use of gather merge plan types. The default is on. 11 12 13 14 15 16 17 18 19 20 enable_gathermerge controls whethe…Configuration · Query Tuning enable_group_by_reorderingConfigurationReferenceenable_group_by_reordering Query Tuning 17 Controls if the query planner will produce a plan which will provide GROUP BY keys sorted in the order of keys of a child node of the plan, such as…Configuration · Query Tuning enable_groupaggConfigurationReferenceenable_groupagg Query Tuning 20 Enables or disables the query planner's use of sort-based grouping and aggregation plan types. The default is on.Configuration · Query Tuning enable_hashaggConfigurationReferenceenable_hashagg Query Tuning 10 Enables or disables the query planner's use of hashed aggregation plan types. The default is on. 11 12 13 14 15 16 17 18 19 20 9.0 9.1 9.2 9.3 9.4 9.5 9.6 enab…Configuration · Query Tuning enable_hashjoinConfigurationReferenceenable_hashjoin Query Tuning 10 Enables or disables the query planner's use of hash-join plan types. The default is on. 11 12 13 14 15 16 17 18 19 20 9.0 9.1 9.2 9.3 9.4 9.5 9.6 enable_hashj…Configuration · Query Tuning enable_incremental_sortConfigurationReferenceenable_incremental_sort Query Tuning 13 Enables or disables the query planner's use of incremental sort steps. The default is on. 14 15 16 17 18 19 20 enable_incremental_sort controls whethe…Configuration · Query Tuning enable_indexonlyscanConfigurationReferenceenable_indexonlyscan Query Tuning 10 Enables or disables the query planner's use of index-only-scan plan types (see Section 11.11). The default is on. 11 Enables or disables the query planne…Configuration · Query Tuning enable_indexscanConfigurationReferenceenable_indexscan Query Tuning 10 Enables or disables the query planner's use of index-scan plan types. The default is on. 11 12 Enables or disables the query planner's use of index-scan and …Configuration · Query Tuning enable_materialConfigurationReferenceenable_material Query Tuning 10 Enables or disables the query planner's use of materialization. It is impossible to suppress materialization entirely, but turning this variable off prevents …Configuration · Query Tuning enable_memoizeConfigurationReferenceenable_memoize Query Tuning 14 Enables or disables the query planner's use of memoize plans for caching results from parameterized scans inside nested-loop joins. This plan type allows scans…Configuration · Query Tuning enable_mergejoinConfigurationReferenceenable_mergejoin Query Tuning 10 Enables or disables the query planner's use of merge-join plan types. The default is on. 11 12 13 14 15 16 17 18 19 20 9.0 9.1 9.2 9.3 9.4 9.5 9.6 enable_mer…Configuration · Query Tuning enable_nestloopConfigurationReferenceenable_nestloop Query Tuning 10 Enables or disables the query planner's use of nested-loop join plans. It is impossible to suppress nested-loop joins entirely, but turning this variable off …Configuration · Query Tuning enable_parallel_appendConfigurationReferenceenable_parallel_append Query Tuning 11 Enables or disables the query planner's use of parallel-aware append plan types. The default is on. 12 13 14 15 16 17 18 19 20 enable_parallel_append c…Configuration · Query Tuning enable_parallel_hashConfigurationReferenceenable_parallel_hash Query Tuning 11 Enables or disables the query planner's use of hash-join plan types with parallel hash. Has no effect if hash-join plans are not also enabled. The defaul…Configuration · Query Tuning enable_partition_pruningConfigurationReferenceenable_partition_pruning Query Tuning 11 Enables or disables the query planner's ability to eliminate a partitioned table's partitions from query plans. This also controls the planner's abil…Configuration · Query Tuning enable_partitionwise_aggregateConfigurationReferenceenable_partitionwise_aggregate Query Tuning 11 Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on partitioned table…Configuration · Query Tuning enable_partitionwise_joinConfigurationReferenceenable_partitionwise_join Query Tuning 11 Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the mat…Configuration · Query Tuning enable_presorted_aggregateConfigurationReferenceenable_presorted_aggregate Query Tuning 16 Controls if the query planner will produce a plan which will provide rows which are presorted in the order required for the query's ORDER BY / DIST…Configuration · Query Tuning enable_self_join_eliminationConfigurationReferenceenable_self_join_elimination Query Tuning 18 Enables or disables the query planner's optimization which analyses the query tree and replaces self joins with semantically equivalent single sc…Configuration · Query Tuning