Routines

natural exponential (e^x)

find first match for regexp

jsonpath exists test

I/O

convert circle to 12-vertex polygon

implementation of <= operator

sum of products of independent times dependent variable (sum(X*Y) - sum(X) * sum(Y)/N)

implementation of = operator

minimum value of all numeric input values

nearest integer <= value

planner support for array_unnest

length in bits

implementation of &< operator

statistics: number of backends in database

implementation of <= operator

implementation of / operator

test property of an index

sum of squares of the independent variable (sum(X^2) - sum(X)^2/N)

larger of two

view ancestors of the partition

multirange typanalyze

internal conversion function for KOI8R to MULE_INTERNAL

float8 difference of two numeric values

I/O

implementation of >= operator

sort support

I/O

I/O

statistics: number of tuples updated

implementation of > operator

I/O

convert jsonb to float4

value truncated to ‘scale’ of zero

I/O

for use by pg_upgrade

implementation of @ operator

planner support for network_sub/superset

translate the replication origin’s name to its id

implementation of = operator

extract portion of string

sample variance of numeric input values (square of the sample standard deviation)

split string by pattern

GIN support

identity argument list of a function

implementation of - operator

I/O

SP-GiST support for quad tree over box

implementation of >> operator

historical alias for var_samp

implementation of -> operator

netmask length

historical alias for stddev_samp

BRIN multi minmax uuid distance

implementation of > operator

extended statistics expressions

implementation of * operator

statistics: number of tuples inserted since last vacuum

implementation of = operator

arcsine, degrees

send a notification event

area of circle

I/O

implementation of - operator

implementation of = operator

adjust varbit() to typmod length

intervals overlap?

sort support

extract portion of string

resume wal replay, if it was paused

truncate to integer

implementation of < operator

implementation of << operator

(internal)

I/O

square of the correlation coefficient

GIN array support

I/O typmod

get set of in-progress transactions in snapshot

implementation of #- operator

construct timestamp

minimum value of all text values

sine

nearest integer >= value

I/O

implementation of <> operator

finite date?

implementation of ## operator

convert float8 to numeric

GiST tsvector support

implementation of < operator

convert numeric to money

I/O

user privilege on any column by username, rel oid

larger of two

I/O

statistics: start time for backend’s current transaction

implementation of < operator

implementation of / operator

implementation of = operator

trim selected characters from right end of string

view partition tree tables

minimum value of all tid input values

join selectivity of regex non-match

implementation of = operator

statistics: reset collected statistics for a single replication slot

implementation of * operator

implementation of <= operator

extract portion of string

implementation of <@ operator

intervals overlap?

I/O typmod

I/O

less-equal-greater

implementation of > operator

aggregate final function

elements of json array

bitwise-and smallint aggregate

join selectivity of tsvector @@ tsquery

is the range’s upper bound inclusive?

join selectivity of case-insensitive regex non-match

implementation of = operator

internal conversion function for EUC_KR to MULE_INTERNAL

maximum value of all integer input values

I/O

implementation of <= operator

implementation of <-> operator

implementation of > operator

implementation of + operator

implementation of ?# operator

I/O

SP-GiST support for quad tree over range

larger of two

get bit

implementation of < operator

replace all occurrences in string of old_substr with new_substr

implementation of = operator

greatest common divisor

get xmin of snapshot

I/O

set bit

restriction selectivity of regex non-match

SP-GiST support for quad tree and k-d tree over point

start time of an online backup

aggregate combine function

statistics: port number of client connected to backend

I/O

I/O

I/O

integer rank with gaps

is a relation insertable/updatable/deletable

I/O

I/O

implementation of @@ operator

jsonpath query wrapped into array

implementation of ?- operator

perpendicular

peek at binary changes from replication slot

internal conversion function for WIN866 to WIN1251

implementation of - operator

statistics: number of tuples hot updated

natural logarithm

window RANGE support

