Search PostgreSQL documentation

bytea_exifExtensionsExtensionsPostgreSQL extension for EXIF data reading from bytea value of image and MIME type check exif exif-metadata image-exif mime-types postgis postgres postgresql postgresql-extension spatial-ana…Utilities · Extensions bytea_outputConfigurationReferencebytea_output Client Connection Defaults 10 Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format). See Section 8.4…Configuration · Client Connection Defaults bytea_plphpExtensionsExtensionsBinary-safe transform between bytea and PHP strings for PL/php bytea binary php transform plphp Procedural languagesProcedural languages · Extensions byteamagicExtensionsExtensionsDetect MIME types and file formats from PostgreSQL bytea values pg_byteamagic UtilitiesUtilities · Extensions bzipExtensionsExtensionsBzip compression and decompression pg_bzip UtilitiesUtilities · Extensions bztreeExtensionsExtensionsBzTree index access method with equality operator classes for common PostgreSQL scalar types. bztree index-access-method bztree FeaturesFeatures · Extensions C++ Application Development with External C ModuleManual ChaptersPG1834.13.2. C++ Application Development with External C Module If you understand these technical limitations of the ecpg preprocessor in C++, you might come to the conclusion that linking C obj…C++ Application Development with External C Module C++ ApplicationsManual ChaptersPG1834.13. C++ Applications ECPG has some limited support for C++ applications. This section describes some caveats. The ecpg preprocessor takes an input file written in C (or something like C) …C++ Applications C-Language FunctionsManual ChaptersPG1836.10. C-Language Functions User-defined functions can be written in C (or a language that can be made compatible with C, such as C++). Such functions are compiled into dynamically loadable …C-Language Functions cadfixExtensionsExtensionsOCC interface implementation in JavaScript cadfix FeaturesFeatures · Extensions cairn_pgxExtensionsExtensionsCairn in-database verify gate — COSE Sign1/Ed25519 event verification (Spike 0002) pgrx rust cairn_pgx SecuritySecurity · Extensions calculate_markupExtensionsExtensionsC function that calculates a price markup percentage by linear interpolation over a numeric price/markup array. linear-interpolation pricing calculate_markup Functions and aggregatesFunctions and aggregates · Extensions calendarsExtensionsExtensionscalendar conversion routines calendar conversion calendars Time seriesTime series · Extensions CALLManual ChaptersPG18CALL CALL — invoke a procedure Synopsis CALL name ( [ argument ] [, ...] )CALL CALLSQL CommandsReferenceCALL Functions & Procedures 11 invoke a procedure CALL name ( [ argument ] [, ...] ) CALL executes a procedure. If the procedure has any output parameters, then a result row will be returned…SQL Commands · Functions & Procedures call_graphExtensionsExtensionsTrack PostgreSQL function calls automatically and aggregate them into call graphs and optional table-usage statistics. call-graph function-tracing statistics call_graph MonitoringMonitoring · Extensions Calling a ProcedureManual ChaptersPG1841.6.3. Calling a Procedure A PL/pgSQL function, procedure, or DO block can call a procedure using CALL. Output parameters are handled differently from the way that CALL works in plain SQL. …Calling a Procedure Calling FunctionsManual ChaptersPG184.3. Calling Functions PostgreSQL allows functions that have named parameters to be called using either positional or named notation. Named notation is especially useful for functions that h…Calling Functions Canceling Queries in ProgressManual ChaptersPG1832.7. Canceling Queries in ProgressCanceling Queries in Progress Canceling Requests in ProgressManual ChaptersPG1854.2.8. Canceling Requests in Progress During the processing of a query, the frontend might request cancellation of the query. The cancel request is not sent directly on the open connection …Canceling Requests in Progress Cannot Pass Named Parameters to QueriesManual ChaptersPG18D.3.2.2. Cannot Pass Named Parameters to Queries The XPath-based functions support passing one parameter to serve as the XPath expression's context item, but do not support passing additiona…Cannot Pass Named Parameters to Queries CapabilitiesManual ChaptersPG1847.6.2. Capabilities To decode, format and output changes, output plugins can use most of the backend's normal infrastructure, including calling output functions. Read only access to relatio…Capabilities capitalizeExtensionsExtensionsA function to capitalize all the given character capitalize Functions and aggregatesFunctions and aggregates · Extensions Capturing Changes at Command EndManual ChaptersPG189.30.1. Capturing Changes at Command End pg_event_trigger_ddl_commands () → setof record pg_event_trigger_ddl_commands returns a list of DDL commands executed by each user action, when invok…Capturing Changes at Command End cardinalityFunctionsReferencecardinality Array Functions And Operators 10 returns the total number of elements in the array, or 0 if the array is empty cardinality ( anyarray ) → int returns the total number of elements…Functions · Array Functions And Operators cart_extExtensionsExtensionsCart-service transaction markers and LISTEN/NOTIFY background workers for a marketplace prototype. cart_ext FeaturesFeatures · Extensions cartodbExtensionsExtensionsArchived PostgreSQL extension for turning a database into a CartoDB user database. cartodb-postgresql GeospatialGeospatial · Extensions casExtensionsExtensionsCAS Registry Number data type for PostgreSQL. cas-registry-number data-type cas Data typesData types · Extensions cas_codesExtensionsExtensionsCAS Registry Number data type and validation support for PostgreSQL. cas-number chemistry data-type pgrx emi_monorepo Data typesData types · Extensions Cascading ReplicationManual ChaptersPG1826.2.7. Cascading Replication The cascading replication feature allows a standby server to accept replication connections and stream WAL records to other standbys, acting as a relay. This ca…Cascading Replication CASESQL CommandsPG189.18.1. CASE # The SQL CASE expression is a generic conditional expression, similar to if/else statements in other programming languages: CASE WHEN condition THEN result [WHEN ...] [ELSE res…Conditional Expressions › CASE CASEManual ChaptersPG189.18.1. CASE The SQL CASE expression is a generic conditional expression, similar to if/else statements in other programming languages: CASE WHEN condition THEN result [WHEN ...] [ELSE resul…CASE casefoldFunctionsReferencecasefold String Functions And Operators 18 Performs case folding of the input string according to the collation. Case folding is similar to case conversion, but the purpose of case folding i…Functions · String Functions And Operators cassandra2_fdwExtensionsExtensionsForeign data wrapper for querying Cassandra 2.x and newer from PostgreSQL. cassandra fdw read-only cassandra2_fdw Foreign data wrappersForeign data wrappers · Extensions cassandra_fdwExtensionsExtensionsforeign-data wrapper for querying Cassandra 3+ cassandra_fdw Foreign data wrappersForeign data wrappers · Extensions CastsManual ChaptersPG18F.20.2. Casts The isn module provides the following pairs of type casts: ISBN13 <=> EAN13 ISMN13 <=> EAN13 ISSN13 <=> EAN13 ISBN <=> EAN13 ISMN <=> EAN13 ISSN <=> EAN13 UPC <=> EAN13 ISBN <=…Casts cat_hook_delete_claimsExtensionsExtensionsSupabase Auth custom access token hook for deleting token claims dbdev hook supabase tle cat_hook_delete_claims SecuritySecurity · Extensions cat_toolsExtensionsExtensionsTools for interfacing with the PostgreSQL catalog catalog meta metaprogramming cat_tools AdministrationAdministration · Extensions catboostExtensionsExtensionsmachine learning module using CatBoost catboost AI and vectorsAI and vectors · Extensions CaveatsManual ChaptersPG1825.3.8. Caveats At this writing, there are several limitations of the continuous archiving technique. These will probably be fixed in future releases: If a CREATE DATABASE command is execute…Caveats