# Supported Functions and Operators Doltgres currently supports a subset of [Postgres functions](https://www.postgresql.org/docs/15/functions.html) 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](https://github.com/dolthub/doltgresql/issues) to let us know what you need. ### Logical Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-logical.html). | Function | Supported | Notes and limitations | | -------- | --------- | --------------------- | | AND | ✅ | | | OR | ✅ | | | NOT | ✅ | | ### Comparison Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-comparison.html#FUNCTIONS-COMPARISON-OP-TABLE). | 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](https://www.postgresql.org/docs/current/functions-comparison.html#FUNCTIONS-COMPARISON-PRED-TABLE). | 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](https://www.postgresql.org/docs/current/functions-comparison.html#FUNCTIONS-COMPARISON-FUNC-TABLE). | Function | Supported | Notes and limitations | | ------------- | --------- | --------------------- | | num\_nonnulls | ❌ | | | num\_nulls | ❌ | | ### Mathematical Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-math.html#FUNCTIONS-MATH-OP-TABLE). | 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](https://www.postgresql.org/docs/current/functions-math.html#FUNCTIONS-MATH-FUNC-TABLE). | 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](https://www.postgresql.org/docs/current/functions-math.html#FUNCTIONS-MATH-RANDOM-TABLE). | Function | Supported | Notes and limitations | | -------- | --------- | --------------------- | | random | ✅ | | | setseed | ❌ | | ### Trigonometric Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-math.html#FUNCTIONS-MATH-TRIG-TABLE). | 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](https://www.postgresql.org/docs/current/functions-math.html#FUNCTIONS-MATH-HYP-TABLE). | Function | Supported | Notes and limitations | | -------- | --------- | --------------------- | | sinh | ✅ | | | cosh | ✅ | | | tanh | ✅ | | | asinh | ✅ | | | acosh | ✅ | | | atanh | ✅ | | ### SQL String Functions and Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-string.html#FUNCTIONS-STRING-SQL). | 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](https://www.postgresql.org/docs/current/functions-string.html#FUNCTIONS-STRING-OTHER). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-binarystring.html#FUNCTIONS-BINARYSTRING-SQL). | 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](https://www.postgresql.org/docs/current/functions-binarystring.html#FUNCTIONS-BINARYSTRING-OTHER). | 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](https://www.postgresql.org/docs/current/functions-binarystring.html#FUNCTIONS-BINARYSTRING-CONVERSIONS). | Function | Supported | Notes and limitations | | ------------- | --------- | --------------------- | | convert | ❌ | | | convert\_from | ❌ | | | convert\_to | ❌ | | | encode | ❌ | | | decode | ❌ | | ### Bit String Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-bitstring.html#FUNCTIONS-BIT-STRING-OP-TABLE). | 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](https://postgresql.org/docs/current/functions-bitstring.html#FUNCTIONS-BIT-STRING-TABLE). | 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](https://www.postgresql.org/docs/current/functions-matching.html). | 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](https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-TABLE). | Function | Supported | Notes and limitations | | ----------------------- | --------- | --------------------- | | **text** \~ **text** | ❌ | | | **text** \~\* **text** | ❌ | | | **text** !\~ **text** | ❌ | | | **text** !\~\* **text** | ❌ | | ### Formatting Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-formatting.html#FUNCTIONS-FORMATTING-TABLE). | Function | Supported | Notes and limitations | | ------------- | --------- | --------------------- | | to\_char | ✅ | | | to\_date | ❌ | | | to\_number | ❌ | | | to\_timestamp | ❌ | | ### Date/Time Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-datetime.html#OPERATORS-DATETIME-TABLE). | 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](https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-TABLE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-enum.html#FUNCTIONS-ENUM-TABLE). | Function | Supported | Notes and limitations | | ----------- | --------- | --------------------- | | enum\_first | ❌ | | | enum\_last | ❌ | | | enum\_range | ❌ | | ### Geometric Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-geometry.html#FUNCTIONS-GEOMETRY-OP-TABLE). | 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](https://www.postgresql.org/docs/current/functions-geometry.html#FUNCTIONS-GEOMETRY-FUNC-TABLE). | 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](https://www.postgresql.org/docs/current/functions-geometry.html#FUNCTIONS-GEOMETRY-CONV-TABLE). | Function | Supported | Notes and limitations | | ---------- | --------- | --------------------- | | box | ❌ | | | bound\_box | ❌ | | | circle | ❌ | | | line | ❌ | | | lseg | ❌ | | | path | ❌ | | | point | ❌ | | | polygon | ❌ | | ### IP Address Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-net.html#CIDR-INET-OPERATORS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-net.html#CIDR-INET-FUNCTIONS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-net.html#MACADDR-FUNCTIONS-TABLE). | Function | Supported | Notes and limitations | | ----------------- | --------- | --------------------- | | trunc | ❌ | | | macaddr8\_set7bit | ❌ | | ### Text Search Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-textsearch.html#TEXTSEARCH-OPERATORS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-textsearch.html#TEXTSEARCH-FUNCTIONS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-textsearch.html#TEXTSEARCH-FUNCTIONS-DEBUG-TABLE). | 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](https://www.postgresql.org/docs/current/functions-uuid.html#FUNCTIONS-UUID). | Function | Supported | Notes and limitations | | ------------------------ | --------- | --------------------- | | gen\_random\_uuid | ❌ | | | uuid\_extract\_timestamp | ❌ | | | uuid\_extract\_version | ❌ | | ### XML Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-xml.html#FUNCTIONS-XML). | 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](https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-JSON-OP-TABLE). | 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](https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). | 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](https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-JSON-CREATION-TABLE). | 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](https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-SQLJSON-QUERYING). | Function | Supported | Notes and limitations | | ------------ | --------- | --------------------- | | json\_exists | ❌ | | | json\_query | ❌ | | | json\_value | ❌ | | | json\_table | ❌ | | ### Sequence Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-sequence.html#FUNCTIONS-SEQUENCE-TABLE). | Function | Supported | Notes and limitations | | -------- | --------- | --------------------- | | nextval | ✅ | | | setval | ✅ | | | currval | ❌ | | | lastval | ❌ | | ### Conditional Expressions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-CONDITIONAL). | Function | Supported | Notes and limitations | | -------- | --------- | --------------------- | | case | ❌ | | | coalesce | ❌ | | | nullif | ❌ | | | greatest | ❌ | | | least | ❌ | | ### Array Operators See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-array.html#ARRAY-OPERATORS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-array.html#ARRAY-FUNCTIONS-TABLE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-range.html#RANGE-OPERATORS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-range.html#MULTIRANGE-OPERATORS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-range.html#RANGE-FUNCTIONS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-range.html#MULTIRANGE-FUNCTIONS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-ORDEREDSET-TABLE). | Function | Supported | Notes and limitations | | ---------------- | --------- | --------------------- | | mode | ❌ | | | percentile\_cont | ❌ | | | percentile\_disc | ❌ | | ### Hypothetical-Set Aggregate Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-HYPOTHETICAL-TABLE). | Function | Supported | Notes and limitations | | ------------- | --------- | --------------------- | | rank | ❌ | | | dense\_rank | ❌ | | | percent\_rank | ❌ | | | cume\_dist | ❌ | | ### Grouping Operations See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-GROUPING-TABLE). | Function | Supported | Notes and limitations | | -------- | --------- | --------------------- | | grouping | ❌ | | ### General-Purpose Window Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-window.html#FUNCTIONS-WINDOW-TABLE). | 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](https://www.postgresql.org/docs/current/functions-merge-support.html#FUNCTIONS-MERGE-SUPPORT-TABLE). | Function | Supported | Notes and limitations | | ------------- | --------- | --------------------- | | merge\_action | ❌ | | ### Subquery Expressions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-subquery.html#FUNCTIONS-SUBQUERY). | Function | Supported | Notes and limitations | | -------- | --------- | --------------------- | | exists | ❌ | | | in | ❌ | | | not in | ❌ | | | any/some | ✅ | | | all | ❌ | | ### Series Generating Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-srf.html#FUNCTIONS-SRF-SERIES). | Function | Supported | Notes and limitations | | ---------------- | --------- | --------------------- | | generate\_series | ❌ | | ### Subscript Generating Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-srf.html#FUNCTIONS-SRF-SUBSCRIPTS). | Function | Supported | Notes and limitations | | -------------------- | --------- | --------------------- | | generate\_subscripts | ❌ | | ### Session Information Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-SESSION-TABLE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-ACLITEM-OP-TABLE). | Function | Supported | Notes and limitations | | ----------------------------- | --------- | --------------------- | | **aclitem** = **aclitem** | ❌ | | | **aclitem\[]** @> **aclitem** | ❌ | | | **aclitem\[]** \~ **aclitem** | ❌ | | ### *aclitem* Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-ACLITEM-FN-TABLE). | Function | Supported | Notes and limitations | | ----------- | --------- | --------------------- | | acldefault | ❌ | | | aclexplode | ❌ | | | makeaclitem | ❌ | | ### Schema Visibility Inquiry Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-SCHEMA-TABLE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-OBJECT-TABLE). | 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](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE). | Function | Supported | Notes and limitations | | ------------------ | --------- | ----------------------- | | col\_description | 🟠 | Parses, not implemented | | obj\_description | 🟠 | Parses, not implemented | | shobj\_description | 🟠 | Parses, not implemented | ### Data Validity Checking Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-VALIDITY-TABLE). | 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](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-PG-SNAPSHOT). | 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](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-COMMIT-TIMESTAMP). | 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](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-CONTROLDATA). | 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](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-VERSION). | 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](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-WAL-SUMMARY). | 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](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SET-TABLE). | Function | Supported | Notes and limitations | | ---------------- | --------- | --------------------------------------------------------------- | | current\_setting | ✅ | | | set\_config | 🟠 | setting config for the current transaction is not supported yet | ### Server Signaling Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL-TABLE). | 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](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-BACKUP-TABLE). | 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](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-RECOVERY-INFO-TABLE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-RECOVERY-CONTROL-TABLE). | 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](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-SNAPSHOT-SYNCHRONIZATION-TABLE). | Function | Supported | Notes and limitations | | -------------------------- | --------- | --------------------- | | pg\_export\_snapshot | ❌ | | | pg\_log\_standby\_snapshot | ❌ | | ### Replication Management Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-REPLICATION-TABLE). | 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](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE). | 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 See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-DBLOCATION). | Function | Supported | Notes and limitations | | ---------------------- | --------- | --------------------- | | pg\_relation\_filenode | ❌ | | | pg\_relation\_filepath | ❌ | | | pg\_filenode\_relation | ❌ | | ### Collation Management Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-COLLATION). | 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](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-INFO-PARTITION). | Function | Supported | Notes and limitations | | ------------------------ | --------- | --------------------- | | pg\_partition\_tree | ❌ | | | pg\_partition\_ancestors | ❌ | | | pg\_partition\_root | ❌ | | ### Index Maintenance Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-INDEX-TABLE). | 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](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-GENFILE-TABLE). | 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](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-trigger.html#BUILTIN-TRIGGERS-TABLE). | 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](https://www.postgresql.org/docs/current/functions-event-triggers.html#FUNCTIONS-EVENT-TRIGGERS). | 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](https://www.postgresql.org/docs/current/functions-statistics.html#FUNCTIONS-STATISTICS). | Function | Supported | Notes and limitations | | -------------------- | --------- | --------------------- | | pg\_mcv\_list\_items | ❌ | | ### Statistics Access Functions See detailed list in the [Postgres docs](https://www.postgresql.org/docs/9.1/monitoring-stats.html#MONITORING-STATS-FUNCS-TABLE). | 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 | ❌ | | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.doltgres.com/reference/sql-support/supported-functions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.