Search PostgreSQL documentation

omni_gitExtensionsExtensionsA PostgreSQL extension that stores git repositories in database tables and serves the git smart HTTP protocol, turning Postgres into a git remote. omni_git CompatibilityCompatibility · Extensions omni_httpExtensionsExtensionsBasic HTTP types omnigres FeaturesFeatures · Extensions omni_httpcExtensionsExtensionsHTTP client omnigres FeaturesFeatures · Extensions omni_httpdExtensionsExtensionsHTTP server omnigres FeaturesFeatures · Extensions omni_idExtensionsExtensionsIdentity types omnigres FeaturesFeatures · Extensions omni_jsonExtensionsExtensionsJSON toolkit omnigres FeaturesFeatures · Extensions omni_kubeExtensionsExtensionsKubernetes (k8s) integration omnigres FeaturesFeatures · Extensions omni_ledgerExtensionsExtensionsFinancial ledger omnigres FeaturesFeatures · Extensions omni_manifestExtensionsExtensionsPackage installation manifests omnigres FeaturesFeatures · Extensions omni_mimetypesExtensionsExtensionsMIME types omnigres FeaturesFeatures · Extensions omni_osExtensionsExtensionsOperating system integration omnigres FeaturesFeatures · Extensions omni_polyfillExtensionsExtensionsPostgres API polyfills omnigres FeaturesFeatures · Extensions omni_pythonExtensionsExtensionsFirst-class Python support omnigres FeaturesFeatures · Extensions omni_regexExtensionsExtensionsPCRE-compatible regular expressions omnigres FeaturesFeatures · Extensions omni_restExtensionsExtensionsREST API toolkit (with PostgREST support) omnigres FeaturesFeatures · Extensions omni_schemaExtensionsExtensionsAdvanced schema management tooling omnigres FeaturesFeatures · Extensions omni_seqExtensionsExtensionsDistributed integer sequences omnigres FeaturesFeatures · Extensions omni_serviceExtensionsExtensionsService management omnigres FeaturesFeatures · Extensions omni_sessionExtensionsExtensionsSession management omnigres FeaturesFeatures · Extensions omni_shmemExtensionsExtensionsShared Memory Management omni_shmem FeaturesFeatures · Extensions omni_sqlExtensionsExtensionsProgrammatic SQL manipulation omnigres FeaturesFeatures · Extensions omni_sqliteExtensionsExtensionsEmbedded SQLite omnigres FeaturesFeatures · Extensions omni_testExtensionsExtensionsTesting framework omnigres FeaturesFeatures · Extensions omni_txnExtensionsExtensionsTransaction management omnigres FeaturesFeatures · Extensions omni_typesExtensionsExtensionsAdvanced types omnigres FeaturesFeatures · Extensions omni_varExtensionsExtensionsScoped variables omnigres FeaturesFeatures · Extensions omni_vfsExtensionsExtensionsVirtual File System omnigres FeaturesFeatures · Extensions omni_vfs_types_v1ExtensionsExtensionsVirtual File System types (v1) omnigres FeaturesFeatures · Extensions omni_webExtensionsExtensionsCommon web stack primitives omnigres FeaturesFeatures · Extensions omni_workerExtensionsExtensionsGeneralized worker pool omnigres FeaturesFeatures · Extensions omni_xmlExtensionsExtensionsXML toolkit omnigres FeaturesFeatures · Extensions omni_yamlExtensionsExtensionsYAML toolkit omnigres FeaturesFeatures · Extensions omnidb_plpgsql_debuggerExtensionsExtensionsPostgreSQL extension for enabling PL/pgSQL debugger in OmniDB plpgsql_debugger Procedural languagesProcedural languages · Extensions omnidb_pluginExtensionsExtensionsPostgreSQL plugin for enabling PL/pgSQL debugger in OmniDB debugger functions plpgsql omnidb_plugin Procedural languagesProcedural languages · Extensions omnisketchExtensionsExtensionsdata structure for on-line agg of data into approximate sketch omnisketch Functions and aggregatesFunctions and aggregates · Extensions ON CONFLICTSQL CommandsPG18ON CONFLICT Clause 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…INSERT › Parameters › ON CONFLICT Clause ON CONFLICT ClauseManual ChaptersPG18ON CONFLICT Clause 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…ON CONFLICT Clause onesparseExtensionsExtensionsSparse linear algebra and graph extension for PostgreSQL 18 one_sparse FeaturesFeatures · Extensions online_advisorExtensionsExtensionsSuggest missing indexes and extended statistics online online_advisor AdministrationAdministration · Extensions ONLYSQL CommandsPG18ONLY and 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 p…SELECT › Compatibility › ONLY and Inheritance