statistics: number of buffers written by the bgwriter for cleaning dirty buffers

implementation of ## operator

show all parts of inet/cidr value

GIN tsvector support

large object close

I/O

I/O

planner support for varbit length coercion

implementation of &<| operator

list objects dropped by the current command

convert int2 to int4

implementation of = operator

implementation of |>> operator

inet address of the server

bitwise-xor bigint aggregate

I/O

adjust timestamp precision

I/O

I/O

I/O

join selectivity of NOT ILIKE

hash

implementation of = operator

implementation of # operator

internal conversion function for KOI8U to UTF8

implementation of <= operator

BRIN bloom support

GiST tsquery support

normalize one word by dictionary

implementation of &> operator

implementation of < operator

current wal flush location

statistics: information about SLRU caches

returns whether a relation can be part of a publication

hash

sample standard deviation of bigint input values

maximum octet length of a character in given encoding

isolationtester support function

aggregate combine function

I/O

daterange constructor

I/O

I/O

hash

restriction selectivity for multirange operators

convert timestamp with time zone to time with time zone

user privilege on database by user oid, database name

implementation of | operator

I/O

upper bound of multirange

implementation of < operator

server’s port number for this connection

rotate log file - old version for adminpack 1.0

statistics: last reset for a database

internal conversion function for EUC_CN to UTF8

I/O

implementation of -|- operator

aggregate final function

implementation of <> operator

convert text to name

create a named restore point

generate headline from jsonb

maximum value of all float8 input values

implementation of <> operator

aggregate transition function

convert first char to int4

join selectivity of <> and related operators

pg_controldata general state information as a function

obtain shared advisory lock if available

internal conversion function for WIN866 to ISO-8859-5

implementation of = operator

smaller of two

hash

convert points to line segment

statistics: wait event on which backend is currently waiting

convert date and time with time zone to timestamp with time zone

maximum value of all time with time zone input values

BERNOULLI tablesample method handler

implementation of ?- operator

aggregate transition function

I/O

I/O

exponentiation

the average (arithmetic mean) as numeric of all bigint values

aggregate transition function

implementation of >= operator

map array to json with optional pretty printing

internal conversion function for UTF8 to EUC_JIS_2004

sum as float8 across all float8 input values

I/O

implementation of <@ operator

implementation of < operator

implementation of + operator

sort support

construct time

promote groups of 24 hours to numbers of days and promote groups of 30 days to numbers of months

map query result and structure to XML and XML Schema

implementation of + operator

aggregate final function

index description

I/O

aggregate transition function

aggregate final function

split delimited text

is text search configuration visible in search path?

GIN tsvector support

implementation of !~~ operator

nearest integer >= value

less-equal-greater

implementation of - operator

implementation of |&> operator

window RANGE support

implementation of | operator

implementation of <= operator

list of files in the WAL directory

statistics: tuples deleted in database

SP-GiST support for quad tree over range

select statement of a view

relevance

implementation of <= operator

I/O

aggregate combine function

int4range constructor

bitwise-and bigint aggregate

arccosine, degrees

implementation of <= operator

aggregate final function

implementation of = operator

diagonal of

implementation of <= operator

less-equal-greater

implementation of <= operator

implementation of >> operator

implementation of ?# operator

implementation of / operator

implementation of + operator

split string by pattern

implementation of >= operator

user privilege on foreign data wrapper by username, foreign data wrapper oid

implementation of *<> operator

convert float4 to int4

I/O

statistics: number of tuples fetched by idxscan

convert LIKE pattern to use backslash escapes

map table structure to XML Schema

implementation of + operator

statistics: self execution time of function, in milliseconds

implementation of > operator

convert circle to box

implementation of * operator

I/O

current user privilege on server by server oid

user privilege on function by username, function oid

adjust interval precision

convert a numeric to a human readable text using size units

substitute portion of bitstring

implementation of <> operator

