Supported Functions and Operators#

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

Logical Operators#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
AND	✅
OR	✅
NOT	✅

Comparison Operators#

See detailed list in the Postgres docs.

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 Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
num_nonnulls	❌
num_nulls	❌

Mathematical Operators#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
random	✅
setseed	❌

Trigonometric Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
acos	✅
acosd	✅
asin	✅
asind	✅
atan	✅
atand	✅
atan2	✅
atan2d	✅
cos	✅
cosd	✅
cot	✅
cotd	✅
sin	✅
sind	✅
tan	✅
tand	✅

Hyperbolic Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
sinh	✅
cosh	✅
tanh	✅
asinh	✅
acosh	✅
atanh	✅

SQL String Functions and Operators#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
text ^@ text	❌
ascii	✅
chr	✅
concat	✅
concat_ws	✅	Available with MySQL semantics via the underlying engine, which match PostgreSQL for typical usage
format	🟠	Available with MySQL semantics via the underlying engine: MySQL’s FORMAT() does number formatting, not PostgreSQL-style printf string formatting
initcap	✅
left	✅
length	✅
md5	✅
parse_ident	❌
pg_client_encoding	❌
quote_ident	✅
quote_literal	❌
quote_nullable	❌
regexp_count	❌
regexp_instr	✅	Available with MySQL semantics via the underlying engine; some POSIX regex syntax and flags may differ
regexp_like	✅	Available with MySQL semantics via the underlying engine; some POSIX regex syntax and flags may differ
regexp_match	❌
regexp_matches	❌
regexp_replace	🟠	Available with MySQL semantics via the underlying engine: all matches are replaced by default (PostgreSQL replaces only the first), and PostgreSQL flag arguments are not supported
regexp_split_to_array	❌
regexp_split_to_table	❌
regexp_substr	✅	Available with MySQL semantics via the underlying engine; some POSIX regex syntax and flags may differ
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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
bytea \|\| bytea	❌
bit_length	❌
btrim	❌
ltrim	❌
octet_length	❌
overlay	❌
position	❌
rtrim	❌
substring	❌
trim	❌

Other Binary String Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
convert	❌
convert_from	❌
convert_to	❌
encode	❌
decode	❌

Bit String Operators#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
bit \|\| bit	❌
bit & bit	❌
bit \| bit	❌
bit # bit	❌
~ bit	❌
bit << integer	❌
bit >> integer	❌

Bit String Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
bit_count	❌
bit_length	❌
length	❌
octet_length	❌
overlay	❌
position	❌
substring	❌
get_bit	❌
set_bit	❌

