Search PostgreSQL documentation

Additional Compile-Time and Run-Time ChecksManual ChaptersPG1841.12.2. Additional Compile-Time and Run-Time Checks To aid the user in finding instances of simple but common problems before they cause harm, PL/pgSQL provides additional checks. When enab…Additional Compile-Time and Run-Time Checks Additional ConstantsManual ChaptersPG1834.15.5. Additional Constants Note that all constants here describe errors and all of them are defined to represent negative values. In the descriptions of the different constants you can al…Additional Constants Additional FeaturesManual ChaptersPG1812.4. Additional Features This section describes additional functions and operators that are useful in connection with text search.Additional Features Additional FunctionsManual ChaptersPG1834.15.4. Additional Functions decadd Add two decimal type values. int decadd(decimal *arg1, decimal *arg2, decimal *sum); The function receives a pointer to the first operand of type decimal…Additional Functions Additional ModulesManual ChaptersPG18E.6.3.9. Additional Modules Add extension pg_logicalinspect to inspect logical snapshots (Bertrand Drouvot) § Add extension pg_overexplain which adds debug details to EXPLAIN output (Robert …Additional Modules Additional Supplied Modules and ExtensionsManual ChaptersPG18Appendix F. Additional Supplied Modules and Extensions This appendix and the next one contain information on the optional components found in the contrib directory of the PostgreSQL distribu…Additional Supplied Modules and Extensions Additional Supplied ProgramsManual ChaptersPG18Appendix G. Additional Supplied Programs This appendix and the previous one contain information regarding the modules that can be found in the contrib directory of the PostgreSQL distributio…Additional Supplied Programs Additional Test SuitesManual ChaptersPG1831.1.3. Additional Test Suites The make check and make installcheck commands run only the “core” regression tests, which test built-in functionality of the PostgreSQL server. The source dist…Additional Test Suites Additional TypesManual ChaptersPG1834.15.1. Additional Types The Informix-special "string" pseudo-type for storing right-trimmed character string data is now supported in Informix-mode without using typedef. In fact, in Infor…Additional Types Additional/Missing Embedded SQL StatementsManual ChaptersPG1834.15.2. Additional/Missing Embedded SQL Statements CLOSE DATABASE # This statement closes the current connection. In fact, this is a synonym for ECPG's DISCONNECT CURRENT: $CLOSE DATABASE; …Additional/Missing Embedded SQL Statements address_standardizerExtensionsExtensionsUsed to parse an address into constituent elements. Generally used to support geocoding address normalization step. postgis GeospatialGeospatial · Extensions address_standardizer_data_usExtensionsExtensionsAddress Standardizer US dataset example postgis GeospatialGeospatial · Extensions addressing_dictionaryExtensionsExtensionsAddress handling dictionaries for PostgreSQL, applying smarter handling to addresses in text search. address dictionary fts geocoding addressing_dictionary Full-text searchFull-text search · Extensions administrable_role_​authorizationsManual ChaptersPG1835.4. administrable_role_​authorizations The view administrable_role_authorizations identifies all roles that the current user has the admin option for. Table 35.2. administrable_role_author…administrable_role_​authorizations Administration ToolsManual ChaptersPG18H.2. Administration Tools There are several administration tools available for PostgreSQL. The most popular is pgAdmin, and there are several commercially available ones as well.Administration Tools Administrator's OverviewManual ChaptersPG1826.4.3. Administrator's Overview If hot_standby is on in postgresql.conf (the default value) and there is a standby.signal file present, the server will run in hot standby mode. However, it …Administrator's Overview adminpackExtensionsExtensionsadministrative functions for PostgreSQL adminpack AdministrationAdministration · Extensions Advanced FeaturesManual ChaptersPG18Advanced FeaturesAdvanced Features Advanced FeaturesManual ChaptersPG18Chapter 3. Advanced FeaturesAdvanced Features Advantages of Using PL/pgSQLManual ChaptersPG1841.1.1. Advantages of Using PL/pgSQL SQL is the language PostgreSQL and most other relational databases use as query language. It's portable and easy to learn. But every SQL statement must b…Advantages of Using PL/pgSQL advcopyExtensionsExtensionsPL/Python PostgreSQL extension for copying data to and from S3. etl plpython s3 advcopy Replication and streamsReplication and streams · Extensions advisoryWait EventsReferenceadvisory Lock 10 Waiting to acquire an advisory user lock. 11 12 13 14 15 16 17 18 19 20 9.6 Sub-second handoff during ordinary writes or planned DDL can be normal. Investigate once a user-f…Wait Events · Lock Advisory Lock FunctionsManual ChaptersPG189.28.10. Advisory Lock Functions The functions shown in Table 9.109 manage advisory locks. For details about proper use of these functions, see Section 13.3.5. All these functions are intend…Advisory Lock Functions Advisory LocksManual ChaptersPG1813.3.5. Advisory Locks PostgreSQL provides a means for creating locks that have application-defined meanings. These are called advisory locks, because the system does not enforce their use —…Advisory Locks aerospike_fdwExtensionsExtensionsForeign Data Wrapper for Aerospike. aerospike fdw aerospike_fdw Foreign data wrappersForeign data wrappers · Extensions aethel_smgrExtensionsExtensionsAethelDB - A decoupled, serverless PostgreSQL platform branching database dbaas kubernetes neon-alternative open-source postgresql rust scale-to-zero serverless storage wal aethel_smgr Featu…Features · Extensions ageFunctionsReferenceage Date/Time Functions And Operators 10 Subtract arguments, producing a “symbolic” result that uses years and months, rather than just days age ( timestamp, timestamp ) → interval Subtract …Functions · Date/Time Functions And Operators ageExtensionsExtensionsAGE graph database extension age FeaturesFeatures · Extensions Aggregate ExpressionsManual ChaptersPG184.2.7. Aggregate Expressions An aggregate expression represents the application of an aggregate function across the rows selected by a query. An aggregate function reduces multiple inputs to…Aggregate Expressions Aggregate FunctionsManual ChaptersPG189.21. Aggregate Functions Aggregate functions compute a single result from a set of input values. The built-in general-purpose aggregate functions are listed in Table 9.62 while statistical …Aggregate Functions Aggregate FunctionsManual ChaptersPG182.7. Aggregate Functions Like most other relational database products, PostgreSQL supports aggregate functions. An aggregate function computes a single result from multiple input rows. For e…Aggregate Functions Aggregated LoggingManual ChaptersPG18Aggregated Logging With the --aggregate-interval option, a different format is used for the log files. Each log line describes one aggregation interval. It contains the following space-separ…Aggregated Logging aggsExtensionsExtensionsTesting aggregation functions aggs Functions and aggregatesFunctions and aggregates · Extensions aggs_for_arraysExtensionsExtensionsVarious functions for computing statistics on arrays of numbers aggs_for_arrays Functions and aggregatesFunctions and aggregates · Extensions aggs_for_vecsExtensionsExtensionsAggregate functions for array inputs aggs_for_vecs Functions and aggregatesFunctions and aggregates · Extensions agsExtensionsExtensionsAdvanced Generalized Search access method, a GiST-based advanced index. gist indexing ags FeaturesFeatures · Extensions aiExtensionsExtensionsHelper functions for AI workflows in PostgreSQL ai llm rag pgai AI and vectorsAI and vectors · Extensions ai_blaise_citusExtensionsExtensionsai-blaise Citus companion extension pgrx rust ai_blaise_citus_companion FeaturesFeatures · Extensions ai_toolkitExtensionsExtensionsAI-powered query generation and explanation tools for PostgreSQL. ai llm ai_toolkit AI and vectorsAI and vectors · Extensions aidbExtensionsExtensionsIn-database AI pipelines for chunking, embedding, retrieval, and generation. ai rag embedding pipeline aidb AI and vectorsAI and vectors · Extensions