setup the transaction’s origin lsn and timestamp

get the available time zone names

cotangent

less-equal-greater

join selectivity of exact prefix

implementation of @@ operator

I/O

implementation of > operator

transform specified values from json to tsvector

I/O

I/O typmod

current user privilege on column by rel name, col name

obtain shared advisory lock

sum as numeric across all bigint input values

implementation of < operator

implementation of >= operator

I/O

I/O

octet length

I/O

obtain exclusive advisory lock if available

implementation of >= operator

convert LIKE pattern to use backslash escapes

adjust timestamp to new time zone

implementation of = operator

row security for current context active on table by table oid

statistics: checkpoint time spent writing buffers to disk, in milliseconds

GiST tsvector support

modulus

view system lock information

sort support

implementation of ?- operator

GIN tsvector support (obsolete)

implementation of > operator

adjust bit() to typmod length

convert jsonb to boolean

implementation of * operator

implementation of # operator

sum as interval across all interval input values

implementation of * operator

statistics: reset collected statistics for a single SLRU

implementation of ~<~ operator

bitwise-and bit aggregate

join selectivity of = and related operators

convert text to numeric

statistics: recovery conflicts in database caused by drop tablespace

extract portion of string

substitute portion of string

nummultirange constructor

sort support

I/O

I/O

aggregate transition function

implementation of <> operator

implementation of ?-| operator

internal conversion function for LATIN1 to MULE_INTERNAL

I/O

I/O

I/O typmod

json aggregate final function

larger of two

window RANGE support

position of substring

hash index access method handler

I/O

I/O

concatenate aggregate input into an array

implementation of > operator

I/O

current wal flush location

list available extension versions

user privilege on schema by username, schema oid

implementation of <@ operator

implementation of @> operator

create new large object with given content

concatenate aggregate input into a bytea

list an extension’s version update paths

minimum value of all enum input values

implementation of ^ operator

debug function for current text search configuration

extract field from timestamp with time zone

read text from a file

list files in the log directory

get record fields from a jsonb object

I/O

expand array to set of rows

smaller of two

statistics: number of blocks fetched in current transaction

implementation of + operator

less-equal-greater

implementation of < operator

horizontal

aggregate transition function

convert int4 to int2

I/O

copy a logical replication slot, changing temporality and plugin

(internal)

I/O

statistics: number of tuples hot updated in current transaction

implementation of > operator

aggregate final function

wal filename and byte offset, given a wal location

I/O

get set of records with fields from a json array of objects

implementation of < operator

I/O

commit status of transaction

I/O

implementation of - operator

implementation of + operator

intervals overlap?

I/O typmod

convert timestamp with time zone to time

statistics: number of blocks fetched

I/O

prepend element onto front of array

internal conversion function for GB18030 to UTF8

I/O

center of

implementation of <> operator

implementation of # operator

position of sub-bitstring

tsvector typanalyze

I/O

hash

character length

number of input rows for which the input expression is not null

finite timestamp?

implementation of <-> operator

implementation of * operator

I/O

implementation of / operator

smaller of two

referential integrity ON DELETE SET DEFAULT

convert float4 to numeric

I/O

random value

I/O

implementation of <> operator

unescape Unicode characters

implementation of - operator

obtain shared advisory lock

tstzmultirange constructor

implementation of @ operator

implementation of <> operator

aggregate deserial function

quote a possibly-null data value for usage in a querystring

validate an operator class

statistics: number of tuples read by seqscan

user privilege on server by user oid, server name

sample standard deviation of numeric input values

implementation of > operator

implementation of <= operator

implementation of = operator

implementation of <= operator

user privilege on relation by username, rel name

window RANGE support

sort support

convert text to date

statistics: last manual vacuum time for a table

large object create

convert proname to regprocedure

less-equal-greater

implementation of = operator

extract portion of bitstring

obtain exclusive advisory lock

implementation of / operator

I/O

statistics: number of blocks found in cache