Pattern Matching#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
[NOT] LIKE pattern [ESCAPE escape-character	✅
[NOT] SIMILAR TO pattern [ESCAPE escape-character	❌

Regular Expression Match Operators#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
text ~ text	✅
text ~* text	❌
text !~ text	✅
text !~* text	❌

Formatting Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
to_char	✅
to_date	✅
to_number	❌
to_timestamp	✅

Date/Time Operators#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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 a timestamp instead of a time value
localtimestamp	✅	The precision (integer) argument is not supported
make_date	❌
make_interval	❌
make_time	❌
make_timestamp	✅
make_timestamptz	✅
now	✅	The returned value is missing the timezone
statement_timestamp	❌
timeofday	✅
timezone	✅
transaction_timestamp	❌
to_timestamp	✅

Enum Support Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
enum_first	❌
enum_last	❌
enum_range	❌

Geometric Operators#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
area	❌
center	❌
diagonal	❌
diameter	❌
height	❌
isclosed	❌
isopen	❌
length	❌
npoints	❌
pclose	❌
popen	❌
radius	❌
slope	❌
width	❌

Geometric Type Conversion Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
box	❌
bound_box	❌
circle	❌
line	❌
lseg	❌
path	❌
point	❌
polygon	❌

IP Address Operators#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
abbrev	❌
broadcast	❌
family	❌
host	❌
hostmask	❌
inet_merge	❌
inet_same_family	❌
masklen	❌
netmask	❌
network	❌
set_masklen	❌
text	❌

MAC Address Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
trunc	❌
macaddr8_set7bit	❌

Text Search Operators#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
ts_debug	❌
ts_lexize	❌
ts_parse	❌
ts_token_type	❌
ts_stat	❌

UUID Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
gen_random_uuid	✅
uuid_extract_timestamp	❌
uuid_extract_version	❌

XML Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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	❌
jsonb_populate_record_valid	❌
json_populate_recordset	❌
jsonb_populate_recordset	❌
json_to_record	❌
jsonb_to_record	❌
json_to_recordset	❌
jsonb_to_recordset	❌
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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
json_exists	❌
json_query	❌
json_value	❌
json_table	❌

Sequence Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
nextval	✅
setval	✅
currval	❌
lastval	❌

Conditional Expressions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
case	✅
coalesce	✅
nullif	✅
greatest	✅
least	✅

Array Operators#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
anyarray @> anyarray	❌
anyarray <@ anyarray	❌
anyarray && anyarray	❌
anycompatiblearray \|\| anycompatiblearray	✅
anycompatible \|\| anycompatiblearray	✅
anycompatiblearray \|\| anycompatible	✅

Array Functions#

See detailed list in the Postgres docs.

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	✅

Range Operators#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
lower	❌
upper	❌
isempty	❌
lower_inc	❌
upper_inc	❌
lower_inf	❌
upper_inf	❌
range_merge	❌

Multirange Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
lower	❌
upper	❌
isempty	❌
lower_inc	❌
upper_inc	❌
lower_inf	❌
upper_inf	❌
range_merge	❌
multirange	❌
unnest	❌

General-Purpose Aggregate Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
any_value	❌
array_agg	✅	Supports DISTINCT and ORDER BY
avg	✅
bit_and	❌
bit_or	❌
bit_xor	❌
bool_and	✅
bool_or	✅
count	✅
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#

See detailed list in the Postgres docs.

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	🟠	Available with MySQL semantics via the underlying engine, which compute the population standard deviation; PostgreSQL computes the sample standard deviation
stddev_pop	✅
stddev_samp	✅
variance	🟠	Available with MySQL semantics via the underlying engine, which compute the population variance; PostgreSQL computes the sample variance
var_pop	✅
var_samp	❌

Ordered-Set Aggregate Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
mode	❌
percentile_cont	❌
percentile_disc	❌

Hypothetical-Set Aggregate Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
rank	❌
dense_rank	❌
percent_rank	❌
cume_dist	❌

Grouping Operations#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
grouping	❌

General-Purpose Window Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
merge_action	❌

Subquery Expressions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
exists	✅
in	✅
not in	✅
any/some	✅
all	✅

Series Generating Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
generate_series	✅

Subscript Generating Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
generate_subscripts	✅

Session Information Functions#

See detailed list in the Postgres docs.

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	❌	Executes, but returns the current time rather than the server start time
pg_safe_snapshot_blocking_pids	❌
pg_trigger_depth	❌
session_user	❌
system_user	❌
user	❌

Access Privilege Inquiry Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
aclitem = aclitem	❌
aclitem[] @> aclitem	❌
aclitem[] ~ aclitem	❌

aclitem Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
acldefault	❌
aclexplode	❌
makeaclitem	❌

Schema Visibility Inquiry Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_collation_is_visible	✅
pg_conversion_is_visible	✅
pg_function_is_visible	✅
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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
format_type	✅
pg_basetype	❌
pg_char_to_encoding	✅
pg_encoding_to_char	✅	Always returns UTF8, the only encoding Doltgres uses
pg_get_catalog_foreign_keys	❌
pg_get_constraintdef	✅
pg_get_expr	❌	Parses, but is not yet implemented
pg_get_functiondef	✅	Returns stored definitions for user-created functions
pg_get_function_arguments	✅
pg_get_function_identity_arguments	❌	Executes, but always returns an empty string
pg_get_function_result	✅
pg_get_indexdef	✅	Pretty-printing is not supported
pg_get_keywords	❌
pg_get_partkeydef	✅	Always returns an empty result, since partitioned tables are not supported
pg_get_ruledef	✅
pg_get_serial_sequence	✅
pg_get_statisticsobjdef	❌
pg_get_triggerdef	❌	Executes, but always returns an empty string
pg_get_userbyid	❌	Executes, but always returns `postgres` regardless of the role
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	✅	Always returns an empty string, since tablespaces are not supported
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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_describe_object	❌
pg_identify_object	❌
pg_identify_object_as_address	❌
pg_get_object_address	❌

Comment Information Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
col_description	✅	Always returns NULL, since COMMENT is not supported and comments are never stored
obj_description	✅	Always returns NULL, since COMMENT is not supported and comments are never stored
shobj_description	✅	Always returns NULL, since COMMENT is not supported and comments are never stored

Data Validity Checking Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_input_is_valid	❌
pg_input_error_info	❌

Transaction ID and Snapshot Information Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_xact_commit_timestamp	❌
pg_xact_commit_timestamp_origin	❌
pg_last_committed_xact	❌

Control Data Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_control_checkpoint	❌
pg_control_system	❌
pg_control_init	❌
pg_control_recovery	❌

Version Information Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
version	✅	Includes version but not system info
unicode_version	❌
icu_unicode_version	❌

WAL Summarization Information Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_available_wal_summaries	❌
pg_wal_summary_contents	❌
pg_get_wal_summarizer_state	❌

Configuration Settings Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
current_setting	✅
set_config	✅	Setting config for the current transaction only (is_local = true) is not supported yet

Server Signaling Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_is_in_recovery	✅	Always returns false; Doltgres has no recovery mode
pg_last_wal_receive_lsn	❌
pg_last_wal_replay_lsn	❌
pg_last_xact_replay_timestamp	❌
pg_get_wal_resource_managers	❌

Recovery Control Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_export_snapshot	❌
pg_log_standby_snapshot	❌

Replication Management Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_column_size	❌
pg_column_compression	❌
pg_column_toast_chunk_id	❌
pg_database_size	❌
pg_indexes_size	❌	Executes, but always returns 0
pg_relation_size	❌	Executes, but always returns 0
pg_size_bytes	❌
pg_size_pretty	❌
pg_table_size	❌	Executes, but always returns 0
pg_tablespace_size	❌
pg_total_relation_size	❌	Executes, but always returns 0

Database Object Location Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_relation_filenode	❌
pg_relation_filepath	❌
pg_filenode_relation	❌

Collation Management Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_collation_actual_version	❌
pg_database_collation_actual_version	❌
pg_import_system_collations	❌

Partitioning Information Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_partition_tree	❌
pg_partition_ancestors	❌
pg_partition_root	❌

Index Maintenance Functions#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
brin_summarize_new_values	❌
brin_summarize_range	❌
brin_desummarize_range	❌
gin_clean_pending_list	❌

Generic File Access Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
suppress_redundant_updates_trigger	❌
tsvector_update_trigger	❌
tsvector_update_trigger_column	❌

Event Trigger Functions#

See detailed list in the Postgres docs.

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#

See detailed list in the Postgres docs.

Function	Supported	Notes and limitations
pg_mcv_list_items	❌

Statistics Access Functions#

See detailed list in the Postgres docs.

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	❌	Executes, but always returns 0
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	❌