Updated on 2025-08-25 GMT+08:00

System Function Information Functions

pv_builtin_functions()

Description: Queries information about system built-in functions.

Return type: record.

Example:

select * from pv_builtin_functions() limit 1;
 proname  | pronamespace | proowner | prolang | procost | prorows | provariadic | protransform | proisagg | proiswindow | prosecdef | proleakproof | proisstrict | proretset | provolatile | pronargs | pronargdefaults | pror
ettype | proargtypes | proallargtypes | proargmodes | proargnames | proargdefaults |  prosrc  | probin | proconfig | prodefaultargpos | fencedmode | proshippable | propackage | oid 
----------+--------------+----------+---------+---------+---------+-------------+--------------+----------+-------------+-----------+--------------+-------------+-----------+-------------+----------+-----------------+-----
-------+-------------+----------------+-------------+-------------+----------------+----------+--------+-----------+------------------+------------+--------------+------------+-----
 byteaout |           11 |       10 |      12 |       1 |       0 |           0 | -            | f        | f           | f         | f            | t           | f         | i           |        1 |               0 |     
  2275 | 17          |                |             |             |                | byteaout |        |           |                  | f          |              | f          |  31
(1 row)