LogoLogo
BlogDiscordGitHubDoltgres
  • Introduction
    • What is Doltgres?
    • Installation
    • Getting Started
  • Concepts
    • Git
      • Commits
      • Log
      • Diff
      • Branch
      • Merge
      • Conflicts
      • Remotes
      • Working Set
    • SQL
      • Databases
      • Schema
      • Tables
      • Primary Keys
      • Types
      • Indexes
      • Views
      • Constraints
      • Triggers
      • Functions
      • Procedures
      • Users/Grants
      • Transactions
      • System Variables
    • RDBMS
      • Server
      • Backups
      • Replication
  • Guides
    • Cheat Sheet
    • Replication from Postgres
  • Reference
    • Running the Server
      • Configuration
      • Access Management
      • Branch Permissions
      • Backups
      • Garbage Collection
      • Metrics
      • Replication
      • Troubleshooting
    • Version Control Features
      • Using Branches
      • Merges
      • Querying History
      • Using Remotes
      • Functions
      • System Tables
      • System Variables
    • SQL Language Support
      • Supported Functions and Operators
      • Supported Types
      • Supported SQL Commands
      • System Catalog Schema
    • Supported Clients
      • Programmatic
    • Benchmarks
      • Correctness
      • Latency
Powered by GitBook
On this page
  • Logical Operators
  • Comparison Operators
  • Comparison Predicates
  • Comparison Functions
  • Mathematical Operators
  • Mathematical Functions
  • Random Functions
  • Trigonometric Functions
  • Hyperbolic Functions
  • SQL String Functions and Operators
  • Other String Functions
  • SQL Binary String Functions
  • Other Binary String Functions
  • Text/Binary String Conversion Functions
  • Bit String Operators
  • Bit String Functions
  • Pattern Matching
  • Regular Expression Match Operators
  • Formatting Functions
  • Date/Time Operators
  • Date/Time Functions
  • Enum Support Functions
  • Geometric Operators
  • Geometric Functions
  • Geometric Type Conversion Functions
  • IP Address Operators
  • IP Address Functions
  • MAC Address Functions
  • Text Search Operators
  • Text Search Functions
  • Text Search Debugging Functions
  • UUID Functions
  • XML Functions
  • json and jsonb Operators
  • Additional jsonb Operators
  • JSON Creation Functions
  • JSON Processing Functions
  • SQL/JSON Query Functions
  • Sequence Functions
  • Conditional Expressions
  • Array Operators
  • Array Functions
  • Range Operators
  • Multirange Operators
  • Range Functions
  • Multirange Functions
  • General-Purpose Aggregate Functions
  • Aggregate Functions for Statistics
  • Ordered-Set Aggregate Functions
  • Hypothetical-Set Aggregate Functions
  • Grouping Operations
  • General-Purpose Window Functions
  • Merge Support Functions
  • Subquery Expressions
  • Series Generating Functions
  • Subscript Generating Functions
  • Session Information Functions
  • Access Privilege Inquiry Functions
  • aclitem Operators
  • aclitem Functions
  • Schema Visibility Inquiry Functions
  • System Catalog Information Functions
  • Object Information and Addressing Functions
  • Comment Information Functions
  • Data Validity Checking Functions
  • Transaction ID and Snapshot Information Functions
  • Committed Transaction Information Functions
  • Control Data Functions
  • Version Information Functions
  • WAL Summarization Information Functions
  • Configuration Settings Functions
  • Server Signaling Functions
  • Backup Control Functions
  • Recovery Information Functions
  • Recovery Control Functions
  • Snapshot Synchronization Functions
  • Replication Management Functions
  • Database Object Size Functions
  • Database Object Location Functions
  • Collation Management Functions
  • Partitioning Information Functions
  • Index Maintenance Functions
  • Generic File Access Functions
  • Advisory Lock Functions
  • Built-In Trigger Functions
  • Event Trigger Functions
  • Statistics Information Functions
  • Statistics Access Functions
  1. Reference
  2. SQL Language Support

Supported Functions and Operators

PreviousSQL Language SupportNextSupported Types

Last updated 3 months ago

Doltgres currently supports a subset of for the built-in data types. If you need any Postgres function that is not available in Doltgres yet, you can to let us know what you need.

Logical Operators

See detailed list in the .

Function
Supported
Notes and limitations

AND

✅

OR

✅

NOT

✅

Comparison Operators

See detailed list in the .

Function
Supported
Notes and limitations

datatype < datatype

✅

datatype > datatype

✅

datatype <= datatype

✅

datatype >= datatype

✅

datatype = datatype

✅

datatype <> datatype

✅

datatype != datatype

✅

Comparison Predicates

See detailed list in the .

Function
Supported
Notes and limitations

datatype [NOT] BETWEEN datatype AND datatype

❌

