Search PostgreSQL documentation

IS NOT DOCUMENTSQL CommandsPG18XML Functions › XML Predicates › IS NOT DOCUMENT# xml IS NOT DOCUMENT → boolean The expression IS NOT DOCUMENT returns false if the argument XML value is a proper XML document, true if it is not (that is, it is a content fragment), or nul… IS NOT DOCUMENTManual ChaptersPG18XML Functionsxml IS NOT DOCUMENT → boolean The expression IS NOT DOCUMENT returns false if the argument XML value is a proper XML document, true if it is not (that is, it is a content fragment), or null … is_jsonb_validExtensionsExtensionsFeatures · ExtensionsNative PostgreSQL extension for validating jsonb values against JSON Schema draft 4 and draft 7. json json-schema jsonb validation is_jsonb_valid Features is_validFunctionsPG18isn — data types for international standard numbers (ISBN, EAN, UPC, etc.) › Functions and Operators( isn ) → boolean Checks for the presence of the invalid-check-digit flag. isnExtensionsPG18isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)data types for international standard numbers (ISBN, EAN, UPC, etc.) The isn module provides data types for the following international product numbering standards: EAN13, UPC, ISBN (books),… isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)Manual ChaptersPG18The isn module provides data types for the following international product numbering standards: EAN13, UPC, ISBN (books), ISMN (music), and ISSN (serials). Numbers are validated on input acc… isn_weakFunctionsPG18isn — data types for international standard numbers (ISBN, EAN, UPC, etc.) › Functions and Operators( boolean ) → boolean Sets the weak input mode, and returns the new setting. This function is retained for backward compatibility. The recommended way to set weak mode is via the isn.weak co… iso_codesExtensionsExtensionsData types · ExtensionsISO country code enum/data types for PostgreSQL, generated with pgrx. data-type pgrx reference-data emi_monorepo Data types Ispell DictionaryManual ChaptersPG18DictionariesThe Ispell dictionary template supports morphological dictionaries, which can normalize many different linguistic forms of a word into the same lexeme. For example, an English Ispell diction… Issuing QueriesManual ChaptersPG18Pipeline ModeAfter entering pipeline mode, the application dispatches requests using PQsendQueryParams or its prepared-query sibling PQsendQueryPrepared. These requests are queued on the client-side unti… istoreExtensionsExtensionsData types · ExtensionsInteger-to-integer key/value store for analytic workloads. analytics hstore integer key-value istore Data types istoriaExtensionsExtensionsTime series · ExtensionsTable history management with non-linear undo/redo audit history plpgsql undo-redo istoria Time series italian_codesExtensionsExtensionsData types · ExtensionsValidation domains for Italian fiscal and VAT codes domain fiscal-code italy validation italian_codes Data types italian_ftsExtensionsExtensionsFull-text search · ExtensionsItalian full-text search dictionary dictionary full-text search ispell italian italian_fts Full-text search ivorysql_oraExtensionsExtensionsCompatibility · ExtensionsOracle Compatible extension on Postgres Database fork ivory ivorysql Compatibility jalali_utilsExtensionsExtensionsTime series · ExtensionsConvert Gregorian dates and timestamps to Jalali calendar values. jalali-calendar jalali-date postgresql shamsi-calendar jalali_utils Time series jansson-jsonExtensionsExtensionsData types · ExtensionsJSON data type, operators, and functions backed by the Jansson JSON library. data-type jansson json jansson-json Data types jdbc2_fdwExtensionsExtensionsForeign data wrappers · ExtensionsExperimental foreign data wrapper for JDBC-accessible databases with remote filter pushdown. fdw jdbc jni query-pushdown jdbc2_fdw Foreign data wrappers jdbc_fdwExtensionsExtensionsForeign data wrappers · Extensionsforeign-data wrapper for remote servers available over JDBC jdbc_fdw Foreign data wrappers jessevent@ai_sqlExtensionsExtensionsAI and vectors · ExtensionsAI inference SQL functions for Supabase. Self-deploys its own edge function via ai.deploy(). database.dev tle jessevent@ai_sql AI and vectors jessevent@supa_aisqlExtensionsExtensionsAI and vectors · ExtensionsAI inference SQL functions for Supabase. Self-deploys its own edge function via ai.deploy(). database.dev tle jessevent@supa_aisql AI and vectors jessevent@supa_privacyExtensionsExtensionsSecurity · ExtensionsFormatting-preserving anonymisation and data masking database.dev tle jessevent@supa_privacy Security jessevent@supa_profileExtensionsExtensionsMonitoring · ExtensionsDatabase table and column statistical profiler database.dev tle jessevent@supa_profile Monitoring jevExtensionsExtensionsAI and vectors · ExtensionsNatural-language row filtering, ranking and classification through TypeSafe ai classification plpython jev AI and vectors jieba_parserExtensionsExtensionsFull-text search · ExtensionsJieba parser for full-text search. chinese fts jieba parser jieba_parser Full-text search jiebaparserExtensionsExtensionsFull-text search · ExtensionsPostgresql full-text search extension for chinese (jiaba engine) using shared mem. jiebaparser Full-text search JIT Accelerated OperationsManual ChaptersPG18What Is JIT compilation?Currently PostgreSQL's JIT implementation has support for accelerating expression evaluation and tuple deforming. Several other operations could be accelerated in the future. Expression eval… JIT Provider InterfaceManual ChaptersPG18ExtensibilityA JIT provider is loaded by dynamically loading the named shared library. The normal library search path is used to locate the library. To provide the required JIT provider callbacks and to … job_queueExtensionsExtensionsFeatures · ExtensionsProof-of-concept database-side asynchronous job queue using dynamic PostgreSQL background workers. asynchronous background-worker job-queue pg_job_queue Features JOINManual ChaptersPG18Operator Optimization InformationThe JOIN clause, if provided, names a join selectivity estimation function for the operator. (Note that this is a function name, not an operator name.) JOIN clauses only make sense for binar… Joined TablesManual ChaptersPG18Table ExpressionsA joined table is a table derived from two other (real or derived) tables according to the rules of the particular join type. Inner, outer, and cross-joins are available. The general syntax … Joins Between TablesManual ChaptersPG18Thus far, our queries have only accessed one table at a time. Queries can access multiple tables at once, or access the same table in such a way that multiple rows of the table are being pro… JSON Functions and OperatorsManual ChaptersPG18This section describes: functions and operators for processing and creating JSON data the SQL/JSON path language the SQL/JSON query functions To provide native support for JSON data types wi… JSON Input and Output SyntaxManual ChaptersPG18JSON TypesThe input/output syntax for the JSON data types is as specified in RFC 7159. The following are all valid json (or jsonb) expressions: -- Simple scalar/primitive value -- Primitive values can… JSON TypesManual ChaptersPG18JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 7159. Such data can also be stored as text, but the JSON data types have the advantage of enforcin… json_accessorsExtensionsExtensionsFunctions and aggregates · ExtensionsJSON accessor functions function json json_accessors Functions and aggregates json_buildExtensionsExtensionsFunctions and aggregates · ExtensionsC functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays. array build json object json_build Functions and aggregates json_enhancements_no_hstoreExtensionsExtensionsFeatures · ExtensionsBackport of pg 9.3 JSON enhancements to PostgreSQL 9.2 aggregate array enhancements hstore json json path keys path record values json_enhancements Features json_enhancements_with_hstoreExtensionsExtensionsFeatures · ExtensionsBackport of pg 9.3 JSON enhancements to PostgreSQL 9.2 aggregate array enhancements hstore json json path keys path record values json_enhancements Features json_fdwExtensionsExtensionsForeign data wrappers · ExtensionsForeign data wrapper for local and remote JSON document access. fdw foreign data wrapper json json_fdw json_fdw Foreign data wrappers