I/O

user privilege on type by user oid, type oid

implementation of = operator

implementation of -> operator

less-equal-greater

hash

implementation of <> operator

implementation of > operator

equal image

larger of two

current user privilege on foreign data wrapper by foreign data wrapper oid

implementation of = operator

implementation of - operator

statistics: information about WAL archiver

implementation of < operator

I/O

statistics: reset collected statistics shared across the cluster

I/O

implementation of = operator

implementation of ?-| operator

increment, ignores second argument

implementation of <@ operator

sample variance of bigint input values (square of the sample standard deviation)

GiST support

implementation of + operator

average of the dependent variable (sum(Y)/N)

implementation of + operator

I/O

implementation of << operator

implementation of !~~* operator

sum of squares of the dependent variable (sum(Y^2) - sum(Y)^2/N)

statistics: deadlocks detected in database

convert int8 to oid

transform specified values from jsonb to tsvector

implementation of <= operator

trim spaces from right end of string

maximum value of all inet input values

SP-GiST support for quad tree over range

age of a multi-transaction ID, in multi-transactions before current multi-transaction

implementation of - operator

I/O

planner support for timestamp length coercion

I/O

internal conversion function for WIN1250 to LATIN2

large object unlink (delete)

hash a range

hash

user privilege on database by username, database name

minimum scale needed to represent the value

anymultirange cast

the average (arithmetic mean) as numeric of all smallint values

implementation of ~>~ operator

json aggregate transition function

is the multirange’s upper bound infinite?

release exclusive advisory lock

nearest integer <= value

implementation of <> operator

implementation of - operator

implementation of > operator

non-persistent series generator

(internal)

concatenate values with separators

I/O

int4multirange constructor

BRIN multi minmax support

implementation of <> operator

I/O

natural exponential (e^x)

minimum value of all time input values

I/O

larger of two

I/O

perpendicular

get byte

I/O

implementation of = operator

I/O

implementation of > operator

map query result structure to XML Schema

implementation of > operator

statistics: number of scans done for table/index in current transaction

GiST support

I/O

nummultirange constructor

convert money to numeric

matches LIKE expression

absolute value

implementation of ~ operator

user privilege on tablespace by user oid, tablespace oid

add/update ACL item

format timestamp with time zone to text

get transaction Id, commit timestamp and replication origin of latest transaction commit

I/O typmod

transform to tsquery

implementation of < operator

I/O

statistics: information about replication slot

implementation of >= operator

smaller of two

round to nearest integer

convert jsonb to int4

aggregate serial function

I/O

larger of two

delete lexeme

return reason code for table getting rewritten

GiST support

historical alias for stddev_samp

larger of two

implementation of ~~ operator

get the prepared statements for this session

SP-GiST support for radix tree over text

internal conversion function for SJIS to EUC_JP

hash

implementation of <@ operator

I/O

implementation of !~~ operator

implementation of *<= operator

extract the first n characters

absolute value

internal conversion function for EUC_KR to UTF8

statistics: last auto vacuum time for a table

fetch the Nth preceding row value with default

implementation of ~* operator

implementation of !~~* operator

implementation of ~~* operator

bitwise-xor integer aggregate

implementation of = operator

restriction selectivity of NOT ILIKE

combine aggregate input into a multirange

implementation of >= operator

current user privilege on column by rel oid, col attnum

SHOW ALL as a function

I/O

concatenate array elements, using delimiter and null string, into text

bitwise-or integer aggregate

internal conversion function for EUC_JP to SJIS

implementation of * operator

brin: standalone scan new table pages

GiST tsvector support

list of SQL keywords

SP-GiST support for radix tree over text

implementation of < operator

maximum value of all bpchar input values

GiST support

read text from a file

implementation of * operator

implementation of ~ operator

obtain exclusive advisory lock

statistics: number of manual vacuums for a table

internal conversion function for UTF8 to LATIN1