datatype BETWEEN SYMMETRIC datatype AND datatype

❌

datatype IS [NOT] DISTINCT FROM datatype

❌

datatype IS [NOT] NULL

❌

datatype IS [NOT] TRUE

❌

datatype IS [NOT] FALSE

❌

datatype IS [NOT] UNKNOWN

❌

Comparison Functions

Function
Supported
Notes and limitations

num_nonnulls

❌

num_nulls

❌

Mathematical Operators

Function
Supported
Notes and limitations

numeric_type + numeric_type

✅

+ numeric_type

✅

numeric_type - numeric_type

✅

- numeric_type

✅

numeric_type * numeric_type

✅

numeric_type / numeric_type

✅

numeric_type % numeric_type

✅

numeric_type ^ numeric_type

✅

|/ double_precision

❌

||/ double_precision

❌

@ numeric_type

❌

integral_type & integral_type

❌

integral_type | integral_type

❌

integral_type # integral_type

❌

~ integral_type

❌

integral_type << integer

❌

integral_type >> integer

❌

Mathematical Functions

Function
Supported
Notes and limitations

abs

✅

cbrt

✅

ceil

✅

ceiling

❌

degrees

✅

div

✅

erf

❌

erfc

❌

exp

✅

factorial

✅

floor

✅

gcd

✅

lcm

✅

ln

✅

log

✅

log10

✅

min_scale

✅

mod

✅

pi

✅

power

✅

radians

✅

round

✅

scale

✅

sign

✅

sqrt

✅

trim_scale

✅

trunc

✅

width_bucket

✅

Random Functions

Function
Supported
Notes and limitations

random

✅

setseed

❌

Trigonometric Functions

Function
Supported
Notes and limitations

acos

✅

acosd

✅

asin

✅

asind

✅

atan

✅

atand

✅

atan2

✅

atan2d

✅

cos

✅

cosd

✅

cot

✅

cotd

✅

sin

✅

sind

✅

tan

✅

tand

✅

Hyperbolic Functions

Function
Supported
Notes and limitations

sinh

✅

cosh

✅

tanh

✅

asinh

✅

acosh

✅

atanh

✅

SQL String Functions and Operators

Function
Supported
Notes and limitations

text || text

❌

anynonarray || text

❌

text || anynonarray

❌

text IS [NOT][form] NORMALIZED

❌

btrim

✅

bit_length

✅

char_length

✅

lower

✅

lpad

✅

ltrim

✅

normalize

❌

octet_length

✅

overlay

❌

position

❌

rpad

✅

rtrim

✅

substring

❌

trim

❌

unicode_assigned

❌

upper

✅

Other String Functions

Function
Supported
Notes and limitations

text ^@ text

❌

ascii

✅

chr

✅

concat

❌

concat_ws

❌

format

❌

initcap

✅

left

✅

length

✅

md5

✅

parse_ident

❌

pg_client_encoding

❌

quote_ident

✅

quote_literal

❌

quote_nullable

❌

regexp_count

❌

regexp_instr

❌

regexp_like

❌

regexp_match

❌

regexp_matches

❌

regexp_replace

❌

regexp_split_to_array

❌

regexp_split_to_table

❌

regexp_substr

❌

repeat

✅

replace

✅

reverse

✅

right

✅

split_part

✅

starts_with

❌

string_to_array

❌

string_to_table

❌

strpos

✅

substr

✅

to_ascii

❌

to_bin

❌

to_hex

✅

to_oct

❌

translate

✅

unistr

❌

SQL Binary String Functions

Function
Supported
Notes and limitations

bytea || bytea

❌

bit_length

❌

btrim

❌

ltrim

❌

octet_length

❌

overlay

❌

position

❌

rtrim

❌

substring

❌

trim

❌

Other Binary String Functions

Function
Supported
Notes and limitations

bit_count

❌

get_bit

❌

get_byte

❌

length

❌

md5

❌

set_bit

❌

set_byte

❌

sha224

❌

sha256

❌

sha384

❌

sha512

❌

substr

❌

Text/Binary String Conversion Functions

Function
Supported
Notes and limitations

convert

❌

convert_from

❌

convert_to

❌

encode

❌

decode

❌

Bit String Operators

Function
Supported
Notes and limitations

bit || bit

❌

bit & bit

❌

bit | bit

❌

bit # bit

❌

~ bit

❌

bit << integer

❌

bit >> integer

❌

Bit String Functions

Function
Supported
Notes and limitations

bit_count

❌

bit_length

❌

length

❌

octet_length

❌

overlay

❌

position

❌

substring

❌

get_bit

❌

set_bit

❌

Pattern Matching

Function
Supported
Notes and limitations

