Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Popular entries9756
5400154001
Class 54 · Program Limit Exceeded
10
statement_too_complex
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 54001
## At a glance {#at-a-glance}
`54001` covers a statement …SQLSTATE · Class 54 · Program Limit Exceeded
5401154011
Class 54 · Program Limit Exceeded
10
too_many_columns
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 54011
## At a glance {#at-a-glance}
`54011` reports that a physical …SQLSTATE · Class 54 · Program Limit Exceeded
5402354023
Class 54 · Program Limit Exceeded
10
too_many_arguments
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 54023
## At a glance {#at-a-glance}
`54023` is the argument-count …SQLSTATE · Class 54 · Program Limit Exceeded
5500055000
Class 55 · Object Not In Prerequisite State
10
object_not_in_prerequisite_state
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 55000 — Object not in prerequisite state
##…SQLSTATE · Class 55 · Object Not In Prerequisite State
5500655006
Class 55 · Object Not In Prerequisite State
10
object_in_use
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 55006 — Object in use
## At a glance {#at-a-glance}
`55006` r…SQLSTATE · Class 55 · Object Not In Prerequisite State
55P0255P02
Class 55 · Object Not In Prerequisite State
10
cant_change_runtime_param
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 55P02
## At a glance {#at-a-glance}
`55P02` means…SQLSTATE · Class 55 · Object Not In Prerequisite State
55P0355P03
Class 55 · Object Not In Prerequisite State
10
lock_not_available
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 55P03
## At a glance {#at-a-glance}
`55P03` reports that…SQLSTATE · Class 55 · Object Not In Prerequisite State
55P0455P04
Class 55 · Object Not In Prerequisite State
12
unsafe_new_enum_value_usage
13
14
15
16
17
18
19
20
# 55P04
## At a glance {#at-a-glance}
`55P04` protects the commit-before-use rule f…SQLSTATE · Class 55 · Object Not In Prerequisite State
5700057000
Class 57 · Operator Intervention
10
operator_intervention
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57000
## At a glance {#at-a-glance}
`57000` is the SQLSTATE Class…SQLSTATE · Class 57 · Operator Intervention
5701457014
Class 57 · Operator Intervention
10
query_canceled
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
## At a glance {#at-a-glance}
`57014` is PostgreSQL's `query_canceled` co…SQLSTATE · Class 57 · Operator Intervention
57P0157P01
Class 57 · Operator Intervention
10
admin_shutdown
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57P01
## At a glance {#at-a-glance}
`57P01` is a server-initiated admini…SQLSTATE · Class 57 · Operator Intervention
57P0257P02
Class 57 · Operator Intervention
10
crash_shutdown
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57P02
## At a glance {#at-a-glance}
`57P02` is the crash-shutdown path. …SQLSTATE · Class 57 · Operator Intervention
57P0357P03
Class 57 · Operator Intervention
10
cannot_connect_now
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57P03
## At a glance {#at-a-glance}
`57P03` is emitted during connec…SQLSTATE · Class 57 · Operator Intervention
57P0457P04
Class 57 · Operator Intervention
10
database_dropped
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57P04
## At a glance {#at-a-glance}
`57P04` is selected when a recover…SQLSTATE · Class 57 · Operator Intervention
57P0557P05
Class 57 · Operator Intervention
14
idle_session_timeout
15
16
17
18
19
20
# 57P05
## At a glance {#at-a-glance}
`57P05` terminates a session after `idle_session_timeout` expires whil…SQLSTATE · Class 57 · Operator Intervention
5800058000
Class 58 · System Error (errors external to PostgreSQL itself)
10
system_error
11
12
13
14
15
16
17
18
19
20
9.2
9.3
9.4
9.5
9.6
# 58000
## At a glance {#at-a-glance}
`58000` is the s…SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
5803058030
Class 58 · System Error (errors external to PostgreSQL itself)
10
io_error
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 58030
## At a glance {#at-a-glance}
`58030` is …SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
58P0158P01
Class 58 · System Error (errors external to PostgreSQL itself)
10
undefined_file
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 58P01
## At a glance {#at-a-glance}
`58P0…SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
58P0258P02
Class 58 · System Error (errors external to PostgreSQL itself)
10
duplicate_file
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 58P02
## At a glance {#at-a-glance}
`58P0…SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
58P0358P03
Class 58 · System Error (errors external to PostgreSQL itself)
18
file_name_too_long
19
20
# 58P03
## At a glance {#at-a-glance}
`58P03` is selected by PostgreSQL's file-access errno…SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
7200072000
Class 72 · Snapshot Failure
10
snapshot_too_old
11
12
13
14
15
16
9.6
# 72000
## At a glance {#at-a-glance}
`72000` is a historical `snapshot_too_old` error. PostgreSQL 16.15 still d…SQLSTATE · Class 72 · Snapshot Failure
<value < value → boolean Less-than comparison jsonb_path_query_array('[1, 2, 3]', '$[*] ? (@ < 2)') → [1]JSON Functions and Operators › The SQL/JSON Path Language › SQL/JSON Path Operators and Methods
<#>cube <#> cube → float8 Computes the taxicab (L-1 metric) distance between the two cubes.cube — a multi-dimensional cube data type › Usage
<%text <% text → boolean Returns true if the similarity between the trigram set in the first argument and a continuous extent of an ordered trigram set in the second argument is greater than t…pg_trgm — support for similarity of text using trigram matching › Functions and Operators
<->cube <-> cube → float8 Computes the Euclidean distance between the two cubes.cube — a multi-dimensional cube data type › Usage
<->>text <->> text → real Commutator of the <<-> operator.pg_trgm — support for similarity of text using trigram matching › Functions and Operators
<->>>text <->>> text → real Commutator of the <<<-> operator.pg_trgm — support for similarity of text using trigram matching › Functions and Operators
<<bit << integer → bit Bitwise shift left (string length is preserved) B'10001' << 3 → 01000Bit String Functions and Operators
<<%text <<% text → boolean Returns true if its second argument has a continuous extent of an ordered trigram set that matches word boundaries, and its similarity to the trigram set of the first…pg_trgm — support for similarity of text using trigram matching › Functions and Operators
<<->text <<-> text → real Returns the “distance” between the arguments, that is one minus the word_similarity() value.pg_trgm — support for similarity of text using trigram matching › Functions and Operators
<<<->text <<<-> text → real Returns the “distance” between the arguments, that is one minus the strict_word_similarity() value.pg_trgm — support for similarity of text using trigram matching › Functions and Operators
<<=inet <<= inet → boolean Is subnet contained by or equal to subnet? inet '192.168.1/24' <<= inet '192.168.1/24' → tNetwork Address Functions and Operators
<<|geometric_type <<| geometric_type → boolean Is first object strictly below second? Available for point, box, polygon, circle. box '(3,3),(0,0)' <<| box '(5,5),(3,4)' → tGeometric Functions and Operators
<=value <= value → boolean Less-than-or-equal-to comparison jsonb_path_query_array('["a", "b", "c"]', '$[*] ? (@ <= "b")') → ["a", "b"]JSON Functions and Operators › The SQL/JSON Path Language › SQL/JSON Path Operators and Methods
<=>cube <=> cube → float8 Computes the Chebyshev (L-inf metric) distance between the two cubes.cube — a multi-dimensional cube data type › Usage
<>value != value → boolean value <> value → boolean Non-equality comparison jsonb_path_query_array('[1, 2, 1, 3]', '$[*] ? (@ != 1)') → [2, 3] jsonb_path_query_array('["a", "b", "c"]', '$[*] ?…JSON Functions and Operators › The SQL/JSON Path Language › SQL/JSON Path Operators and Methods
<@cube <@ cube → boolean Is the first cube contained in the second?cube — a multi-dimensional cube data type › Usage
<@>point <@> point → float8 Computes the distance in statute miles between two points on the Earth's surface.earthdistance — calculate great-circle distances › Point-Based Earth Distances
<^box <^ box → boolean Is first object below second (allows edges to touch)? box '((1,1),(0,0))' <^ box '((2,2),(1,1))' → tGeometric Functions and Operators
=aclitem = aclitem → boolean Are aclitems equal? (Notice that type aclitem lacks the usual set of comparison operators; it has only equality. In turn, aclitem arrays can only be compared for …System Information Functions and Operators › Access Privilege Inquiry Functions
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open