less-equal-greater

aggregate final function

user privilege on relation by user oid, rel name

statistics: timestamp of the current statistics snapshot

historical alias for var_samp

user privilege on language by user oid, language oid

get binary changes from replication slot

implementation of <@ operator

user privilege on database by user oid, database oid

I/O

smaller of two

date difference from today preserving months and years

I/O

implementation of >= operator

adjust timestamp to new time zone

sleep until the specified time

I/O

is the range’s upper bound infinite?

key value pairs of a json object

read entire large object

convert text to regclass

SP-GiST support

implementation of = operator

implementation of - operator

I/O

hyperbolic cosine

implementation of !~~ operator

SET X as a function

I/O

I/O

convert time to interval

implementation of >= operator

standard array subscripting support

generate headline

aggregate final function

extended statistics object description

statistics: information about currently active replication

aggregate final function

implementation of - operator

transform specified values from json to tsvector

I/O

get xmin of snapshot

aggregate input into jsonb

modulus

convert int8 number to hex

convert int8 to float8

statistics: wait event type on which backend is currently waiting

user privilege on function by username, function name

convert x, y to point

I/O

restriction selectivity for containment comparison operators

statistics: session time, in milliseconds

I/O

is xid8 visible in snapshot?

internal conversion function for EUC_TW to UTF8

current user privilege on database by database name

the average (arithmetic mean) as interval of all interval values

implementation of = operator

hash

fetch the Nth following row value with default

build a jsonb object from pairwise key/value inputs

implementation of > operator

large object import

prepare for taking an online backup

arctangent, two arguments

convert boolean to int4

I/O

get current snapshot

implementation of ?# operator

referential integrity FOREIGN KEY … REFERENCES

SP-GiST support

build an empty json array

sort support

larger of two

cotangent, degrees

aggregate final function

replace any occurrences of an element in an array

user privilege on foreign data wrapper by username, foreign data wrapper name

array subscripts generator

implementation of !~ operator

deparse an encoded expression

convert float8 to int2

implementation of ~~* operator

implementation of && operator

map schema contents and structure to XML and XML Schema

current user privilege on function by function oid

BRIN multi minmax int4 distance

write data at offset

get identification of SQL object

implementation of | operator

implementation of < operator

modulus

convert int8 to money

internal conversion function for MULE_INTERNAL to KOI8R

set random seed

statistics: discard current transaction’s statistics snapshot

hyperbolic sine

implementation of - operator

internal conversion function for WIN1251 to WIN866

internal conversion function for SHIFT_JIS_2004 to EUC_JIS_2004

statistics: number of tuples fetched by idxscan in current transaction

build a jsonb array from any inputs

implementation of >= operator

hostmask of address

statistics: self execution time of function in current transaction, in milliseconds

implementation of - operator

for use by pg_upgrade

reset the transaction’s origin lsn and timestamp

inverse hyperbolic tangent

extract portion of string

abbreviated display of inet value

total disk space usage for the specified table and associated indexes

implementation of <@ operator

least common multiple

implementation of << operator

get description for object id and catalog name

current wal write location

returns an array of offsets of some value in array

append element onto end of array

name of the current database

BRIN inclusion support

map array to json

convert name to text

implementation of !~~* operator

convert bytea value into some ascii-only text string

implementation of || operator

implementation of - operator

truncate to integer

left-pad string to length

window RANGE support

larger of two

I/O

implementation of <= operator

current wal insert location

is collation visible in search path?

implementation of < operator

aggregate transition function

implementation of >= operator

intervals overlap?

current schema name

implementation of <-> operator

I/O

remove last N elements of array

return Oid of the table getting rewritten

implementation of * operator

pause wal replay

implementation of >= operator

hash

convert int4 to char

less-equal-greater

statistics: total number of sessions

list all files in a directory

I/O

implementation of << operator

internal conversion function for WIN866 to KOI8R

I/O