[NOT] LIKE pattern [ESCAPE escape-character

❌

[NOT] SIMILAR TO pattern [ESCAPE escape-character

❌

Regular Expression Match Operators

Function
Supported
Notes and limitations

text ~ text

❌

text ~* text

❌

text !~ text

❌

text !~* text

❌

Formatting Functions

Function
Supported
Notes and limitations

to_char

✅

to_date

❌

to_number

❌

to_timestamp

❌

Date/Time Operators

Function
Supported
Notes and limitations

date + integer

❌

date + interval

❌

date + time

❌

interval + interval

❌

timestamp + interval

❌

time + interval

❌

- interval

❌

date - date

❌

date - integer

❌

date - interval

❌

time - time

❌

time - interval

❌

timestamp - interval

❌

interval - interval

❌

timestamp - timestamp

❌

interval * double_precision

❌

interval / double_precision

❌

Date/Time Functions

Function
Supported
Notes and limitations

age

✅

clock_timestamp

❌

current_date

✅

current_time

❌

current_timestamp

✅

date_add

❌

date_bin

❌

date_part

❌

date_subtract

❌

date_trunc

❌

extract

✅

isfinite

❌

justify_days

❌

justify_hours

❌

justify_interval

❌

localtime

🟠

returns timestamp

localtimestamp

🟠

missing support for integer input option

make_date

❌

make_interval

❌

make_time

❌

make_timestamp

❌

make_timestamptz

❌

now

🟠

missing timezone value

statement_timestamp

❌

timeofday

❌

timezone

❌

transaction_timestamp

❌

to_timestamp

❌

Enum Support Functions

Function
Supported
Notes and limitations

enum_first

❌

enum_last

❌

enum_range

❌

Geometric Operators

Function
Supported
Notes and limitations

geometric_type + point

❌

path + path

❌

geometric_type - point

❌

geometric_type * point

❌

geometric_type / point

❌

@-@ geometric_type

❌

@@ geometric_type

❌

geometric_type # geometric_type

❌

box # box

❌

geometric_type ## geometric_type

❌

geometric_type <-> geometric_type

❌

geometric_type @> geometric_type

❌

geometric_type <@ geometric_type

❌

geometric_type && geometric_type

❌

geometric_type << geometric_type

❌

geometric_type >> geometric_type

❌

geometric_type &< geometric_type

❌

geometric_type &> geometric_type

❌

geometric_type >>| geometric_type

❌

geometric_type |>> geometric_type

❌

geometric_type &>| geometric_type

❌

geometric_type |&> geometric_type

❌

box <^ box

❌

box >^ box

❌

geometric_type ?# geometric_type

❌

?- line

❌

?- lseg

❌

point ?- point

❌

?| line

❌

?| lseg

❌

point ?| point

❌

line ?-| line

❌

lseg ?-| lseg

❌

line ?|| line

❌

lseg ?|| lseg

❌

geometric_type ~= geometric_type

❌

Geometric Functions

Function
Supported
Notes and limitations

area

❌

center

❌

diagonal

❌

diameter

❌

height

❌

isclosed

❌

isopen

❌

length

❌

npoints

❌

pclose

❌

popen

❌

radius

❌

slope

❌

width

❌

Geometric Type Conversion Functions

Function
Supported
Notes and limitations

box

❌

bound_box

❌

circle

❌

line

❌

lseg

❌

path

❌

point

❌

polygon

❌

IP Address Operators

Function
Supported
Notes and limitations

inet << inet

❌

inet <<= inet

❌

inet >> inet

❌

inet >>= inet

❌

inet && inet

❌

~ inet

❌

inet & inet

❌

inet | inet

❌

inet + bigint

❌

bigint + inet

❌

inet - bigint

❌

inet - inet

❌

IP Address Functions

Function
Supported
Notes and limitations

abbrev

❌

broadcast

❌

family

❌

host

❌

hostmask

❌

inet_merge

❌

inet_same_family

❌

masklen

❌

netmask

❌

network

❌

set_masklen

❌

text

❌

MAC Address Functions

Function
Supported
Notes and limitations

trunc

❌

macaddr8_set7bit

❌

Text Search Operators

Function
Supported
Notes and limitations

tsvector @@ tsquery

❌

tsquery @@ tsvector

❌

text @@ tsquery

❌

tsvector || tsvector

❌

tsquery && tsquery

❌

tsquery || tsquery

❌

!! tsquery

❌

tsquery <-> tsquery

❌

tsquery @> tsquery

❌

tsquery <@ tsquery

❌

Text Search Functions

Function
Supported
Notes and limitations

array_to_tsvector

❌

get_current_ts_config

❌

length

❌

numnode

❌

plainto_tsquery

❌

phraseto_tsquery

❌

websearch_to_tsquery

❌

querytree

❌

setweight

❌

strip

❌

to_tsquery

❌

to_tsvector

❌

json_to_tsvector

❌

ts_delete

❌

ts_filter

❌

ts_headline

❌

ts_rank

❌

ts_rank_cd

❌

ts_rewrite

❌

tsquery_phrase

❌

tsvector_to_array

❌

unnest

❌

Text Search Debugging Functions

Function
Supported
Notes and limitations

ts_debug

❌

ts_lexize

❌

ts_parse

❌

ts_token_type

❌

ts_stat

❌

UUID Functions

Function
Supported
Notes and limitations

gen_random_uuid

❌

uuid_extract_timestamp

❌

uuid_extract_version

❌

XML Functions

Function
Supported
Notes and limitations

xmltext

❌

xmlcomment

❌

xmlconcat

❌

xmlelement

❌

xmlforest

❌

xmlpi

❌

xmlroot

❌

xmlagg

❌

xmlexists

❌

xml_is_well_formed

❌

xml_is_well_formed_document

❌

xml_is_well_formed_content

❌

xpath

❌

xpath_exists

❌

xmltable

❌

table_to_xml

❌

query_to_xml

❌

cursor_to_xml

❌

table_to_xmlschema

❌

query_to_xmlschema

❌

cursor_to_xmlschema

❌

table_to_xml_and_xmlschema

❌

query_to_xml_and_xmlschema

❌

schema_to_xml

❌

schema_to_xmlschema

❌

schema_to_xml_and_xmlschema

❌

database_to_xml

❌

database_to_xmlschema

❌

database_to_xml_and_xmlschema

❌

json and jsonb Operators

Function
Supported
Notes and limitations

json -> integer

❌

jsonb -> integer

❌

json -> text

❌

jsonb -> text

❌

json ->> integer

❌

jsonb ->> integer

❌

json ->> text

❌

jsonb ->> text

❌

json #> text[]

❌

jsonb #> text[]

❌

json #>> text[]

❌

jsonb #>> text[]

❌

Additional jsonb Operators

Function
Supported
Notes and limitations

jsonb @> jsonb

❌

jsonb <@ jsonb

❌

jsonb ? text

❌

jsonb ?| text[]

❌

jsonb ?& text[]

❌

jsonb || jsonb

❌

jsonb - text

❌

jsonb - text[]

❌

jsonb - integer

❌

jsonb #- text[]

❌

jsonb @? jsonpath

❌

jsonb @@ jsonpath

❌

JSON Creation Functions

Function
Supported
Notes and limitations

to_json

❌

to_jsonb

❌

array_to_json

❌

json_array

❌

row_to_json

❌

json_build_array

❌

jsonb_build_array

❌

json_build_object

❌

jsonb_build_object

❌

json_object

❌

jsonb_object

❌

json

❌

json_scalar

❌

json_serialize

❌

JSON Processing Functions

Function
Supported
Notes and limitations

json_array_elements

❌

jsonb_array_elements

❌

json_array_elements_text

❌

jsonb_array_elements_text

❌

json_array_length

❌

jsonb_array_length

❌

json_each

❌

jsonb_each

❌

json_each_text

❌

jsonb_each_text

❌

json_extract_path

❌

jsonb_extract_path

❌

json_extract_path_text

❌

jsonb_extract_path_text

❌

json_object_keys

❌

jsonb_object_keys

❌

json_populate_record

❌

jsonb_populate_record

❌

json_

❌

jsonb_populate_record_valid

❌

json_populate_recordset

❌

jsonb_populate_recordset

❌

json_to_record

❌

jsonb_to_record

❌

json_to_recordset

❌

jsonb_to_recordset

❌

json_

❌

jsonb_set

❌

jsonb_set_lax

❌

jsonb_insert

❌

json_strip_nulls

❌

jsonb_strip_nulls

❌

jsonb_path_exists

❌

jsonb_path_match

❌

jsonb_path_query

❌

jsonb_path_query_array

❌

jsonb_path_query_first

❌

jsonb_path_exists_tz

❌

jsonb_path_match_tz

❌

jsonb_path_query_tz

❌

jsonb_path_query_array_tz

❌

jsonb_path_query_first_tz

❌

jsonb_pretty

❌

json_typeof

❌

jsonb_typeof

❌

SQL/JSON Query Functions

Function
Supported
Notes and limitations

json_exists

❌

json_query

❌

json_value

❌

json_table

❌

Sequence Functions

Function
Supported
Notes and limitations

nextval

✅

setval

✅

currval

❌

lastval

❌

Conditional Expressions

Function
Supported
Notes and limitations

case

❌

coalesce

❌

nullif

❌

greatest

❌

least

❌

Array Operators

Function
Supported
Notes and limitations

anyarray @> anyarray

❌

anyarray <@ anyarray

❌

anyarray && anyarray

❌

anycompatiblearray || anycompatiblearray

❌

anycompatible || anycompatiblearray

❌

anycompatiblearray || anycompatible

❌

Array Functions

Function
Supported
Notes and limitations

array_append

✅

array_cat

❌

array_dims

❌

array_fill

❌

array_length

❌

array_lower

❌

array_ndims

❌

array_position

❌

array_positions

❌

array_prepend

❌

array_remove

❌

array_replace

❌

array_sample

❌

array_shuffle

❌

array_to_string

✅

array_upper

❌

cardinality

❌

trim_array

❌

unnest

🟠

works with array lengths of 0-1

Range Operators

Function
Supported
Notes and limitations

anyrange @> anyrange

❌

anyrange @> anyelement

❌

anyrange <@ anyrange

❌

anyelement <@ anyrange

❌

anyrange && anyrange

❌

anyrange << anyrange

❌

anyrange >> anyrange

❌

anyrange &< anyrange

❌

anyrange &> anyrange

❌

anyrange -|- anyrange

❌

anyrange + anyrange

❌

anyrange * anyrange

❌

anyrange - anyrange

❌

Multirange Operators

Function
Supported
Notes and limitations

anymultirange @> anymultirange

❌

anymultirange @> anyrange

❌

anymultirange @> anyelement

❌

anyrange @> anymultirange

❌

anymultirange <@ anymultirange

❌

anymultirange <@ anyrange

❌

anyrange <@ anymultirange

❌

anyelement <@ anymultirange

❌

anymultirange && anymultirange

❌

anymultirange && anyrange

❌

anyrange && anymultirange

❌

anymultirange << anymultirange

❌

anymultirange << anyrange

❌

anyrange << anymultirange

❌

anymultirange >> anymultirange

❌

anymultirange >> anyrange

❌

anyrange >> anymultirange

❌

anymultirange &< anymultirange

❌

anymultirange &< anyrange

❌

anyrange &< anymultirange

❌

anymultirange &> anymultirange

❌

anymultirange &> anyrange

❌

anyrange &> anymultirange

❌

anymultirange -|- anyrange

❌

anymultirange + anyrange

❌

anymultirange * anyrange

❌

anymultirange - anyrange

❌

Range Functions

Function
Supported
Notes and limitations

lower

❌

upper

❌

isempty

❌

lower_inc

❌

upper_inc

❌

lower_inf

❌

upper_inf

❌

range_merge

❌

Multirange Functions

Function
Supported
Notes and limitations

lower

❌

upper

❌

isempty

❌

lower_inc

❌

upper_inc

❌

lower_inf

❌

upper_inf

❌

range_merge

❌

multirange

❌

unnest

❌

General-Purpose Aggregate Functions

Function
Supported
Notes and limitations

any_value

❌

array_agg

❌

avg

❌

bit_and

❌

bit_or

❌

bit_xor

❌

bool_and

❌

bool_or

❌

count

✅

only count(*) is supported

every

❌

json_agg

❌

json_agg_strict

❌

json_arrayagg

❌

json_objectagg

❌

json_object_agg

❌

json_object_agg_strict

❌

json_object_agg_unique

❌

json_object_agg_unique_strict

❌

max

❌

min

❌

range_agg

❌

range_intersect_agg

❌

string_agg

❌

sum

❌

xmlagg

❌

Aggregate Functions for Statistics

Function
Supported
Notes and limitations

corr

❌

covar_pop

❌

covar_samp

❌

regr_avgx

❌

regr_avgy

❌

regr_count

❌

regr_intercept

❌

regr_r2

❌

regr_slope

❌

regr_sxx

❌

regr_sxy

❌

regr_syy

❌

stddev

❌

stddev_pop

❌

stddev_samp

❌

variance

❌

var_pop

❌

var_samp

❌

Ordered-Set Aggregate Functions

Function
Supported
Notes and limitations

mode

❌

percentile_cont

❌

percentile_disc

❌

Hypothetical-Set Aggregate Functions

Function
Supported
Notes and limitations

rank

❌

dense_rank

❌

percent_rank

❌

cume_dist

❌

Grouping Operations

Function
Supported
Notes and limitations

grouping

❌

General-Purpose Window Functions

Function
Supported
Notes and limitations

row_number

❌

rank

❌

dense_rank

❌

percent_rank

❌

cume_dist

❌

ntile

❌

lag

❌

lead

❌

first_value

❌

last_value

❌

nth_value

❌

Merge Support Functions

Function
Supported
Notes and limitations

merge_action

❌

Subquery Expressions

Function
Supported
Notes and limitations

exists

❌

in

❌

not in

❌

any/some

✅

all

❌

Series Generating Functions

Function
Supported
Notes and limitations

generate_series

❌

Subscript Generating Functions

Function
Supported
Notes and limitations

generate_subscripts

❌

Session Information Functions

Function
Supported
Notes and limitations

current_catalog

✅

current_database()

✅

current_query

❌

current_role

❌

current_schema

✅

current_schemas

✅

current_user

❌

inet_client_addr

❌

inet_client_port

❌

inet_server_addr

❌

inet_server_port

❌

pg_backend_pid

❌

pg_blocking_pids

❌

pg_conf_load_time

❌

pg_current_logfile

❌

pg_my_temp_schema

❌

pg_is_other_temp_schema

❌

pg_jit_available

❌

pg_listening_channels

❌

pg_notification_queue_usage

❌

pg_postmaster_start_time

🟠

Parses, returns current time

pg_safe_snapshot_blocking_pids

❌

pg_trigger_depth

❌

session_user

❌

system_user

❌

user

❌

Access Privilege Inquiry Functions

Function
Supported
Notes and limitations

has_any_column_privilege

❌

has_column_privilege

❌

has_database_privilege

❌

has_foreign_data_wrapper_privilege

❌

has_function_privilege

❌

has_language_privilege

❌

has_parameter_privilege

❌

has_schema_privilege

❌

has_sequence_privilege

❌

has_server_privilege

❌

has_table_privilege

❌

has_tablespace_privilege

❌

has_type_privilege

❌

pg_has_role

❌

row_security_active

❌

aclitem Operators

Function
Supported
Notes and limitations

aclitem = aclitem

❌

aclitem[] @> aclitem

❌

aclitem[] ~ aclitem

❌

aclitem Functions

Function
Supported
Notes and limitations

acldefault

❌

aclexplode

❌

makeaclitem

❌

Schema Visibility Inquiry Functions

Function
Supported
Notes and limitations

pg_collation_is_visible

❌

pg_conversion_is_visible

❌

pg_function_is_visible

🟠

Parses, not implemented

pg_opclass_is_visible

❌

pg_operator_is_visible

❌

pg_opfamily_is_visible

❌

pg_statistics_obj_is_visible

❌

pg_table_is_visible

✅

pg_ts_config_is_visible

❌

pg_ts_dict_is_visible

❌

pg_ts_parser_is_visible

❌

pg_ts_template_is_visible

❌

pg_type_is_visible

❌

System Catalog Information Functions

Function
Supported
Notes and limitations

format_type

✅

pg_basetype

❌

pg_char_to_encoding

❌

pg_encoding_to_char

🟠

Parses, not implemented

pg_get_catalog_foreign_keys

❌

pg_get_constraintdef

✅

pg_get_expr

🟠

Parses, not implemented

pg_get_functiondef

🟠

Parses, not implemented

pg_get_function_arguments

❌

pg_get_function_identity_arguments

🟠

Parses, not implemented

pg_get_function_result

❌

pg_get_indexdef

🟠

Parses, not implemented

pg_get_keywords

❌

pg_get_partkeydef

🟠

Parses, not implemented

pg_get_ruledef

❌

pg_get_serial_sequence

✅

pg_get_statisticsobjdef

❌

pg_get_triggerdef

🟠

Parses, not implemented

pg_get_userbyid

🟠

Parses, not implemented

pg_get_viewdef

✅

pg_index_column_has_property

❌

pg_index_has_property

❌

pg_indexam_has_property

❌

pg_options_to_table

❌

pg_settings_get_flags

❌

pg_tablespace_databases

❌

pg_tablespace_location

🟠

Parses, not implemented

pg_typeof

❌

COLLATION FOR

❌

to_regclass

✅

to_regcollation

❌

to_regnamespace

❌

to_regoper

❌

to_regoperator

❌

to_regproc

✅

to_regprocedure

❌

to_regrole

❌

to_regtype

✅

to_regtypemod

❌

Object Information and Addressing Functions

Function
Supported
Notes and limitations

pg_describe_object

❌

pg_identify_object

❌

pg_identify_object_as_address

❌

pg_get_object_address

❌

Comment Information Functions

Function
Supported
Notes and limitations

col_description

🟠

Parses, not implemented

obj_description

🟠

Parses, not implemented

shobj_description

🟠

Parses, not implemented

Data Validity Checking Functions

Function
Supported
Notes and limitations

pg_input_is_valid

❌

pg_input_error_info

❌

Transaction ID and Snapshot Information Functions

Function
Supported
Notes and limitations

pg_current_xact_id

❌

pg_current_xact_id_if_assigned

❌

pg_xact_status

❌

pg_current_snapshot

❌

pg_snapshot_xip

❌

pg_snapshot_xmax

❌

pg_snapshot_xmin

❌

pg_visible_in_snapshot

❌

Committed Transaction Information Functions

Function
Supported
Notes and limitations

pg_xact_commit_timestamp

❌

pg_xact_commit_timestamp_origin

❌

pg_last_committed_xact

❌

Control Data Functions

Function
Supported
Notes and limitations

pg_control_checkpoint

❌

pg_control_system

❌

pg_control_init

❌

pg_control_recovery

❌

Version Information Functions

Function
Supported
Notes and limitations

version

🟠

Includes version but not system info

unicode_version

❌

icu_unicode_version

❌

WAL Summarization Information Functions

Function
Supported
Notes and limitations

pg_available_wal_summaries

❌

pg_wal_summary_contents

❌

pg_get_wal_summarizer_state

❌

Configuration Settings Functions

Function
Supported
Notes and limitations

current_setting

✅

set_config

🟠

setting config for the current transaction is not supported yet

Server Signaling Functions

Function
Supported
Notes and limitations

pg_cancel_backend

❌

pg_log_backend_memory_contexts

❌

pg_reload_conf

❌

pg_rotate_logfile

❌

pg_terminate_backend

❌

Backup Control Functions

Function
Supported
Notes and limitations

pg_create_restore_point

❌

pg_current_wal_flush_lsn

❌

pg_current_wal_insert_lsn

❌

pg_current_wal_lsn

❌

pg_backup_start

❌

pg_backup_stop

❌

pg_switch_wal

❌

pg_walfile_name

❌

pg_walfile_name_offset

❌

pg_split_walfile_name

❌

pg_wal_lsn_diff

❌

Recovery Information Functions

Function
Supported
Notes and limitations

pg_is_in_recovery

🟠

Parses, not implemented

pg_last_wal_receive_lsn

❌

pg_last_wal_replay_lsn

❌

pg_last_xact_replay_timestamp

❌

pg_get_wal_resource_managers

❌

Recovery Control Functions

Function
Supported
Notes and limitations

pg_is_wal_replay_paused

❌

pg_get_wal_replay_pause_state

❌

pg_promote

❌

pg_wal_replay_pause

❌

pg_wal_replay_resume

❌

Snapshot Synchronization Functions

Function
Supported
Notes and limitations

pg_export_snapshot

❌

pg_log_standby_snapshot

❌

Replication Management Functions

Function
Supported
Notes and limitations

pg_create_physical_replication_slot

❌

pg_drop_replication_slot

❌

pg_create_logical_replication_slot

❌

pg_copy_physical_replication_slot

❌

pg_copy_logical_replication_slot

❌

pg_logical_slot_get_changes

❌

pg_logical_slot_peek_changes

❌

pg_logical_slot_get_binary_changes

❌

pg_logical_slot_peek_binary_changes

❌

pg_replication_slot_advance

❌

pg_replication_origin_create

❌

pg_replication_origin_drop

❌

pg_replication_origin_oid

❌

pg_replication_origin_session_setup

❌

pg_replication_origin_session_reset

❌

pg_replication_origin_session_is_setup

❌

pg_replication_origin_session_progress

❌

pg_replication_origin_xact_setup

❌

pg_replication_origin_xact_reset

❌

pg_replication_origin_advance

❌

pg_replication_origin_progress

❌

pg_logical_emit_message

❌

pg_sync_replication_slots

❌

Database Object Size Functions

Function
Supported
Notes and limitations

pg_column_size

❌

pg_column_compression

❌

pg_column_toast_chunk_id

❌

pg_database_size

❌

pg_indexes_size

🟠

Parses, not implemented

pg_relation_size

🟠

Parses, not implemented

pg_size_bytes

❌

pg_size_pretty

❌

pg_table_size

🟠

Parses, not implemented

pg_tablespace_size

❌

pg_total_relation_size

🟠

Parses, not implemented

Database Object Location Functions

Function
Supported
Notes and limitations

pg_relation_filenode

❌

pg_relation_filepath

❌

pg_filenode_relation

❌

Collation Management Functions

Function
Supported
Notes and limitations

pg_collation_actual_version

❌

pg_database_collation_actual_version

❌

pg_import_system_collations

❌

Partitioning Information Functions

Function
Supported
Notes and limitations

pg_partition_tree

❌

pg_partition_ancestors

❌

pg_partition_root

❌

Index Maintenance Functions

Function
Supported
Notes and limitations

brin_summarize_new_values

❌

brin_summarize_range

❌

brin_desummarize_range

❌

gin_clean_pending_list

❌

Generic File Access Functions

Function
Supported
Notes and limitations

pg_ls_dir

❌

pg_ls_logdir

❌

pg_ls_waldir

❌

pg_ls_logicalmapdir

❌

pg_ls_logicalsnapdir

❌

pg_ls_replslotdir

❌

pg_ls_archive_statusdir

❌

pg_ls_tmpdir

❌

pg_read_file

❌

pg_read_binary_file

❌

pg_stat_file

❌

Advisory Lock Functions

Function
Supported
Notes and limitations

pg_advisory_lock

❌

pg_advisory_lock_shared

❌

pg_advisory_unlock

❌

pg_advisory_unlock_all

❌

pg_advisory_unlock_shared

❌

pg_advisory_xact_lock

❌

pg_advisory_xact_lock_shared

❌

pg_try_advisory_lock

❌

pg_try_advisory_lock_shared

❌

pg_try_advisory_xact_lock

❌

pg_try_advisory_xact_lock_shared

❌

Built-In Trigger Functions

Function
Supported
Notes and limitations

suppress_redundant_updates_trigger

❌

tsvector_update_trigger

❌

tsvector_update_trigger_column

❌

Event Trigger Functions

Function
Supported
Notes and limitations

pg_event_trigger_ddl_commands

❌

pg_event_trigger_dropped_objects

❌

pg_event_trigger_table_rewrite_oid

❌

pg_event_trigger_table_rewrite_reason

❌

Statistics Information Functions

Function
Supported
Notes and limitations

pg_mcv_list_items

❌

Statistics Access Functions

Function
Supported
Notes and limitations

pg_stat_get_db_numbackends

❌

pg_stat_get_db_xact_commit

❌

pg_stat_get_db_xact_rollback

❌

pg_stat_get_db_blocks_fetched

❌

pg_stat_get_db_blocks_hit

❌

pg_stat_get_db_tuples_returned

❌

pg_stat_get_db_tuples_fetched

❌

pg_stat_get_db_tuples_inserted

❌

pg_stat_get_db_tuples_updated

❌

pg_stat_get_db_tuples_deleted

❌

pg_stat_get_db_conflict_tablespace

❌

pg_stat_get_db_conflict_lock

❌

pg_stat_get_db_conflict_snapshot

❌

pg_stat_get_db_conflict_bufferpin

❌

pg_stat_get_db_conflict_startup_deadlock

❌

pg_stat_get_db_stat_reset_time

❌

pg_stat_get_numscans

🟠

Parses, not implemented

pg_stat_get_tuples_returned

❌

pg_stat_get_tuples_fetched

❌

pg_stat_get_tuples_inserted

❌

pg_stat_get_tuples_updated

❌

pg_stat_get_tuples_deleted

❌

pg_stat_get_tuples_hot_updated

❌

pg_stat_get_live_tuples

❌

pg_stat_get_dead_tuples

❌

pg_stat_get_blocks_fetched

❌

pg_stat_get_blocks_hit

❌

pg_stat_get_last_vacuum_time

❌

pg_stat_get_last_autovacuum_time

❌

pg_stat_get_last_analyze_time

❌

pg_stat_get_last_autoanalyze_time

❌

pg_stat_get_vacuum_count

❌

pg_stat_get_autovacuum_count

❌

pg_stat_get_analyze_count

❌

pg_stat_get_autoanalyze_count

❌

pg_stat_get_xact_numscans

❌

pg_stat_get_xact_tuples_returned

❌

pg_stat_get_xact_tuples_fetched

❌

pg_stat_get_xact_tuples_inserted

❌

pg_stat_get_xact_tuples_updated

❌

pg_stat_get_xact_tuples_deleted

❌

pg_stat_get_xact_tuples_hot_updated

❌

pg_stat_get_xact_blocks_fetched

❌

pg_stat_get_xact_blocks_hit

❌

pg_backend_pid

❌

pg_stat_get_activity

❌

pg_stat_get_function_calls

❌

pg_stat_get_function_time

❌

pg_stat_get_function_self_time

❌

pg_stat_get_xact_function_calls

❌

pg_stat_get_xact_function_time

❌

pg_stat_get_xact_function_self_time

❌

pg_stat_get_backend_idset

❌

pg_stat_get_backend_pid

❌

pg_stat_get_backend_dbid

❌

pg_stat_get_backend_userid

❌

pg_stat_get_backend_activity

❌

pg_stat_get_backend_waiting

❌

pg_stat_get_backend_activity_start

❌

pg_stat_get_backend_xact_start

❌

pg_stat_get_backend_start

❌

pg_stat_get_backend_client_addr

❌

pg_stat_get_backend_client_port

❌

pg_stat_get_bgwriter_timed_checkpoints

❌

pg_stat_get_bgwriter_requested_checkpoints

❌

pg_stat_get_bgwriter_buf_written_checkpoints

❌

pg_stat_get_bgwriter_buf_written_clean

❌

pg_stat_get_bgwriter_maxwritten_clean

❌

pg_stat_get_bgwriter_stat_reset_time

❌

pg_stat_get_buf_written_backend

❌

pg_stat_get_buf_alloc

❌

pg_stat_get_wal_senders

❌

pg_stat_clear_snapshot

❌

pg_stat_reset

❌

pg_stat_reset_shared

❌

pg_stat_reset_single_table_counters

❌

pg_stat_reset_single_function_counters

❌

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

See detailed list in the .

Postgres functions
open a GitHub issue
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs
Postgres docs