Search PostgreSQL documentation

Ispell DictionaryManual ChaptersPG1812.6.5. Ispell Dictionary The Ispell dictionary template supports morphological dictionaries, which can normalize many different linguistic forms of a word into the same lexeme. For example,…Ispell Dictionary Issuing QueriesManual ChaptersPG1832.5.1.1. Issuing Queries After entering pipeline mode, the application dispatches requests using PQsendQueryParams or its prepared-query sibling PQsendQueryPrepared. These requests are queu…Issuing Queries istoreExtensionsExtensionsInteger-to-integer key/value store for analytic workloads. analytics hstore integer key-value istore Data typesData types · Extensions istoriaExtensionsExtensionsTable history management with non-linear undo/redo audit history plpgsql undo-redo istoria Time seriesTime series · Extensions italian_codesExtensionsExtensionsValidation domains for Italian fiscal and VAT codes domain fiscal-code italy validation italian_codes Data typesData types · Extensions italian_ftsExtensionsExtensionsItalian full-text search dictionary dictionary full-text search ispell italian italian_fts Full-text searchFull-text search · Extensions ivorysql_oraExtensionsExtensionsOracle Compatible extension on Postgres Database fork ivory ivorysql CompatibilityCompatibility · Extensions jalali_utilsExtensionsExtensionsConvert Gregorian dates and timestamps to Jalali calendar values. jalali-calendar jalali-date postgresql shamsi-calendar jalali_utils Time seriesTime series · Extensions jansson-jsonExtensionsExtensionsJSON data type, operators, and functions backed by the Jansson JSON library. data-type jansson json jansson-json Data typesData types · Extensions jdbc2_fdwExtensionsExtensionsExperimental foreign data wrapper for JDBC-accessible databases with remote filter pushdown. fdw jdbc jni query-pushdown jdbc2_fdw Foreign data wrappersForeign data wrappers · Extensions jdbc_fdwExtensionsExtensionsforeign-data wrapper for remote servers available over JDBC jdbc_fdw Foreign data wrappersForeign data wrappers · Extensions jessevent@ai_sqlExtensionsExtensionsAI inference SQL functions for Supabase. Self-deploys its own edge function via ai.deploy(). database.dev tle jessevent@ai_sql AI and vectorsAI and vectors · Extensions jessevent@supa_aisqlExtensionsExtensionsAI inference SQL functions for Supabase. Self-deploys its own edge function via ai.deploy(). database.dev tle jessevent@supa_aisql AI and vectorsAI and vectors · Extensions jessevent@supa_privacyExtensionsExtensionsFormatting-preserving anonymisation and data masking database.dev tle jessevent@supa_privacy SecuritySecurity · Extensions jessevent@supa_profileExtensionsExtensionsDatabase table and column statistical profiler database.dev tle jessevent@supa_profile MonitoringMonitoring · Extensions jevExtensionsExtensionsNatural-language row filtering, ranking and classification through TypeSafe ai classification plpython jev AI and vectorsAI and vectors · Extensions jieba_parserExtensionsExtensionsJieba parser for full-text search. chinese fts jieba parser jieba_parser Full-text searchFull-text search · Extensions jiebaparserExtensionsExtensionsPostgresql full-text search extension for chinese (jiaba engine) using shared mem. jiebaparser Full-text searchFull-text search · Extensions jitConfigurationReferencejit Query Tuning 11 Determines whether JIT compilation may be used by PostgreSQL, if available (see Chapter 32). The default is off. 12 Determines whether JIT compilation may be used by Post…Configuration · Query Tuning JIT Accelerated OperationsManual ChaptersPG1830.1.1. JIT Accelerated Operations Currently PostgreSQL's JIT implementation has support for accelerating expression evaluation and tuple deforming. Several other operations could be acceler…JIT Accelerated Operations JIT Provider InterfaceManual ChaptersPG1830.4.2.1. JIT Provider Interface A 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 requir…JIT Provider Interface jit_above_costConfigurationReferencejit_above_cost Query Tuning 11 Sets the query cost above which JIT compilation is activated, if enabled (see Chapter 32). Performing JIT costs planning time but can accelerate query executio…Configuration · Query Tuning jit_debugging_supportConfigurationReferencejit_debugging_support Developer Options 11 If LLVM has the required functionality, register generated functions with GDB. This makes debugging easier. The default setting is off. This parame…Configuration · Developer Options jit_dump_bitcodeConfigurationReferencejit_dump_bitcode Developer Options 11 Writes the generated LLVM IR out to the file system, inside data_directory. This is only useful for working on the internals of the JIT implementation. …Configuration · Developer Options jit_expressionsConfigurationReferencejit_expressions Developer Options 11 Determines whether expressions are JIT compiled, when JIT compilation is activated (see Section 32.2). The default is on. 12 Determines whether expressio…Configuration · Developer Options jit_inline_above_costConfigurationReferencejit_inline_above_cost Query Tuning 11 Sets the query cost above which JIT compilation attempts to inline functions and operators. Inlining adds planning time, but can improve execution speed…Configuration · Query Tuning jit_optimize_above_costConfigurationReferencejit_optimize_above_cost Query Tuning 11 Sets the query cost above which JIT compilation applies expensive optimizations. Such optimization adds planning time, but can improve execution speed…Configuration · Query Tuning jit_profiling_supportConfigurationReferencejit_profiling_support Developer Options 11 If LLVM has the required functionality, emit the data needed to allow perf to profile functions generated by JIT. This writes out files to $HOME/.d…Configuration · Developer Options jit_providerConfigurationReferencejit_provider Client Connection Defaults 11 This variable is the name of the JIT provider library to be used (see Section 32.4.2). The default is llvmjit. This parameter can only be set at se…Configuration · Client Connection Defaults jit_tuple_deformingConfigurationReferencejit_tuple_deforming Developer Options 11 Determines whether tuple deforming is JIT compiled, when JIT compilation is activated (see Section 32.2). The default is on. 12 Determines whether tu…Configuration · Developer Options job_queueExtensionsExtensionsProof-of-concept database-side asynchronous job queue using dynamic PostgreSQL background workers. asynchronous background-worker job-queue pg_job_queue FeaturesFeatures · Extensions JOINManual ChaptersPG1836.15.4. JOIN The 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 s…JOIN join_collapse_limitConfigurationReferencejoin_collapse_limit Query Tuning 10 The planner will rewrite explicit JOIN constructs (except FULL JOINs) into lists of FROM items whenever a list of no more than this many items would resul…Configuration · Query Tuning Joined TablesManual ChaptersPG187.2.1.1. Joined Tables A 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 availab…Joined Tables Joins Between TablesManual ChaptersPG182.6. Joins Between Tables Thus 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 …Joins Between Tables jsonData TypesPG18json textual JSON dataData Types jsonFunctionsReferencejson Json Functions And Operators 11 reduce each value in the document, specified by filter to a tsvector, and then concatenate those in document order to produce a single tsvector. filter i…Functions · Json Functions And Operators JSON Functions and OperatorsManual ChaptersPG189.16. JSON Functions and Operators This section describes: functions and operators for processing and creating JSON data the SQL/JSON path language the SQL/JSON query functions To provide na…JSON Functions and Operators JSON Input and Output SyntaxManual ChaptersPG188.14.1. JSON Input and Output Syntax The 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/pr…JSON Input and Output Syntax JSON TypesManual ChaptersPG188.14. JSON Types JSON 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 adva…JSON Types