Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Popular entries9775
IntervalStyleIntervalStyle
Client Connection Defaults
10
Sets the display format for interval values. The value sql_standard will produce output matching SQL standard interval literals. The value postgre…Configuration · Client Connection Defaults
intpairPacked int64pair data type with comparison, hash, and index operator support.
data-type index
pg_intpair
Data typesData types · Extensions
Introduction65.5.1. Introduction
BRIN stands for Block Range Index. BRIN is designed for handling very large tables in which certain columns have some natural correlation with their physical location wi…Introduction
Introduction65.1.1. Introduction
PostgreSQL includes an implementation of the standard btree (multi-way balanced tree) index data structure. Any data type that can be sorted into a well-defined linear o…Introduction
Introduction65.4.1. Introduction
GIN stands for Generalized Inverted Index. GIN is designed for handling cases where the items to be indexed are composite values, and the queries to be handled by the in…Introduction
Introduction65.2.1. Introduction
GiST stands for Generalized Search Tree. It is a balanced, tree-structured access method, that acts as a base template in which to implement arbitrary indexing schemes. …Introduction
Introduction11.1. Introduction
Suppose we have a table similar to this:
CREATE TABLE test1 ( id integer, content varchar );
and the application issues many queries of the form:
SELECT content FROM test1…Introduction
Introduction33.1. Introduction
All large objects are stored in a single system table named pg_largeobject. Each large object also has an entry in the system table pg_largeobject_metadata. Large objects …Introduction
Introduction13.1. Introduction
PostgreSQL provides a rich set of tools for developers to manage concurrent access to data. Internally, data consistency is maintained by using a multiversion model (Multi…Introduction
Introduction65.3.1. Introduction
SP-GiST is an abbreviation for space-partitioned GiST. SP-GiST supports partitioned search trees, which facilitate development of a wide range of different non-balanced …Introduction
Introduction12.1. Introduction
Full Text Searching (or just text search) provides the capability to identify natural-language documents that satisfy a query, and optionally to sort them by relevance to …Introduction
Introduction3.1. Introduction
In the previous chapter we have covered the basics of using SQL to store and access your data in PostgreSQL. We will now discuss some more advanced features of SQL that sim…Introduction
Introduction2.1. Introduction
This chapter provides an overview of how to use SQL to perform simple operations. This tutorial is only intended to give you an introduction and is in no way a complete tut…Introduction
intsetintset ( integer ) → integer[] Makes a single-element array. intset(42) → {42}intarray — manipulate arrays of integers › intarray Functions and Operators
io_combine_limitio_combine_limit
Resource Usage
17
Controls the largest I/O size in operations that combine I/O. If this value is specified without units, it is taken as blocks, that is BLCKSZ bytes, typica…Configuration · Resource Usage
io_max_combine_limitio_max_combine_limit
Resource Usage
18
Controls the largest I/O size in operations that combine I/O, and silently limits the user-settable parameter io_combine_limit. This parameter can only…Configuration · Resource Usage
io_max_concurrencyio_max_concurrency
Resource Usage
18
Controls the maximum number of I/O operations that one process can execute simultaneously. The default setting of -1 selects a number based on shared_buf…Configuration · Resource Usage
io_max_workersio_max_workers
Resource Usage
19
Sets the maximum number of I/O worker processes. The default is 8. This parameter can only be set in the postgresql.conf file or on the server command line. …Configuration · Resource Usage
io_methodio_method
Resource Usage
18
Selects the method for executing asynchronous I/O. Possible values are: worker (execute asynchronous I/O using worker processes) io_uring (execute asynchronous I/…Configuration · Resource Usage
io_min_workersio_min_workers
Resource Usage
19
Sets the minimum number of I/O worker processes. The default is 2. This parameter can only be set in the postgresql.conf file or on the server command line. …Configuration · Resource Usage
io_worker_idle_timeoutio_worker_idle_timeout
Resource Usage
19
Sets the time after which entirely idle I/O worker processes exit, reducing the size of pool to match demand. The default is 1 minute. This parameter…Configuration · Resource Usage
io_worker_launch_intervalio_worker_launch_interval
Resource Usage
19
Sets the minimum time before another I/O worker can be launched. This avoids creating too many for an unsustained burst of activity. The default i…Configuration · Resource Usage
io_workersio_workers
Resource Usage
18
Selects the number of I/O worker processes to use. The default is 3. This parameter can only be set in the postgresql.conf file or on the server command line. On…Configuration · Resource Usage
IoWorkerMainIoWorkerMain
Activity
18
Waiting in main loop of IO Worker process.
19
20
This is normally expected idleness for the matching background process.
Investigate only when queued work or a shutd…Wait Events · Activity
ip4rIPv4/v6 and IPv4/v6 range index type for PostgreSQL
ip4r
Data typesData types · Extensions
ipinfoIP geolocation lookup functions backed by the ipinfo.io HTTP service.
ip geolocation http ipinfo
ipinfo
GeospatialGeospatial · Extensions
IS DOCUMENT9.15.2.1. IS DOCUMENT # xml IS DOCUMENT → boolean The expression IS DOCUMENT returns true if the argument XML value is a proper XML document, false if it is not (that is, it is a content fra…XML Functions › XML Predicates › IS DOCUMENT
IS DOCUMENT9.15.2.1. IS DOCUMENT
xml IS DOCUMENT → boolean
The expression IS DOCUMENT returns true if the argument XML value is a proper XML document, false if it is not (that is, it is a content fragm…IS DOCUMENT
IS NOT DOCUMENT9.15.2.2. 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…XML Functions › XML Predicates › IS NOT DOCUMENT
IS NOT DOCUMENT9.15.2.2. 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 c…IS NOT DOCUMENT
is_jsonb_validNative PostgreSQL extension for validating jsonb values against JSON Schema draft 4 and draft 7.
json json-schema jsonb validation
is_jsonb_valid
FeaturesFeatures · Extensions
is_validis_valid ( isn ) → boolean Checks for the presence of the invalid-check-digit flag.isn — data types for international standard numbers (ISBN, EAN, UPC, etc.) › Functions and Operators
isclosedisclosed
Geometric Functions And Operators
10
a closed path?
isclosed ( path ) → boolean a closed path?
11
12
13
Is path closed?
isclosed ( path ) → boolean Is path closed?
14
15
16
17
18
19…Functions · Geometric Functions And Operators
isemptyisempty
Range/Multirange Functions And Operators
10
is the range empty?
isempty ( anyrange ) → boolean is the range empty?
11
12
13
Is the range empty?
isempty ( anyrange ) → boolean Is the …Functions · Range/Multirange Functions And Operators
isfiniteisfinite
Date/Time Functions And Operators
10
Test for finite date (not +/-infinity)
isfinite ( date ) → boolean Test for finite date (not +/-infinity)
isfinite ( timestamp ) → boolean Test …Functions · Date/Time Functions And Operators
isnF.20. isn — 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, I…isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)
isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)F.20. isn — 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, I…isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)
isn_weakisn_weak ( 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 is…isn — data types for international standard numbers (ISBN, EAN, UPC, etc.) › Functions and Operators
iso_codesISO country code enum/data types for PostgreSQL, generated with pgrx.
data-type pgrx reference-data
emi_monorepo
Data typesData types · Extensions
isopenisopen
Geometric Functions And Operators
10
an open path?
isopen ( path ) → boolean an open path?
11
12
13
Is path open?
isopen ( path ) → boolean Is path open?
14
15
16
17
18
19
20
9.0
9.1
…Functions · Geometric Functions And Operators
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open