Search PostgreSQL documentation

omni_restExtensionsExtensionsFeatures · ExtensionsREST API toolkit (with PostgREST support) omnigres Features omni_schemaExtensionsExtensionsFeatures · ExtensionsAdvanced schema management tooling omnigres Features omni_seqExtensionsExtensionsFeatures · ExtensionsDistributed integer sequences omnigres Features omni_serviceExtensionsExtensionsFeatures · ExtensionsService management omnigres Features omni_sessionExtensionsExtensionsFeatures · ExtensionsSession management omnigres Features omni_shmemExtensionsExtensionsFeatures · ExtensionsShared Memory Management omni_shmem Features omni_sqlExtensionsExtensionsFeatures · ExtensionsProgrammatic SQL manipulation omnigres Features omni_sqliteExtensionsExtensionsFeatures · ExtensionsEmbedded SQLite omnigres Features omni_testExtensionsExtensionsFeatures · ExtensionsTesting framework omnigres Features omni_txnExtensionsExtensionsFeatures · ExtensionsTransaction management omnigres Features omni_typesExtensionsExtensionsFeatures · ExtensionsAdvanced types omnigres Features omni_varExtensionsExtensionsFeatures · ExtensionsScoped variables omnigres Features omni_vfsExtensionsExtensionsFeatures · ExtensionsVirtual File System omnigres Features omni_vfs_types_v1ExtensionsExtensionsFeatures · ExtensionsVirtual File System types (v1) omnigres Features omni_webExtensionsExtensionsFeatures · ExtensionsCommon web stack primitives omnigres Features omni_workerExtensionsExtensionsFeatures · ExtensionsGeneralized worker pool omnigres Features omni_xmlExtensionsExtensionsFeatures · ExtensionsXML toolkit omnigres Features omni_yamlExtensionsExtensionsFeatures · ExtensionsYAML toolkit omnigres Features omnidb_plpgsql_debuggerExtensionsExtensionsProcedural languages · ExtensionsPostgreSQL extension for enabling PL/pgSQL debugger in OmniDB plpgsql_debugger Procedural languages omnidb_pluginExtensionsExtensionsProcedural languages · ExtensionsPostgreSQL plugin for enabling PL/pgSQL debugger in OmniDB debugger functions plpgsql omnidb_plugin Procedural languages omnisketchExtensionsExtensionsFunctions and aggregates · Extensionsdata structure for on-line agg of data into approximate sketch omnisketch Functions and aggregates ON CONFLICTSQL CommandsPG18INSERT › Parameters › ON CONFLICT ClauseClause The optional ON CONFLICT clause specifies an alternative action to raising a unique violation or exclusion constraint violation error. For each individual row proposed for insertion, … ON CONFLICT ClauseManual ChaptersPG18INSERTThe optional ON CONFLICT clause specifies an alternative action to raising a unique violation or exclusion constraint violation error. For each individual row proposed for insertion, either … onesparseExtensionsExtensionsFeatures · ExtensionsSparse linear algebra and graph extension for PostgreSQL 18 one_sparse Features online_advisorExtensionsExtensionsAdministration · ExtensionsSuggest missing indexes and extended statistics online online_advisor Administration ONLYSQL CommandsPG18SELECT › Compatibility › ONLY and Inheritanceand Inheritance The SQL standard requires parentheses around the table name when writing ONLY, for example SELECT * FROM ONLY (tab1), ONLY (tab2) WHERE .... PostgreSQL considers these parent… ONLY and InheritanceManual ChaptersPG18SELECTThe SQL standard requires parentheses around the table name when writing ONLY, for example SELECT * FROM ONLY (tab1), ONLY (tab2) WHERE .... PostgreSQL considers these parentheses to be opti… Only BY VALUE Passing Mechanism Is SupportedManual ChaptersPG18XML Limits and Conformance to SQL/XMLThe SQL standard defines two passing mechanisms that apply when passing an XML argument from SQL to an XML function or receiving a result: BY REF, in which a particular XML value retains its… op_logExtensionsExtensionsSecurity · ExtensionsTrigger-based row change history recorded after transaction commit. audit history trigger plv8 op_log Security OPENManual ChaptersPG18a dynamic cursor Synopsis OPEN cursor_name OPEN cursor_name USING value [, ... ] OPEN cursor_name USING SQL DESCRIPTOR descriptor_name OPEN FOR EXECUTEManual ChaptersPG18CursorsOPEN unbound_cursorvar [ [ NO ] SCROLL ] FOR EXECUTE query_string [ USING expression [, ... ] ]; The cursor variable is opened and given the specified query to execute. The cursor cannot be … OPEN FOR queryManual ChaptersPG18CursorsOPEN unbound_cursorvar [ [ NO ] SCROLL ] FOR query; The cursor variable is opened and given the specified query to execute. The cursor cannot be open already, and it must have been declared … open_pg_tdeExtensionsExtensionsSecurity · ExtensionsTransparent data encryption for upstream PostgreSQL using the tde_heap access method, including tables, indexes, TOAST, WAL, and temporary files. encryption fork key-management table-access-… openapi_fdwExtensionsExtensionsForeign data wrappers · ExtensionsRead/write foreign data wrapper for OpenAPI and JSON HTTP services. fdw openapi http json openapi_fdw Foreign data wrappers openbarterExtensionsExtensionsFeatures · ExtensionsMultilateral agreement engine. barter book central cyclic exchange limit market non-bilateral order openbarter Features Opening a Bound CursorManual ChaptersPG18CursorsOPEN bound_cursorvar [ ( [ argument_name { := | => } ] argument_value [, ...] ) ]; This form of OPEN is used to open a cursor variable whose query was bound to it when it was declared. The c… Opening an Existing Large ObjectManual ChaptersPG18Client InterfacesTo open an existing large object for reading or writing, call int lo_open(PGconn *conn, Oid lobjId, int mode); The lobjId argument specifies the OID of the large object to open. The mode bit… Opening CursorsManual ChaptersPG18CursorsBefore a cursor can be used to retrieve rows, it must be opened. (This is the equivalent action to the SQL command DECLARE CURSOR.) PL/pgSQL has three forms of the OPEN statement, two of whi… opensslExtensionsExtensionsSecurity · ExtensionsPostgreSQL extension for cryptographic functions and types provided by OpenSSL crypto openssl pg_openssl Security OpenSSL ConfigurationManual ChaptersPG18Secure TCP/IP Connections with SSLPostgreSQL reads the system-wide OpenSSL configuration file. By default, this file is named openssl.cnf and is located in the directory reported by openssl version -d. This default can be ov…