Re: Updated backslash consistency patch

On Thu, 2009-01-15 at 18:25 +0000, Greg Stark wrote:
> How many of the people who find the new behaviour are mainly postgres
> hackers and not users?
>
> I remember finding the behaviour *very* frustrating when I was a user
> and was mainly concerned with maintaining my own functions. I hardly
> ever used \df for system functions.
>
> Now the situation is reversed - I mainly work with test databases with
> simple schemas. But it's common for users to have hundreds of
> functions - and much more likely that they would want to look them up
> by name.

Very well said Greg. To add to this, I find that sometimes an
illustration of the problem is useful. Below is the \df of a sample
postgres database. Notice that the first 1854 entries are pg_catalog
entries.

How in any way is that manageable when what I want to see my functions?

I know I already posted this but it seems the most useful behavior is to
just change the sort. It doesn't change any behavior in terms of
flags/switches so there is nothing new to learn. It just changes the
output.

List of functions
Schema | Name | Result
data type |
Argument data
types
------------+----------------------------------------------+-----------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pg_catalog | RI_FKey_cascade_del | trigger
|
pg_catalog | RI_FKey_cascade_upd | trigger
|
pg_catalog | RI_FKey_check_ins | trigger
|
pg_catalog | RI_FKey_check_upd | trigger
|
pg_catalog | RI_FKey_noaction_del | trigger
|
pg_catalog | RI_FKey_noaction_upd | trigger
|
pg_catalog | RI_FKey_restrict_del | trigger
|
pg_catalog | RI_FKey_restrict_upd | trigger
|
pg_catalog | RI_FKey_setdefault_del | trigger
|
pg_catalog | RI_FKey_setdefault_upd | trigger
|
pg_catalog | RI_FKey_setnull_del | trigger
|
pg_catalog | RI_FKey_setnull_upd | trigger
|
pg_catalog | abbrev | text
| cidr
pg_catalog | abbrev | text
| inet
pg_catalog | abs | bigint
| bigint
pg_catalog | abs | double
precision | double precision
pg_catalog | abs | integer
| integer
pg_catalog | abs | numeric
| numeric
pg_catalog | abs | real
| real
pg_catalog | abs | smallint
| smallint
pg_catalog | abstime | abstime
| timestamp without time zone
pg_catalog | abstime | abstime
| timestamp with time zone
pg_catalog | abstimeeq | boolean
| abstime, abstime
pg_catalog | abstimege | boolean
| abstime, abstime
pg_catalog | abstimegt | boolean
| abstime, abstime
pg_catalog | abstimele | boolean
| abstime, abstime
pg_catalog | abstimelt | boolean
| abstime, abstime
pg_catalog | abstimene | boolean
| abstime, abstime
pg_catalog | abstimerecv | abstime
| internal
pg_catalog | abstimesend | bytea
| abstime
pg_catalog | aclcontains | boolean
| aclitem[], aclitem
pg_catalog | aclinsert | aclitem[]
| aclitem[], aclitem
pg_catalog | aclitemeq | boolean
| aclitem, aclitem
pg_catalog | aclremove | aclitem[]
| aclitem[], aclitem
pg_catalog | acos | double
precision | double precision
pg_catalog | age | integer
| xid
pg_catalog | age | interval
| timestamp without time zone
pg_catalog | age | interval
| timestamp without time zone, timestamp without time zone
pg_catalog | age | interval
| timestamp with time zone
pg_catalog | age | interval
| timestamp with time zone, timestamp with time zone
pg_catalog | anyarray_recv | anyarray
| internal
pg_catalog | anyarray_send | bytea
| anyarray
pg_catalog | anytextcat | text
| anynonarray, text
pg_catalog | area | double
precision | box
pg_catalog | area | double
precision | circle
pg_catalog | area | double
precision | path
pg_catalog | areajoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | areasel | double
precision | internal, oid, internal, integer
pg_catalog | array_append | anyarray
| anyarray, anyelement
pg_catalog | array_cat | anyarray
| anyarray, anyarray
pg_catalog | array_dims | text
| anyarray
pg_catalog | array_eq | boolean
| anyarray, anyarray
pg_catalog | array_ge | boolean
| anyarray, anyarray
pg_catalog | array_gt | boolean
| anyarray, anyarray
pg_catalog | array_larger | anyarray
| anyarray, anyarray
pg_catalog | array_le | boolean
| anyarray, anyarray
pg_catalog | array_lower | integer
| anyarray, integer
pg_catalog | array_lt | boolean
| anyarray, anyarray
pg_catalog | array_ne | boolean
| anyarray, anyarray
pg_catalog | array_prepend | anyarray
| anyelement, anyarray
pg_catalog | array_recv | anyarray
| internal, oid, integer
pg_catalog | array_send | bytea
| anyarray
pg_catalog | array_smaller | anyarray
| anyarray, anyarray
pg_catalog | array_to_string | text
| anyarray, text
pg_catalog | array_upper | integer
| anyarray, integer
pg_catalog | arraycontained | boolean
| anyarray, anyarray
pg_catalog | arraycontains | boolean
| anyarray, anyarray
pg_catalog | arrayoverlap | boolean
| anyarray, anyarray
pg_catalog | ascii | integer
| text
pg_catalog | ascii_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | ascii_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | asin | double
precision | double precision
pg_catalog | atan | double
precision | double precision
pg_catalog | atan2 | double
precision | double precision, double precision
pg_catalog | big5_to_euc_tw | void
| integer, integer, cstring, internal, integer
pg_catalog | big5_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | big5_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | bit | bit
| bigint, integer
pg_catalog | bit | bit
| bit, integer, boolean
pg_catalog | bit | bit
| integer, integer
pg_catalog | bit_length | integer
| bit
pg_catalog | bit_length | integer
| bytea
pg_catalog | bit_length | integer
| text
pg_catalog | bit_recv | bit
| internal, oid, integer
pg_catalog | bit_send | bytea
| bit
pg_catalog | bitand | bit
| bit, bit
pg_catalog | bitcat | bit varying
| bit varying, bit varying
pg_catalog | bitcmp | integer
| bit, bit
pg_catalog | biteq | boolean
| bit, bit
pg_catalog | bitge | boolean
| bit, bit
pg_catalog | bitgt | boolean
| bit, bit
pg_catalog | bitle | boolean
| bit, bit
pg_catalog | bitlt | boolean
| bit, bit
pg_catalog | bitne | boolean
| bit, bit
pg_catalog | bitnot | bit
| bit
pg_catalog | bitor | bit
| bit, bit
pg_catalog | bitshiftleft | bit
| bit, integer
pg_catalog | bitshiftright | bit
| bit, integer
pg_catalog | bittypmodin | integer
| cstring[]
pg_catalog | bitxor | bit
| bit, bit
pg_catalog | bool | boolean
| integer
pg_catalog | booland_statefunc | boolean
| boolean, boolean
pg_catalog | booleq | boolean
| boolean, boolean
pg_catalog | boolge | boolean
| boolean, boolean
pg_catalog | boolgt | boolean
| boolean, boolean
pg_catalog | boolle | boolean
| boolean, boolean
pg_catalog | boollt | boolean
| boolean, boolean
pg_catalog | boolne | boolean
| boolean, boolean
pg_catalog | boolor_statefunc | boolean
| boolean, boolean
pg_catalog | boolrecv | boolean
| internal
pg_catalog | boolsend | bytea
| boolean
pg_catalog | box | box
| circle
pg_catalog | box | box
| point, point
pg_catalog | box | box
| polygon
pg_catalog | box_above | boolean
| box, box
pg_catalog | box_above_eq | boolean
| box, box
pg_catalog | box_add | box
| box, point
pg_catalog | box_below | boolean
| box, box
pg_catalog | box_below_eq | boolean
| box, box
pg_catalog | box_center | point
| box
pg_catalog | box_contain | boolean
| box, box
pg_catalog | box_contained | boolean
| box, box
pg_catalog | box_distance | double
precision | box, box
pg_catalog | box_div | box
| box, point
pg_catalog | box_eq | boolean
| box, box
pg_catalog | box_ge | boolean
| box, box
pg_catalog | box_gt | boolean
| box, box
pg_catalog | box_intersect | box
| box, box
pg_catalog | box_le | boolean
| box, box
pg_catalog | box_left | boolean
| box, box
pg_catalog | box_lt | boolean
| box, box
pg_catalog | box_mul | box
| box, point
pg_catalog | box_overabove | boolean
| box, box
pg_catalog | box_overbelow | boolean
| box, box
pg_catalog | box_overlap | boolean
| box, box
pg_catalog | box_overleft | boolean
| box, box
pg_catalog | box_overright | boolean
| box, box
pg_catalog | box_recv | box
| internal
pg_catalog | box_right | boolean
| box, box
pg_catalog | box_same | boolean
| box, box
pg_catalog | box_send | bytea
| box
pg_catalog | box_sub | box
| box, point
pg_catalog | bpchar | character
| "char"
pg_catalog | bpchar | character
| character, integer, boolean
pg_catalog | bpchar | character
| name
pg_catalog | bpchar_larger | character
| character, character
pg_catalog | bpchar_pattern_eq | boolean
| character, character
pg_catalog | bpchar_pattern_ge | boolean
| character, character
pg_catalog | bpchar_pattern_gt | boolean
| character, character
pg_catalog | bpchar_pattern_le | boolean
| character, character
pg_catalog | bpchar_pattern_lt | boolean
| character, character
pg_catalog | bpchar_pattern_ne | boolean
| character, character
pg_catalog | bpchar_smaller | character
| character, character
pg_catalog | bpcharcmp | integer
| character, character
pg_catalog | bpchareq | boolean
| character, character
pg_catalog | bpcharge | boolean
| character, character
pg_catalog | bpchargt | boolean
| character, character
pg_catalog | bpchariclike | boolean
| character, text
pg_catalog | bpcharicnlike | boolean
| character, text
pg_catalog | bpcharicregexeq | boolean
| character, text
pg_catalog | bpcharicregexne | boolean
| character, text
pg_catalog | bpcharle | boolean
| character, character
pg_catalog | bpcharlike | boolean
| character, text
pg_catalog | bpcharlt | boolean
| character, character
pg_catalog | bpcharne | boolean
| character, character
pg_catalog | bpcharnlike | boolean
| character, text
pg_catalog | bpcharrecv | character
| internal, oid, integer
pg_catalog | bpcharregexeq | boolean
| character, text
pg_catalog | bpcharregexne | boolean
| character, text
pg_catalog | bpcharsend | bytea
| character
pg_catalog | bpchartypmodin | integer
| cstring[]
pg_catalog | broadcast | inet
| inet
pg_catalog | btabstimecmp | integer
| abstime, abstime
pg_catalog | btarraycmp | integer
| anyarray, anyarray
pg_catalog | btbeginscan | internal
| internal, internal, internal
pg_catalog | btboolcmp | integer
| boolean, boolean
pg_catalog | btbpchar_pattern_cmp | integer
| character, character
pg_catalog | btbuild | internal
| internal, internal, internal
pg_catalog | btbulkdelete | internal
| internal, internal, internal, internal
pg_catalog | btcharcmp | integer
| "char", "char"
pg_catalog | btcostestimate | void
| internal, internal, internal, internal, internal, internal, internal,
internal
pg_catalog | btendscan | void
| internal
pg_catalog | btfloat48cmp | integer
| real, double precision
pg_catalog | btfloat4cmp | integer
| real, real
pg_catalog | btfloat84cmp | integer
| double precision, real
pg_catalog | btfloat8cmp | integer
| double precision, double precision
pg_catalog | btgetmulti | boolean
| internal, internal, internal, internal
pg_catalog | btgettuple | boolean
| internal, internal
pg_catalog | btinsert | boolean
| internal, internal, internal, internal, internal, internal
pg_catalog | btint24cmp | integer
| smallint, integer
pg_catalog | btint28cmp | integer
| smallint, bigint
pg_catalog | btint2cmp | integer
| smallint, smallint
pg_catalog | btint42cmp | integer
| integer, smallint
pg_catalog | btint48cmp | integer
| integer, bigint
pg_catalog | btint4cmp | integer
| integer, integer
pg_catalog | btint82cmp | integer
| bigint, smallint
pg_catalog | btint84cmp | integer
| bigint, integer
pg_catalog | btint8cmp | integer
| bigint, bigint
pg_catalog | btmarkpos | void
| internal
pg_catalog | btname_pattern_cmp | integer
| name, name
pg_catalog | btnamecmp | integer
| name, name
pg_catalog | btoidcmp | integer
| oid, oid
pg_catalog | btoidvectorcmp | integer
| oidvector, oidvector
pg_catalog | btoptions | bytea
| text[], boolean
pg_catalog | btreltimecmp | integer
| reltime, reltime
pg_catalog | btrescan | void
| internal, internal
pg_catalog | btrestrpos | void
| internal
pg_catalog | btrim | bytea
| bytea, bytea
pg_catalog | btrim | text
| text
pg_catalog | btrim | text
| text, text
pg_catalog | bttext_pattern_cmp | integer
| text, text
pg_catalog | bttextcmp | integer
| text, text
pg_catalog | bttidcmp | integer
| tid, tid
pg_catalog | bttintervalcmp | integer
| tinterval, tinterval
pg_catalog | btvacuumcleanup | internal
| internal, internal
pg_catalog | byteacat | bytea
| bytea, bytea
pg_catalog | byteacmp | integer
| bytea, bytea
pg_catalog | byteaeq | boolean
| bytea, bytea
pg_catalog | byteage | boolean
| bytea, bytea
pg_catalog | byteagt | boolean
| bytea, bytea
pg_catalog | byteale | boolean
| bytea, bytea
pg_catalog | bytealike | boolean
| bytea, bytea
pg_catalog | bytealt | boolean
| bytea, bytea
pg_catalog | byteane | boolean
| bytea, bytea
pg_catalog | byteanlike | boolean
| bytea, bytea
pg_catalog | bytearecv | bytea
| internal
pg_catalog | byteasend | bytea
| bytea
pg_catalog | cash_cmp | integer
| money, money
pg_catalog | cash_div_flt4 | money
| money, real
pg_catalog | cash_div_flt8 | money
| money, double precision
pg_catalog | cash_div_int2 | money
| money, smallint
pg_catalog | cash_div_int4 | money
| money, integer
pg_catalog | cash_eq | boolean
| money, money
pg_catalog | cash_ge | boolean
| money, money
pg_catalog | cash_gt | boolean
| money, money
pg_catalog | cash_le | boolean
| money, money
pg_catalog | cash_lt | boolean
| money, money
pg_catalog | cash_mi | money
| money, money
pg_catalog | cash_mul_flt4 | money
| money, real
pg_catalog | cash_mul_flt8 | money
| money, double precision
pg_catalog | cash_mul_int2 | money
| money, smallint
pg_catalog | cash_mul_int4 | money
| money, integer
pg_catalog | cash_ne | boolean
| money, money
pg_catalog | cash_pl | money
| money, money
pg_catalog | cash_recv | money
| internal
pg_catalog | cash_send | bytea
| money
pg_catalog | cash_words | text
| money
pg_catalog | cashlarger | money
| money, money
pg_catalog | cashsmaller | money
| money, money
pg_catalog | cbrt | double
precision | double precision
pg_catalog | ceil | double
precision | double precision
pg_catalog | ceil | numeric
| numeric
pg_catalog | ceiling | double
precision | double precision
pg_catalog | ceiling | numeric
| numeric
pg_catalog | center | point
| box
pg_catalog | center | point
| circle
pg_catalog | char | "char"
| integer
pg_catalog | char | "char"
| text
pg_catalog | char_length | integer
| character
pg_catalog | char_length | integer
| text
pg_catalog | character_length | integer
| character
pg_catalog | character_length | integer
| text
pg_catalog | chareq | boolean
| "char", "char"
pg_catalog | charge | boolean
| "char", "char"
pg_catalog | chargt | boolean
| "char", "char"
pg_catalog | charle | boolean
| "char", "char"
pg_catalog | charlt | boolean
| "char", "char"
pg_catalog | charne | boolean
| "char", "char"
pg_catalog | charrecv | "char"
| internal
pg_catalog | charsend | bytea
| "char"
pg_catalog | chr | text
| integer
pg_catalog | cideq | boolean
| cid, cid
pg_catalog | cidr | cidr
| inet
pg_catalog | cidr_recv | cidr
| internal
pg_catalog | cidr_send | bytea
| cidr
pg_catalog | cidrecv | cid
| internal
pg_catalog | cidsend | bytea
| cid
pg_catalog | circle | circle
| box
pg_catalog | circle | circle
| point, double precision
pg_catalog | circle | circle
| polygon
pg_catalog | circle_above | boolean
| circle, circle
pg_catalog | circle_add_pt | circle
| circle, point
pg_catalog | circle_below | boolean
| circle, circle
pg_catalog | circle_center | point
| circle
pg_catalog | circle_contain | boolean
| circle, circle
pg_catalog | circle_contain_pt | boolean
| circle, point
pg_catalog | circle_contained | boolean
| circle, circle
pg_catalog | circle_distance | double
precision | circle, circle
pg_catalog | circle_div_pt | circle
| circle, point
pg_catalog | circle_eq | boolean
| circle, circle
pg_catalog | circle_ge | boolean
| circle, circle
pg_catalog | circle_gt | boolean
| circle, circle
pg_catalog | circle_le | boolean
| circle, circle
pg_catalog | circle_left | boolean
| circle, circle
pg_catalog | circle_lt | boolean
| circle, circle
pg_catalog | circle_mul_pt | circle
| circle, point
pg_catalog | circle_ne | boolean
| circle, circle
pg_catalog | circle_overabove | boolean
| circle, circle
pg_catalog | circle_overbelow | boolean
| circle, circle
pg_catalog | circle_overlap | boolean
| circle, circle
pg_catalog | circle_overleft | boolean
| circle, circle
pg_catalog | circle_overright | boolean
| circle, circle
pg_catalog | circle_recv | circle
| internal
pg_catalog | circle_right | boolean
| circle, circle
pg_catalog | circle_same | boolean
| circle, circle
pg_catalog | circle_send | bytea
| circle
pg_catalog | circle_sub_pt | circle
| circle, point
pg_catalog | clock_timestamp | timestamp
with time zone |
pg_catalog | close_lb | point
| line, box
pg_catalog | close_ls | point
| line, lseg
pg_catalog | close_lseg | point
| lseg, lseg
pg_catalog | close_pb | point
| point, box
pg_catalog | close_pl | point
| point, line
pg_catalog | close_ps | point
| point, lseg
pg_catalog | close_sb | point
| lseg, box
pg_catalog | close_sl | point
| lseg, line
pg_catalog | col_description | text
| oid, integer
pg_catalog | contjoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | contsel | double
precision | internal, oid, internal, integer
pg_catalog | convert | bytea
| bytea, name, name
pg_catalog | convert_from | text
| bytea, name
pg_catalog | convert_to | bytea
| text, name
pg_catalog | cos | double
precision | double precision
pg_catalog | cot | double
precision | double precision
pg_catalog | current_database | name
|
pg_catalog | current_schema | name
|
pg_catalog | current_schemas | name[]
| boolean
pg_catalog | current_setting | text
| text
pg_catalog | current_user | name
|
pg_catalog | currtid | tid
| oid, tid
pg_catalog | currtid2 | tid
| text, tid
pg_catalog | currval | bigint
| regclass
pg_catalog | cursor_to_xml | xml
| cursor refcursor, count integer, nulls boolean, tableforest boolean,
targetns text
pg_catalog | cursor_to_xmlschema | xml
| cursor refcursor, nulls boolean, tableforest boolean, targetns text
pg_catalog | database_to_xml | xml
| nulls boolean, tableforest boolean, targetns text
pg_catalog | database_to_xml_and_xmlschema | xml
| nulls boolean, tableforest boolean, targetns text
pg_catalog | database_to_xmlschema | xml
| nulls boolean, tableforest boolean, targetns text
pg_catalog | date | date
| abstime
pg_catalog | date | date
| timestamp without time zone
pg_catalog | date | date
| timestamp with time zone
pg_catalog | date_cmp | integer
| date, date
pg_catalog | date_cmp_timestamp | integer
| date, timestamp without time zone
pg_catalog | date_cmp_timestamptz | integer
| date, timestamp with time zone
pg_catalog | date_eq | boolean
| date, date
pg_catalog | date_eq_timestamp | boolean
| date, timestamp without time zone
pg_catalog | date_eq_timestamptz | boolean
| date, timestamp with time zone
pg_catalog | date_ge | boolean
| date, date
pg_catalog | date_ge_timestamp | boolean
| date, timestamp without time zone
pg_catalog | date_ge_timestamptz | boolean
| date, timestamp with time zone
pg_catalog | date_gt | boolean
| date, date
pg_catalog | date_gt_timestamp | boolean
| date, timestamp without time zone
pg_catalog | date_gt_timestamptz | boolean
| date, timestamp with time zone
pg_catalog | date_larger | date
| date, date
pg_catalog | date_le | boolean
| date, date
pg_catalog | date_le_timestamp | boolean
| date, timestamp without time zone
pg_catalog | date_le_timestamptz | boolean
| date, timestamp with time zone
pg_catalog | date_lt | boolean
| date, date
pg_catalog | date_lt_timestamp | boolean
| date, timestamp without time zone
pg_catalog | date_lt_timestamptz | boolean
| date, timestamp with time zone
pg_catalog | date_mi | integer
| date, date
pg_catalog | date_mi_interval | timestamp
without time zone | date, interval
pg_catalog | date_mii | date
| date, integer
pg_catalog | date_ne | boolean
| date, date
pg_catalog | date_ne_timestamp | boolean
| date, timestamp without time zone
pg_catalog | date_ne_timestamptz | boolean
| date, timestamp with time zone
pg_catalog | date_part | double
precision | text, abstime
pg_catalog | date_part | double
precision | text, date
pg_catalog | date_part | double
precision | text, interval
pg_catalog | date_part | double
precision | text, reltime
pg_catalog | date_part | double
precision | text, timestamp without time zone
pg_catalog | date_part | double
precision | text, timestamp with time zone
pg_catalog | date_part | double
precision | text, time without time zone
pg_catalog | date_part | double
precision | text, time with time zone
pg_catalog | date_pl_interval | timestamp
without time zone | date, interval
pg_catalog | date_pli | date
| date, integer
pg_catalog | date_recv | date
| internal
pg_catalog | date_send | bytea
| date
pg_catalog | date_smaller | date
| date, date
pg_catalog | date_trunc | interval
| text, interval
pg_catalog | date_trunc | timestamp
without time zone | text, timestamp without time zone
pg_catalog | date_trunc | timestamp
with time zone | text, timestamp with time zone
pg_catalog | datetime_pl | timestamp
without time zone | date, time without time zone
pg_catalog | datetimetz_pl | timestamp
with time zone | date, time with time zone
pg_catalog | dcbrt | double
precision | double precision
pg_catalog | decode | bytea
| text, text
pg_catalog | degrees | double
precision | double precision
pg_catalog | dexp | double
precision | double precision
pg_catalog | diagonal | lseg
| box
pg_catalog | diameter | double
precision | circle
pg_catalog | dispell_init | internal
| internal
pg_catalog | dispell_lexize | internal
| internal, internal, internal, internal
pg_catalog | dist_cpoly | double
precision | circle, polygon
pg_catalog | dist_lb | double
precision | line, box
pg_catalog | dist_pb | double
precision | point, box
pg_catalog | dist_pc | double
precision | point, circle
pg_catalog | dist_pl | double
precision | point, line
pg_catalog | dist_ppath | double
precision | point, path
pg_catalog | dist_ps | double
precision | point, lseg
pg_catalog | dist_sb | double
precision | lseg, box
pg_catalog | dist_sl | double
precision | lseg, line
pg_catalog | dlog1 | double
precision | double precision
pg_catalog | dlog10 | double
precision | double precision
pg_catalog | domain_recv | "any"
| internal, oid, integer
pg_catalog | dpow | double
precision | double precision, double precision
pg_catalog | dround | double
precision | double precision
pg_catalog | dsimple_init | internal
| internal
pg_catalog | dsimple_lexize | internal
| internal, internal, internal, internal
pg_catalog | dsnowball_init | internal
| internal
pg_catalog | dsnowball_lexize | internal
| internal, internal, internal, internal
pg_catalog | dsqrt | double
precision | double precision
pg_catalog | dsynonym_init | internal
| internal
pg_catalog | dsynonym_lexize | internal
| internal, internal, internal, internal
pg_catalog | dtrunc | double
precision | double precision
pg_catalog | encode | text
| bytea, text
pg_catalog | enum_cmp | integer
| anyenum, anyenum
pg_catalog | enum_eq | boolean
| anyenum, anyenum
pg_catalog | enum_first | anyenum
| anyenum
pg_catalog | enum_ge | boolean
| anyenum, anyenum
pg_catalog | enum_gt | boolean
| anyenum, anyenum
pg_catalog | enum_larger | anyenum
| anyenum, anyenum
pg_catalog | enum_last | anyenum
| anyenum
pg_catalog | enum_le | boolean
| anyenum, anyenum
pg_catalog | enum_lt | boolean
| anyenum, anyenum
pg_catalog | enum_ne | boolean
| anyenum, anyenum
pg_catalog | enum_range | anyarray
| anyenum
pg_catalog | enum_range | anyarray
| anyenum, anyenum
pg_catalog | enum_send | bytea
| anyenum
pg_catalog | enum_smaller | anyenum
| anyenum, anyenum
pg_catalog | eqjoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | eqsel | double
precision | internal, oid, internal, integer
pg_catalog | euc_cn_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_cn_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_jis_2004_to_shift_jis_2004 | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_jis_2004_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_jp_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_jp_to_sjis | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_jp_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_kr_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_kr_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_tw_to_big5 | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_tw_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | euc_tw_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | exp | double
precision | double precision
pg_catalog | exp | numeric
| numeric
pg_catalog | factorial | numeric
| bigint
pg_catalog | family | integer
| inet
pg_catalog | flatfile_update_trigger | trigger
|
pg_catalog | float4 | real
| bigint
pg_catalog | float4 | real
| double precision
pg_catalog | float4 | real
| integer
pg_catalog | float4 | real
| numeric
pg_catalog | float4 | real
| smallint
pg_catalog | float48div | double
precision | real, double precision
pg_catalog | float48eq | boolean
| real, double precision
pg_catalog | float48ge | boolean
| real, double precision
pg_catalog | float48gt | boolean
| real, double precision
pg_catalog | float48le | boolean
| real, double precision
pg_catalog | float48lt | boolean
| real, double precision
pg_catalog | float48mi | double
precision | real, double precision
pg_catalog | float48mul | double
precision | real, double precision
pg_catalog | float48ne | boolean
| real, double precision
pg_catalog | float48pl | double
precision | real, double precision
pg_catalog | float4_accum | double
precision[] | double precision[], real
pg_catalog | float4abs | real
| real
pg_catalog | float4div | real
| real, real
pg_catalog | float4eq | boolean
| real, real
pg_catalog | float4ge | boolean
| real, real
pg_catalog | float4gt | boolean
| real, real
pg_catalog | float4larger | real
| real, real
pg_catalog | float4le | boolean
| real, real
pg_catalog | float4lt | boolean
| real, real
pg_catalog | float4mi | real
| real, real
pg_catalog | float4mul | real
| real, real
pg_catalog | float4ne | boolean
| real, real
pg_catalog | float4pl | real
| real, real
pg_catalog | float4recv | real
| internal
pg_catalog | float4send | bytea
| real
pg_catalog | float4smaller | real
| real, real
pg_catalog | float4um | real
| real
pg_catalog | float4up | real
| real
pg_catalog | float8 | double
precision | bigint
pg_catalog | float8 | double
precision | integer
pg_catalog | float8 | double
precision | numeric
pg_catalog | float8 | double
precision | real
pg_catalog | float8 | double
precision | smallint
pg_catalog | float84div | double
precision | double precision, real
pg_catalog | float84eq | boolean
| double precision, real
pg_catalog | float84ge | boolean
| double precision, real
pg_catalog | float84gt | boolean
| double precision, real
pg_catalog | float84le | boolean
| double precision, real
pg_catalog | float84lt | boolean
| double precision, real
pg_catalog | float84mi | double
precision | double precision, real
pg_catalog | float84mul | double
precision | double precision, real
pg_catalog | float84ne | boolean
| double precision, real
pg_catalog | float84pl | double
precision | double precision, real
pg_catalog | float8_accum | double
precision[] | double precision[], double precision
pg_catalog | float8_avg | double
precision | double precision[]
pg_catalog | float8_corr | double
precision | double precision[]
pg_catalog | float8_covar_pop | double
precision | double precision[]
pg_catalog | float8_covar_samp | double
precision | double precision[]
pg_catalog | float8_regr_accum | double
precision[] | double precision[], double precision, double
precision
pg_catalog | float8_regr_avgx | double
precision | double precision[]
pg_catalog | float8_regr_avgy | double
precision | double precision[]
pg_catalog | float8_regr_intercept | double
precision | double precision[]
pg_catalog | float8_regr_r2 | double
precision | double precision[]
pg_catalog | float8_regr_slope | double
precision | double precision[]
pg_catalog | float8_regr_sxx | double
precision | double precision[]
pg_catalog | float8_regr_sxy | double
precision | double precision[]
pg_catalog | float8_regr_syy | double
precision | double precision[]
pg_catalog | float8_stddev_pop | double
precision | double precision[]
pg_catalog | float8_stddev_samp | double
precision | double precision[]
pg_catalog | float8_var_pop | double
precision | double precision[]
pg_catalog | float8_var_samp | double
precision | double precision[]
pg_catalog | float8abs | double
precision | double precision
pg_catalog | float8div | double
precision | double precision, double precision
pg_catalog | float8eq | boolean
| double precision, double precision
pg_catalog | float8ge | boolean
| double precision, double precision
pg_catalog | float8gt | boolean
| double precision, double precision
pg_catalog | float8larger | double
precision | double precision, double precision
pg_catalog | float8le | boolean
| double precision, double precision
pg_catalog | float8lt | boolean
| double precision, double precision
pg_catalog | float8mi | double
precision | double precision, double precision
pg_catalog | float8mul | double
precision | double precision, double precision
pg_catalog | float8ne | boolean
| double precision, double precision
pg_catalog | float8pl | double
precision | double precision, double precision
pg_catalog | float8recv | double
precision | internal
pg_catalog | float8send | bytea
| double precision
pg_catalog | float8smaller | double
precision | double precision, double precision
pg_catalog | float8um | double
precision | double precision
pg_catalog | float8up | double
precision | double precision
pg_catalog | floor | double
precision | double precision
pg_catalog | floor | numeric
| numeric
pg_catalog | flt4_mul_cash | money
| real, money
pg_catalog | flt8_mul_cash | money
| double precision, money
pg_catalog | fmgr_c_validator | void
| oid
pg_catalog | fmgr_internal_validator | void
| oid
pg_catalog | fmgr_sql_validator | void
| oid
pg_catalog | format_type | text
| oid, integer
pg_catalog | gb18030_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | gbk_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | generate_series | setof
bigint | bigint, bigint
pg_catalog | generate_series | setof
bigint | bigint, bigint, bigint
pg_catalog | generate_series | setof
integer | integer, integer
pg_catalog | generate_series | setof
integer | integer, integer, integer
pg_catalog | get_bit | integer
| bytea, integer
pg_catalog | get_byte | integer
| bytea, integer
pg_catalog | get_current_ts_config | regconfig
|
pg_catalog | getdatabaseencoding | name
|
pg_catalog | getpgusername | name
|
pg_catalog | gin_extract_tsquery | internal
| tsquery, internal, smallint
pg_catalog | gin_extract_tsvector | internal
| tsvector, internal
pg_catalog | gin_tsquery_consistent | boolean
| internal, smallint, tsquery
pg_catalog | ginarrayconsistent | boolean
| internal, smallint, internal
pg_catalog | ginarrayextract | internal
| anyarray, internal
pg_catalog | ginbeginscan | internal
| internal, internal, internal
pg_catalog | ginbuild | internal
| internal, internal, internal
pg_catalog | ginbulkdelete | internal
| internal, internal, internal, internal
pg_catalog | gincostestimate | void
| internal, internal, internal, internal, internal, internal, internal,
internal
pg_catalog | ginendscan | void
| internal
pg_catalog | gingetmulti | boolean
| internal, internal, internal, internal
pg_catalog | gingettuple | boolean
| internal, internal
pg_catalog | gininsert | boolean
| internal, internal, internal, internal, internal, internal
pg_catalog | ginmarkpos | void
| internal
pg_catalog | ginoptions | bytea
| text[], boolean
pg_catalog | ginqueryarrayextract | internal
| anyarray, internal, smallint
pg_catalog | ginrescan | void
| internal, internal
pg_catalog | ginrestrpos | void
| internal
pg_catalog | ginvacuumcleanup | internal
| internal, internal
pg_catalog | gist_box_compress | internal
| internal
pg_catalog | gist_box_consistent | boolean
| internal, box, integer
pg_catalog | gist_box_decompress | internal
| internal
pg_catalog | gist_box_penalty | internal
| internal, internal, internal
pg_catalog | gist_box_picksplit | internal
| internal, internal
pg_catalog | gist_box_same | internal
| box, box, internal
pg_catalog | gist_box_union | box
| internal, internal
pg_catalog | gist_circle_compress | internal
| internal
pg_catalog | gist_circle_consistent | boolean
| internal, circle, integer
pg_catalog | gist_poly_compress | internal
| internal
pg_catalog | gist_poly_consistent | boolean
| internal, polygon, integer
pg_catalog | gistbeginscan | internal
| internal, internal, internal
pg_catalog | gistbuild | internal
| internal, internal, internal
pg_catalog | gistbulkdelete | internal
| internal, internal, internal, internal
pg_catalog | gistcostestimate | void
| internal, internal, internal, internal, internal, internal, internal,
internal
pg_catalog | gistendscan | void
| internal
pg_catalog | gistgetmulti | boolean
| internal, internal, internal, internal
pg_catalog | gistgettuple | boolean
| internal, internal
pg_catalog | gistinsert | boolean
| internal, internal, internal, internal, internal, internal
pg_catalog | gistmarkpos | void
| internal
pg_catalog | gistoptions | bytea
| text[], boolean
pg_catalog | gistrescan | void
| internal, internal
pg_catalog | gistrestrpos | void
| internal
pg_catalog | gistvacuumcleanup | internal
| internal, internal
pg_catalog | gtsquery_compress | internal
| internal
pg_catalog | gtsquery_consistent | boolean
| bigint, internal, integer
pg_catalog | gtsquery_decompress | internal
| internal
pg_catalog | gtsquery_penalty | internal
| internal, internal, internal
pg_catalog | gtsquery_picksplit | internal
| internal, internal
pg_catalog | gtsquery_same | internal
| bigint, bigint, internal
pg_catalog | gtsquery_union | internal
| internal, internal
pg_catalog | gtsvector_compress | internal
| internal
pg_catalog | gtsvector_consistent | boolean
| gtsvector, internal, integer
pg_catalog | gtsvector_decompress | internal
| internal
pg_catalog | gtsvector_penalty | internal
| internal, internal, internal
pg_catalog | gtsvector_picksplit | internal
| internal, internal
pg_catalog | gtsvector_same | internal
| gtsvector, gtsvector, internal
pg_catalog | gtsvector_union | internal
| internal, internal
pg_catalog | has_database_privilege | boolean
| name, oid, text
pg_catalog | has_database_privilege | boolean
| name, text, text
pg_catalog | has_database_privilege | boolean
| oid, oid, text
pg_catalog | has_database_privilege | boolean
| oid, text
pg_catalog | has_database_privilege | boolean
| oid, text, text
pg_catalog | has_database_privilege | boolean
| text, text
pg_catalog | has_function_privilege | boolean
| name, oid, text
pg_catalog | has_function_privilege | boolean
| name, text, text
pg_catalog | has_function_privilege | boolean
| oid, oid, text
pg_catalog | has_function_privilege | boolean
| oid, text
pg_catalog | has_function_privilege | boolean
| oid, text, text
pg_catalog | has_function_privilege | boolean
| text, text
pg_catalog | has_language_privilege | boolean
| name, oid, text
pg_catalog | has_language_privilege | boolean
| name, text, text
pg_catalog | has_language_privilege | boolean
| oid, oid, text
pg_catalog | has_language_privilege | boolean
| oid, text
pg_catalog | has_language_privilege | boolean
| oid, text, text
pg_catalog | has_language_privilege | boolean
| text, text
pg_catalog | has_schema_privilege | boolean
| name, oid, text
pg_catalog | has_schema_privilege | boolean
| name, text, text
pg_catalog | has_schema_privilege | boolean
| oid, oid, text
pg_catalog | has_schema_privilege | boolean
| oid, text
pg_catalog | has_schema_privilege | boolean
| oid, text, text
pg_catalog | has_schema_privilege | boolean
| text, text
pg_catalog | has_table_privilege | boolean
| name, oid, text
pg_catalog | has_table_privilege | boolean
| name, text, text
pg_catalog | has_table_privilege | boolean
| oid, oid, text
pg_catalog | has_table_privilege | boolean
| oid, text
pg_catalog | has_table_privilege | boolean
| oid, text, text
pg_catalog | has_table_privilege | boolean
| text, text
pg_catalog | has_tablespace_privilege | boolean
| name, oid, text
pg_catalog | has_tablespace_privilege | boolean
| name, text, text
pg_catalog | has_tablespace_privilege | boolean
| oid, oid, text
pg_catalog | has_tablespace_privilege | boolean
| oid, text
pg_catalog | has_tablespace_privilege | boolean
| oid, text, text
pg_catalog | has_tablespace_privilege | boolean
| text, text
pg_catalog | hash_aclitem | integer
| aclitem
pg_catalog | hash_numeric | integer
| numeric
pg_catalog | hashbeginscan | internal
| internal, internal, internal
pg_catalog | hashbpchar | integer
| character
pg_catalog | hashbuild | internal
| internal, internal, internal
pg_catalog | hashbulkdelete | internal
| internal, internal, internal, internal
pg_catalog | hashchar | integer
| "char"
pg_catalog | hashcostestimate | void
| internal, internal, internal, internal, internal, internal, internal,
internal
pg_catalog | hashendscan | void
| internal
pg_catalog | hashenum | integer
| anyenum
pg_catalog | hashfloat4 | integer
| real
pg_catalog | hashfloat8 | integer
| double precision
pg_catalog | hashgetmulti | boolean
| internal, internal, internal, internal
pg_catalog | hashgettuple | boolean
| internal, internal
pg_catalog | hashinet | integer
| inet
pg_catalog | hashinsert | boolean
| internal, internal, internal, internal, internal, internal
pg_catalog | hashint2 | integer
| smallint
pg_catalog | hashint2vector | integer
| int2vector
pg_catalog | hashint4 | integer
| integer
pg_catalog | hashint8 | integer
| bigint
pg_catalog | hashmacaddr | integer
| macaddr
pg_catalog | hashmarkpos | void
| internal
pg_catalog | hashname | integer
| name
pg_catalog | hashoid | integer
| oid
pg_catalog | hashoidvector | integer
| oidvector
pg_catalog | hashoptions | bytea
| text[], boolean
pg_catalog | hashrescan | void
| internal, internal
pg_catalog | hashrestrpos | void
| internal
pg_catalog | hashtext | integer
| text
pg_catalog | hashvacuumcleanup | internal
| internal, internal
pg_catalog | hashvarlena | integer
| internal
pg_catalog | height | double
precision | box
pg_catalog | host | text
| inet
pg_catalog | hostmask | inet
| inet
pg_catalog | iclikejoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | iclikesel | double
precision | internal, oid, internal, integer
pg_catalog | icnlikejoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | icnlikesel | double
precision | internal, oid, internal, integer
pg_catalog | icregexeqjoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | icregexeqsel | double
precision | internal, oid, internal, integer
pg_catalog | icregexnejoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | icregexnesel | double
precision | internal, oid, internal, integer
pg_catalog | inet_client_addr | inet
|
pg_catalog | inet_client_port | integer
|
pg_catalog | inet_recv | inet
| internal
pg_catalog | inet_send | bytea
| inet
pg_catalog | inet_server_addr | inet
|
pg_catalog | inet_server_port | integer
|
pg_catalog | inetand | inet
| inet, inet
pg_catalog | inetmi | bigint
| inet, inet
pg_catalog | inetmi_int8 | inet
| inet, bigint
pg_catalog | inetnot | inet
| inet
pg_catalog | inetor | inet
| inet, inet
pg_catalog | inetpl | inet
| inet, bigint
pg_catalog | initcap | text
| text
pg_catalog | int2 | smallint
| bigint
pg_catalog | int2 | smallint
| double precision
pg_catalog | int2 | smallint
| integer
pg_catalog | int2 | smallint
| numeric
pg_catalog | int2 | smallint
| real
pg_catalog | int24div | integer
| smallint, integer
pg_catalog | int24eq | boolean
| smallint, integer
pg_catalog | int24ge | boolean
| smallint, integer
pg_catalog | int24gt | boolean
| smallint, integer
pg_catalog | int24le | boolean
| smallint, integer
pg_catalog | int24lt | boolean
| smallint, integer
pg_catalog | int24mi | integer
| smallint, integer
pg_catalog | int24mod | integer
| smallint, integer
pg_catalog | int24mul | integer
| smallint, integer
pg_catalog | int24ne | boolean
| smallint, integer
pg_catalog | int24pl | integer
| smallint, integer
pg_catalog | int28eq | boolean
| smallint, bigint
pg_catalog | int28ge | boolean
| smallint, bigint
pg_catalog | int28gt | boolean
| smallint, bigint
pg_catalog | int28le | boolean
| smallint, bigint
pg_catalog | int28lt | boolean
| smallint, bigint
pg_catalog | int28ne | boolean
| smallint, bigint
pg_catalog | int2_accum | numeric[]
| numeric[], smallint
pg_catalog | int2_avg_accum | bigint[]
| bigint[], smallint
pg_catalog | int2_mul_cash | money
| smallint, money
pg_catalog | int2_sum | bigint
| bigint, smallint
pg_catalog | int2abs | smallint
| smallint
pg_catalog | int2and | smallint
| smallint, smallint
pg_catalog | int2div | smallint
| smallint, smallint
pg_catalog | int2eq | boolean
| smallint, smallint
pg_catalog | int2ge | boolean
| smallint, smallint
pg_catalog | int2gt | boolean
| smallint, smallint
pg_catalog | int2larger | smallint
| smallint, smallint
pg_catalog | int2le | boolean
| smallint, smallint
pg_catalog | int2lt | boolean
| smallint, smallint
pg_catalog | int2mi | smallint
| smallint, smallint
pg_catalog | int2mod | smallint
| smallint, smallint
pg_catalog | int2mul | smallint
| smallint, smallint
pg_catalog | int2ne | boolean
| smallint, smallint
pg_catalog | int2not | smallint
| smallint
pg_catalog | int2or | smallint
| smallint, smallint
pg_catalog | int2pl | smallint
| smallint, smallint
pg_catalog | int2recv | smallint
| internal
pg_catalog | int2send | bytea
| smallint
pg_catalog | int2shl | smallint
| smallint, integer
pg_catalog | int2shr | smallint
| smallint, integer
pg_catalog | int2smaller | smallint
| smallint, smallint
pg_catalog | int2um | smallint
| smallint
pg_catalog | int2up | smallint
| smallint
pg_catalog | int2vectoreq | boolean
| int2vector, int2vector
pg_catalog | int2vectorrecv | int2vector
| internal
pg_catalog | int2vectorsend | bytea
| int2vector
pg_catalog | int2xor | smallint
| smallint, smallint
pg_catalog | int4 | integer
| bigint
pg_catalog | int4 | integer
| bit
pg_catalog | int4 | integer
| boolean
pg_catalog | int4 | integer
| "char"
pg_catalog | int4 | integer
| double precision
pg_catalog | int4 | integer
| numeric
pg_catalog | int4 | integer
| real
pg_catalog | int4 | integer
| smallint
pg_catalog | int42div | integer
| integer, smallint
pg_catalog | int42eq | boolean
| integer, smallint
pg_catalog | int42ge | boolean
| integer, smallint
pg_catalog | int42gt | boolean
| integer, smallint
pg_catalog | int42le | boolean
| integer, smallint
pg_catalog | int42lt | boolean
| integer, smallint
pg_catalog | int42mi | integer
| integer, smallint
pg_catalog | int42mod | integer
| integer, smallint
pg_catalog | int42mul | integer
| integer, smallint
pg_catalog | int42ne | boolean
| integer, smallint
pg_catalog | int42pl | integer
| integer, smallint
pg_catalog | int48div | bigint
| integer, bigint
pg_catalog | int48eq | boolean
| integer, bigint
pg_catalog | int48ge | boolean
| integer, bigint
pg_catalog | int48gt | boolean
| integer, bigint
pg_catalog | int48le | boolean
| integer, bigint
pg_catalog | int48lt | boolean
| integer, bigint
pg_catalog | int48mi | bigint
| integer, bigint
pg_catalog | int48mul | bigint
| integer, bigint
pg_catalog | int48ne | boolean
| integer, bigint
pg_catalog | int48pl | bigint
| integer, bigint
pg_catalog | int4_accum | numeric[]
| numeric[], integer
pg_catalog | int4_avg_accum | bigint[]
| bigint[], integer
pg_catalog | int4_mul_cash | money
| integer, money
pg_catalog | int4_sum | bigint
| bigint, integer
pg_catalog | int4abs | integer
| integer
pg_catalog | int4and | integer
| integer, integer
pg_catalog | int4div | integer
| integer, integer
pg_catalog | int4eq | boolean
| integer, integer
pg_catalog | int4ge | boolean
| integer, integer
pg_catalog | int4gt | boolean
| integer, integer
pg_catalog | int4inc | integer
| integer
pg_catalog | int4larger | integer
| integer, integer
pg_catalog | int4le | boolean
| integer, integer
pg_catalog | int4lt | boolean
| integer, integer
pg_catalog | int4mi | integer
| integer, integer
pg_catalog | int4mod | integer
| integer, integer
pg_catalog | int4mul | integer
| integer, integer
pg_catalog | int4ne | boolean
| integer, integer
pg_catalog | int4not | integer
| integer
pg_catalog | int4or | integer
| integer, integer
pg_catalog | int4pl | integer
| integer, integer
pg_catalog | int4recv | integer
| internal
pg_catalog | int4send | bytea
| integer
pg_catalog | int4shl | integer
| integer, integer
pg_catalog | int4shr | integer
| integer, integer
pg_catalog | int4smaller | integer
| integer, integer
pg_catalog | int4um | integer
| integer
pg_catalog | int4up | integer
| integer
pg_catalog | int4xor | integer
| integer, integer
pg_catalog | int8 | bigint
| bit
pg_catalog | int8 | bigint
| double precision
pg_catalog | int8 | bigint
| integer
pg_catalog | int8 | bigint
| numeric
pg_catalog | int8 | bigint
| oid
pg_catalog | int8 | bigint
| real
pg_catalog | int8 | bigint
| smallint
pg_catalog | int82eq | boolean
| bigint, smallint
pg_catalog | int82ge | boolean
| bigint, smallint
pg_catalog | int82gt | boolean
| bigint, smallint
pg_catalog | int82le | boolean
| bigint, smallint
pg_catalog | int82lt | boolean
| bigint, smallint
pg_catalog | int82ne | boolean
| bigint, smallint
pg_catalog | int84div | bigint
| bigint, integer
pg_catalog | int84eq | boolean
| bigint, integer
pg_catalog | int84ge | boolean
| bigint, integer
pg_catalog | int84gt | boolean
| bigint, integer
pg_catalog | int84le | boolean
| bigint, integer
pg_catalog | int84lt | boolean
| bigint, integer
pg_catalog | int84mi | bigint
| bigint, integer
pg_catalog | int84mul | bigint
| bigint, integer
pg_catalog | int84ne | boolean
| bigint, integer
pg_catalog | int84pl | bigint
| bigint, integer
pg_catalog | int8_accum | numeric[]
| numeric[], bigint
pg_catalog | int8_avg | numeric
| bigint[]
pg_catalog | int8_avg_accum | numeric[]
| numeric[], bigint
pg_catalog | int8_sum | numeric
| numeric, bigint
pg_catalog | int8abs | bigint
| bigint
pg_catalog | int8and | bigint
| bigint, bigint
pg_catalog | int8div | bigint
| bigint, bigint
pg_catalog | int8eq | boolean
| bigint, bigint
pg_catalog | int8ge | boolean
| bigint, bigint
pg_catalog | int8gt | boolean
| bigint, bigint
pg_catalog | int8inc | bigint
| bigint
pg_catalog | int8inc_any | bigint
| bigint, "any"
pg_catalog | int8inc_float8_float8 | bigint
| bigint, double precision, double precision
pg_catalog | int8larger | bigint
| bigint, bigint
pg_catalog | int8le | boolean
| bigint, bigint
pg_catalog | int8lt | boolean
| bigint, bigint
pg_catalog | int8mi | bigint
| bigint, bigint
pg_catalog | int8mod | bigint
| bigint, bigint
pg_catalog | int8mul | bigint
| bigint, bigint
pg_catalog | int8ne | boolean
| bigint, bigint
pg_catalog | int8not | bigint
| bigint
pg_catalog | int8or | bigint
| bigint, bigint
pg_catalog | int8pl | bigint
| bigint, bigint
pg_catalog | int8pl_inet | inet
| bigint, inet
pg_catalog | int8recv | bigint
| internal
pg_catalog | int8send | bytea
| bigint
pg_catalog | int8shl | bigint
| bigint, integer
pg_catalog | int8shr | bigint
| bigint, integer
pg_catalog | int8smaller | bigint
| bigint, bigint
pg_catalog | int8um | bigint
| bigint
pg_catalog | int8up | bigint
| bigint
pg_catalog | int8xor | bigint
| bigint, bigint
pg_catalog | integer_pl_date | date
| integer, date
pg_catalog | inter_lb | boolean
| line, box
pg_catalog | inter_sb | boolean
| lseg, box
pg_catalog | inter_sl | boolean
| lseg, line
pg_catalog | interval | interval
| interval, integer
pg_catalog | interval | interval
| reltime
pg_catalog | interval | interval
| time without time zone
pg_catalog | interval_accum | interval[]
| interval[], interval
pg_catalog | interval_avg | interval
| interval[]
pg_catalog | interval_cmp | integer
| interval, interval
pg_catalog | interval_div | interval
| interval, double precision
pg_catalog | interval_eq | boolean
| interval, interval
pg_catalog | interval_ge | boolean
| interval, interval
pg_catalog | interval_gt | boolean
| interval, interval
pg_catalog | interval_hash | integer
| interval
pg_catalog | interval_larger | interval
| interval, interval
pg_catalog | interval_le | boolean
| interval, interval
pg_catalog | interval_lt | boolean
| interval, interval
pg_catalog | interval_mi | interval
| interval, interval
pg_catalog | interval_mul | interval
| interval, double precision
pg_catalog | interval_ne | boolean
| interval, interval
pg_catalog | interval_pl | interval
| interval, interval
pg_catalog | interval_pl_date | timestamp
without time zone | interval, date
pg_catalog | interval_pl_time | time
without time zone | interval, time without time zone
pg_catalog | interval_pl_timestamp | timestamp
without time zone | interval, timestamp without time zone
pg_catalog | interval_pl_timestamptz | timestamp
with time zone | interval, timestamp with time zone
pg_catalog | interval_pl_timetz | time with
time zone | interval, time with time zone
pg_catalog | interval_recv | interval
| internal, oid, integer
pg_catalog | interval_send | bytea
| interval
pg_catalog | interval_smaller | interval
| interval, interval
pg_catalog | interval_um | interval
| interval
pg_catalog | intervaltypmodin | integer
| cstring[]
pg_catalog | intinterval | boolean
| abstime, tinterval
pg_catalog | isclosed | boolean
| path
pg_catalog | isfalse | boolean
| boolean
pg_catalog | isfinite | boolean
| abstime
pg_catalog | isfinite | boolean
| interval
pg_catalog | isfinite | boolean
| timestamp without time zone
pg_catalog | isfinite | boolean
| timestamp with time zone
pg_catalog | ishorizontal | boolean
| line
pg_catalog | ishorizontal | boolean
| lseg
pg_catalog | ishorizontal | boolean
| point, point
pg_catalog | isnotfalse | boolean
| boolean
pg_catalog | isnottrue | boolean
| boolean
pg_catalog | iso8859_1_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | iso8859_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | iso_to_koi8r | void
| integer, integer, cstring, internal, integer
pg_catalog | iso_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | iso_to_win1251 | void
| integer, integer, cstring, internal, integer
pg_catalog | iso_to_win866 | void
| integer, integer, cstring, internal, integer
pg_catalog | isopen | boolean
| path
pg_catalog | isparallel | boolean
| line, line
pg_catalog | isparallel | boolean
| lseg, lseg
pg_catalog | isperp | boolean
| line, line
pg_catalog | isperp | boolean
| lseg, lseg
pg_catalog | istrue | boolean
| boolean
pg_catalog | isvertical | boolean
| line
pg_catalog | isvertical | boolean
| lseg
pg_catalog | isvertical | boolean
| point, point
pg_catalog | johab_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | justify_days | interval
| interval
pg_catalog | justify_hours | interval
| interval
pg_catalog | justify_interval | interval
| interval
pg_catalog | koi8r_to_iso | void
| integer, integer, cstring, internal, integer
pg_catalog | koi8r_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | koi8r_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | koi8r_to_win1251 | void
| integer, integer, cstring, internal, integer
pg_catalog | koi8r_to_win866 | void
| integer, integer, cstring, internal, integer
pg_catalog | lastval | bigint
|
pg_catalog | latin1_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | latin2_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | latin2_to_win1250 | void
| integer, integer, cstring, internal, integer
pg_catalog | latin3_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | latin4_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | length | double
precision | lseg
pg_catalog | length | double
precision | path
pg_catalog | length | integer
| bit
pg_catalog | length | integer
| bytea
pg_catalog | length | integer
| bytea, name
pg_catalog | length | integer
| character
pg_catalog | length | integer
| text
pg_catalog | length | integer
| tsvector
pg_catalog | like | boolean
| bytea, bytea
pg_catalog | like | boolean
| name, text
pg_catalog | like | boolean
| text, text
pg_catalog | like_escape | bytea
| bytea, bytea
pg_catalog | like_escape | text
| text, text
pg_catalog | likejoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | likesel | double
precision | internal, oid, internal, integer
pg_catalog | line | line
| point, point
pg_catalog | line_distance | double
precision | line, line
pg_catalog | line_eq | boolean
| line, line
pg_catalog | line_horizontal | boolean
| line
pg_catalog | line_interpt | point
| line, line
pg_catalog | line_intersect | boolean
| line, line
pg_catalog | line_parallel | boolean
| line, line
pg_catalog | line_perp | boolean
| line, line
pg_catalog | line_recv | line
| internal
pg_catalog | line_send | bytea
| line
pg_catalog | line_vertical | boolean
| line
pg_catalog | ln | double
precision | double precision
pg_catalog | ln | numeric
| numeric
pg_catalog | lo_close | integer
| integer
pg_catalog | lo_creat | oid
| integer
pg_catalog | lo_create | oid
| oid
pg_catalog | lo_export | integer
| oid, text
pg_catalog | lo_import | oid
| text
pg_catalog | lo_lseek | integer
| integer, integer, integer
pg_catalog | lo_open | integer
| oid, integer
pg_catalog | lo_tell | integer
| integer
pg_catalog | lo_truncate | integer
| integer, integer
pg_catalog | lo_unlink | integer
| oid
pg_catalog | log | double
precision | double precision
pg_catalog | log | numeric
| numeric
pg_catalog | log | numeric
| numeric, numeric
pg_catalog | loread | bytea
| integer, integer
pg_catalog | lower | text
| text
pg_catalog | lowrite | integer
| integer, bytea
pg_catalog | lpad | text
| text, integer
pg_catalog | lpad | text
| text, integer, text
pg_catalog | lseg | lseg
| box
pg_catalog | lseg | lseg
| point, point
pg_catalog | lseg_center | point
| lseg
pg_catalog | lseg_distance | double
precision | lseg, lseg
pg_catalog | lseg_eq | boolean
| lseg, lseg
pg_catalog | lseg_ge | boolean
| lseg, lseg
pg_catalog | lseg_gt | boolean
| lseg, lseg
pg_catalog | lseg_horizontal | boolean
| lseg
pg_catalog | lseg_interpt | point
| lseg, lseg
pg_catalog | lseg_intersect | boolean
| lseg, lseg
pg_catalog | lseg_le | boolean
| lseg, lseg
pg_catalog | lseg_length | double
precision | lseg
pg_catalog | lseg_lt | boolean
| lseg, lseg
pg_catalog | lseg_ne | boolean
| lseg, lseg
pg_catalog | lseg_parallel | boolean
| lseg, lseg
pg_catalog | lseg_perp | boolean
| lseg, lseg
pg_catalog | lseg_recv | lseg
| internal
pg_catalog | lseg_send | bytea
| lseg
pg_catalog | lseg_vertical | boolean
| lseg
pg_catalog | ltrim | text
| text
pg_catalog | ltrim | text
| text, text
pg_catalog | macaddr_cmp | integer
| macaddr, macaddr
pg_catalog | macaddr_eq | boolean
| macaddr, macaddr
pg_catalog | macaddr_ge | boolean
| macaddr, macaddr
pg_catalog | macaddr_gt | boolean
| macaddr, macaddr
pg_catalog | macaddr_le | boolean
| macaddr, macaddr
pg_catalog | macaddr_lt | boolean
| macaddr, macaddr
pg_catalog | macaddr_ne | boolean
| macaddr, macaddr
pg_catalog | macaddr_recv | macaddr
| internal
pg_catalog | macaddr_send | bytea
| macaddr
pg_catalog | makeaclitem | aclitem
| oid, oid, text, boolean
pg_catalog | masklen | integer
| inet
pg_catalog | md5 | text
| bytea
pg_catalog | md5 | text
| text
pg_catalog | mic_to_ascii | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_big5 | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_euc_cn | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_euc_jp | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_euc_kr | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_euc_tw | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_iso | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_koi8r | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_latin1 | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_latin2 | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_latin3 | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_latin4 | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_sjis | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_win1250 | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_win1251 | void
| integer, integer, cstring, internal, integer
pg_catalog | mic_to_win866 | void
| integer, integer, cstring, internal, integer
pg_catalog | mktinterval | tinterval
| abstime, abstime
pg_catalog | mod | bigint
| bigint, bigint
pg_catalog | mod | integer
| integer, integer
pg_catalog | mod | integer
| integer, smallint
pg_catalog | mod | integer
| smallint, integer
pg_catalog | mod | numeric
| numeric, numeric
pg_catalog | mod | smallint
| smallint, smallint
pg_catalog | mul_d_interval | interval
| double precision, interval
pg_catalog | name | name
| character
pg_catalog | name | name
| character varying
pg_catalog | name | name
| text
pg_catalog | name_pattern_eq | boolean
| name, name
pg_catalog | name_pattern_ge | boolean
| name, name
pg_catalog | name_pattern_gt | boolean
| name, name
pg_catalog | name_pattern_le | boolean
| name, name
pg_catalog | name_pattern_lt | boolean
| name, name
pg_catalog | name_pattern_ne | boolean
| name, name
pg_catalog | nameeq | boolean
| name, name
pg_catalog | namege | boolean
| name, name
pg_catalog | namegt | boolean
| name, name
pg_catalog | nameiclike | boolean
| name, text
pg_catalog | nameicnlike | boolean
| name, text
pg_catalog | nameicregexeq | boolean
| name, text
pg_catalog | nameicregexne | boolean
| name, text
pg_catalog | namele | boolean
| name, name
pg_catalog | namelike | boolean
| name, text
pg_catalog | namelt | boolean
| name, name
pg_catalog | namene | boolean
| name, name
pg_catalog | namenlike | boolean
| name, text
pg_catalog | namerecv | name
| internal
pg_catalog | nameregexeq | boolean
| name, text
pg_catalog | nameregexne | boolean
| name, text
pg_catalog | namesend | bytea
| name
pg_catalog | neqjoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | neqsel | double
precision | internal, oid, internal, integer
pg_catalog | netmask | inet
| inet
pg_catalog | network | cidr
| inet
pg_catalog | network_cmp | integer
| inet, inet
pg_catalog | network_eq | boolean
| inet, inet
pg_catalog | network_ge | boolean
| inet, inet
pg_catalog | network_gt | boolean
| inet, inet
pg_catalog | network_le | boolean
| inet, inet
pg_catalog | network_lt | boolean
| inet, inet
pg_catalog | network_ne | boolean
| inet, inet
pg_catalog | network_sub | boolean
| inet, inet
pg_catalog | network_subeq | boolean
| inet, inet
pg_catalog | network_sup | boolean
| inet, inet
pg_catalog | network_supeq | boolean
| inet, inet
pg_catalog | nextval | bigint
| regclass
pg_catalog | nlikejoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | nlikesel | double
precision | internal, oid, internal, integer
pg_catalog | nonnullvalue | boolean
| "any"
pg_catalog | notlike | boolean
| bytea, bytea
pg_catalog | notlike | boolean
| name, text
pg_catalog | notlike | boolean
| text, text
pg_catalog | now | timestamp
with time zone |
pg_catalog | npoints | integer
| path
pg_catalog | npoints | integer
| polygon
pg_catalog | nullvalue | boolean
| "any"
pg_catalog | numeric | numeric
| bigint
pg_catalog | numeric | numeric
| double precision
pg_catalog | numeric | numeric
| integer
pg_catalog | numeric | numeric
| numeric, integer
pg_catalog | numeric | numeric
| real
pg_catalog | numeric | numeric
| smallint
pg_catalog | numeric_abs | numeric
| numeric
pg_catalog | numeric_accum | numeric[]
| numeric[], numeric
pg_catalog | numeric_add | numeric
| numeric, numeric
pg_catalog | numeric_avg | numeric
| numeric[]
pg_catalog | numeric_avg_accum | numeric[]
| numeric[], numeric
pg_catalog | numeric_cmp | integer
| numeric, numeric
pg_catalog | numeric_div | numeric
| numeric, numeric
pg_catalog | numeric_eq | boolean
| numeric, numeric
pg_catalog | numeric_exp | numeric
| numeric
pg_catalog | numeric_fac | numeric
| bigint
pg_catalog | numeric_ge | boolean
| numeric, numeric
pg_catalog | numeric_gt | boolean
| numeric, numeric
pg_catalog | numeric_inc | numeric
| numeric
pg_catalog | numeric_larger | numeric
| numeric, numeric
pg_catalog | numeric_le | boolean
| numeric, numeric
pg_catalog | numeric_ln | numeric
| numeric
pg_catalog | numeric_log | numeric
| numeric, numeric
pg_catalog | numeric_lt | boolean
| numeric, numeric
pg_catalog | numeric_mod | numeric
| numeric, numeric
pg_catalog | numeric_mul | numeric
| numeric, numeric
pg_catalog | numeric_ne | boolean
| numeric, numeric
pg_catalog | numeric_power | numeric
| numeric, numeric
pg_catalog | numeric_recv | numeric
| internal, oid, integer
pg_catalog | numeric_send | bytea
| numeric
pg_catalog | numeric_smaller | numeric
| numeric, numeric
pg_catalog | numeric_sqrt | numeric
| numeric
pg_catalog | numeric_stddev_pop | numeric
| numeric[]
pg_catalog | numeric_stddev_samp | numeric
| numeric[]
pg_catalog | numeric_sub | numeric
| numeric, numeric
pg_catalog | numeric_uminus | numeric
| numeric
pg_catalog | numeric_uplus | numeric
| numeric
pg_catalog | numeric_var_pop | numeric
| numeric[]
pg_catalog | numeric_var_samp | numeric
| numeric[]
pg_catalog | numerictypmodin | integer
| cstring[]
pg_catalog | numnode | integer
| tsquery
pg_catalog | obj_description | text
| oid
pg_catalog | obj_description | text
| oid, name
pg_catalog | octet_length | integer
| bit
pg_catalog | octet_length | integer
| bytea
pg_catalog | octet_length | integer
| character
pg_catalog | octet_length | integer
| text
pg_catalog | oid | oid
| bigint
pg_catalog | oideq | boolean
| oid, oid
pg_catalog | oidge | boolean
| oid, oid
pg_catalog | oidgt | boolean
| oid, oid
pg_catalog | oidlarger | oid
| oid, oid
pg_catalog | oidle | boolean
| oid, oid
pg_catalog | oidlt | boolean
| oid, oid
pg_catalog | oidne | boolean
| oid, oid
pg_catalog | oidrecv | oid
| internal
pg_catalog | oidsend | bytea
| oid
pg_catalog | oidsmaller | oid
| oid, oid
pg_catalog | oidvectoreq | boolean
| oidvector, oidvector
pg_catalog | oidvectorge | boolean
| oidvector, oidvector
pg_catalog | oidvectorgt | boolean
| oidvector, oidvector
pg_catalog | oidvectorle | boolean
| oidvector, oidvector
pg_catalog | oidvectorlt | boolean
| oidvector, oidvector
pg_catalog | oidvectorne | boolean
| oidvector, oidvector
pg_catalog | oidvectorrecv | oidvector
| internal
pg_catalog | oidvectorsend | bytea
| oidvector
pg_catalog | oidvectortypes | text
| oidvector
pg_catalog | on_pb | boolean
| point, box
pg_catalog | on_pl | boolean
| point, line
pg_catalog | on_ppath | boolean
| point, path
pg_catalog | on_ps | boolean
| point, lseg
pg_catalog | on_sb | boolean
| lseg, box
pg_catalog | on_sl | boolean
| lseg, line
pg_catalog | overlaps | boolean
| timestamp without time zone, interval, timestamp without time zone,
interval
pg_catalog | overlaps | boolean
| timestamp without time zone, interval, timestamp without time zone,
timestamp without time zone
pg_catalog | overlaps | boolean
| timestamp without time zone, timestamp without time zone, timestamp
without time zone, interval
pg_catalog | overlaps | boolean
| timestamp without time zone, timestamp without time zone, timestamp
without time zone, timestamp without time zone
pg_catalog | overlaps | boolean
| timestamp with time zone, interval, timestamp with time zone, interval
pg_catalog | overlaps | boolean
| timestamp with time zone, interval, timestamp with time zone,
timestamp with time zone
pg_catalog | overlaps | boolean
| timestamp with time zone, timestamp with time zone, timestamp with
time zone, interval
pg_catalog | overlaps | boolean
| timestamp with time zone, timestamp with time zone, timestamp with
time zone, timestamp with time zone
pg_catalog | overlaps | boolean
| time without time zone, interval, time without time zone, interval
pg_catalog | overlaps | boolean
| time without time zone, interval, time without time zone, time without
time zone
pg_catalog | overlaps | boolean
| time without time zone, time without time zone, time without time
zone, interval
pg_catalog | overlaps | boolean
| time without time zone, time without time zone, time without time
zone, time without time zone
pg_catalog | overlaps | boolean
| time with time zone, time with time zone, time with time zone, time
with time zone
pg_catalog | overlay | text
| text, text, integer
pg_catalog | overlay | text
| text, text, integer, integer
pg_catalog | path | path
| polygon
pg_catalog | path_add | path
| path, path
pg_catalog | path_add_pt | path
| path, point
pg_catalog | path_center | point
| path
pg_catalog | path_contain_pt | boolean
| path, point
pg_catalog | path_distance | double
precision | path, path
pg_catalog | path_div_pt | path
| path, point
pg_catalog | path_inter | boolean
| path, path
pg_catalog | path_length | double
precision | path
pg_catalog | path_mul_pt | path
| path, point
pg_catalog | path_n_eq | boolean
| path, path
pg_catalog | path_n_ge | boolean
| path, path
pg_catalog | path_n_gt | boolean
| path, path
pg_catalog | path_n_le | boolean
| path, path
pg_catalog | path_n_lt | boolean
| path, path
pg_catalog | path_npoints | integer
| path
pg_catalog | path_recv | path
| internal
pg_catalog | path_send | bytea
| path
pg_catalog | path_sub_pt | path
| path, point
pg_catalog | pclose | path
| path
pg_catalog | pg_advisory_lock | void
| bigint
pg_catalog | pg_advisory_lock | void
| integer, integer
pg_catalog | pg_advisory_lock_shared | void
| bigint
pg_catalog | pg_advisory_lock_shared | void
| integer, integer
pg_catalog | pg_advisory_unlock | boolean
| bigint
pg_catalog | pg_advisory_unlock | boolean
| integer, integer
pg_catalog | pg_advisory_unlock_all | void
|
pg_catalog | pg_advisory_unlock_shared | boolean
| bigint
pg_catalog | pg_advisory_unlock_shared | boolean
| integer, integer
pg_catalog | pg_backend_pid | integer
|
pg_catalog | pg_cancel_backend | boolean
| integer
pg_catalog | pg_char_to_encoding | integer
| name
pg_catalog | pg_client_encoding | name
|
pg_catalog | pg_column_size | integer
| "any"
pg_catalog | pg_conversion_is_visible | boolean
| oid
pg_catalog | pg_current_xlog_insert_location | text
|
pg_catalog | pg_current_xlog_location | text
|
pg_catalog | pg_cursor | setof
record |
pg_catalog | pg_database_size | bigint
| name
pg_catalog | pg_database_size | bigint
| oid
pg_catalog | pg_encoding_to_char | name
| integer
pg_catalog | pg_function_is_visible | boolean
| oid
pg_catalog | pg_get_constraintdef | text
| oid
pg_catalog | pg_get_constraintdef | text
| oid, boolean
pg_catalog | pg_get_expr | text
| text, oid
pg_catalog | pg_get_expr | text
| text, oid, boolean
pg_catalog | pg_get_indexdef | text
| oid
pg_catalog | pg_get_indexdef | text
| oid, integer, boolean
pg_catalog | pg_get_ruledef | text
| oid
pg_catalog | pg_get_ruledef | text
| oid, boolean
pg_catalog | pg_get_serial_sequence | text
| text, text
pg_catalog | pg_get_triggerdef | text
| oid
pg_catalog | pg_get_userbyid | name
| oid
pg_catalog | pg_get_viewdef | text
| oid
pg_catalog | pg_get_viewdef | text
| oid, boolean
pg_catalog | pg_get_viewdef | text
| text
pg_catalog | pg_get_viewdef | text
| text, boolean
pg_catalog | pg_has_role | boolean
| name, name, text
pg_catalog | pg_has_role | boolean
| name, oid, text
pg_catalog | pg_has_role | boolean
| name, text
pg_catalog | pg_has_role | boolean
| oid, name, text
pg_catalog | pg_has_role | boolean
| oid, oid, text
pg_catalog | pg_has_role | boolean
| oid, text
pg_catalog | pg_is_other_temp_schema | boolean
| oid
pg_catalog | pg_lock_status | setof
record |
pg_catalog | pg_ls_dir | setof text
| text
pg_catalog | pg_my_temp_schema | oid
|
pg_catalog | pg_opclass_is_visible | boolean
| oid
pg_catalog | pg_operator_is_visible | boolean
| oid
pg_catalog | pg_postmaster_start_time | timestamp
with time zone |
pg_catalog | pg_prepared_statement | setof
record |
pg_catalog | pg_prepared_xact | setof
record |
pg_catalog | pg_read_file | text
| text, bigint, bigint
pg_catalog | pg_relation_size | bigint
| oid
pg_catalog | pg_relation_size | bigint
| text
pg_catalog | pg_reload_conf | boolean
|
pg_catalog | pg_rotate_logfile | boolean
|
pg_catalog | pg_show_all_settings | setof
record |
pg_catalog | pg_size_pretty | text
| bigint
pg_catalog | pg_sleep | void
| double precision
pg_catalog | pg_start_backup | text
| text
pg_catalog | pg_stat_clear_snapshot | void
|
pg_catalog | pg_stat_file | record
| filename text, OUT size bigint, OUT access timestamp with time zone,
OUT modification timestamp with time zone, OUT change timestamp with
time zone, OUT creation timestamp with time zone, OUT isdir boolean
pg_catalog | pg_stat_get_backend_activity | text
| integer
pg_catalog | pg_stat_get_backend_activity_start | timestamp
with time zone | integer
pg_catalog | pg_stat_get_backend_client_addr | inet
| integer
pg_catalog | pg_stat_get_backend_client_port | integer
| integer
pg_catalog | pg_stat_get_backend_dbid | oid
| integer
pg_catalog | pg_stat_get_backend_idset | setof
integer |
pg_catalog | pg_stat_get_backend_pid | integer
| integer
pg_catalog | pg_stat_get_backend_start | timestamp
with time zone | integer
pg_catalog | pg_stat_get_backend_userid | oid
| integer
pg_catalog | pg_stat_get_backend_waiting | boolean
| integer
pg_catalog | pg_stat_get_backend_xact_start | timestamp
with time zone | integer
pg_catalog | pg_stat_get_bgwriter_buf_written_checkpoints | bigint
|
pg_catalog | pg_stat_get_bgwriter_buf_written_clean | bigint
|
pg_catalog | pg_stat_get_bgwriter_maxwritten_clean | bigint
|
pg_catalog | pg_stat_get_bgwriter_requested_checkpoints | bigint
|
pg_catalog | pg_stat_get_bgwriter_timed_checkpoints | bigint
|
pg_catalog | pg_stat_get_blocks_fetched | bigint
| oid
pg_catalog | pg_stat_get_blocks_hit | bigint
| oid
pg_catalog | pg_stat_get_buf_alloc | bigint
|
pg_catalog | pg_stat_get_buf_written_backend | bigint
|
pg_catalog | pg_stat_get_db_blocks_fetched | bigint
| oid
pg_catalog | pg_stat_get_db_blocks_hit | bigint
| oid
pg_catalog | pg_stat_get_db_numbackends | integer
| oid
pg_catalog | pg_stat_get_db_tuples_deleted | bigint
| oid
pg_catalog | pg_stat_get_db_tuples_fetched | bigint
| oid
pg_catalog | pg_stat_get_db_tuples_inserted | bigint
| oid
pg_catalog | pg_stat_get_db_tuples_returned | bigint
| oid
pg_catalog | pg_stat_get_db_tuples_updated | bigint
| oid
pg_catalog | pg_stat_get_db_xact_commit | bigint
| oid
pg_catalog | pg_stat_get_db_xact_rollback | bigint
| oid
pg_catalog | pg_stat_get_dead_tuples | bigint
| oid
pg_catalog | pg_stat_get_last_analyze_time | timestamp
with time zone | oid
pg_catalog | pg_stat_get_last_autoanalyze_time | timestamp
with time zone | oid
pg_catalog | pg_stat_get_last_autovacuum_time | timestamp
with time zone | oid
pg_catalog | pg_stat_get_last_vacuum_time | timestamp
with time zone | oid
pg_catalog | pg_stat_get_live_tuples | bigint
| oid
pg_catalog | pg_stat_get_numscans | bigint
| oid
pg_catalog | pg_stat_get_tuples_deleted | bigint
| oid
pg_catalog | pg_stat_get_tuples_fetched | bigint
| oid
pg_catalog | pg_stat_get_tuples_hot_updated | bigint
| oid
pg_catalog | pg_stat_get_tuples_inserted | bigint
| oid
pg_catalog | pg_stat_get_tuples_returned | bigint
| oid
pg_catalog | pg_stat_get_tuples_updated | bigint
| oid
pg_catalog | pg_stat_reset | void
|
pg_catalog | pg_stop_backup | text
|
pg_catalog | pg_switch_xlog | text
|
pg_catalog | pg_table_is_visible | boolean
| oid
pg_catalog | pg_tablespace_databases | setof oid
| oid
pg_catalog | pg_tablespace_size | bigint
| name
pg_catalog | pg_tablespace_size | bigint
| oid
pg_catalog | pg_timezone_abbrevs | setof
record | OUT abbrev text, OUT utc_offset interval, OUT
is_dst boolean
pg_catalog | pg_timezone_names | setof
record | OUT name text, OUT abbrev text, OUT utc_offset
interval, OUT is_dst boolean
pg_catalog | pg_total_relation_size | bigint
| oid
pg_catalog | pg_total_relation_size | bigint
| text
pg_catalog | pg_try_advisory_lock | boolean
| bigint
pg_catalog | pg_try_advisory_lock | boolean
| integer, integer
pg_catalog | pg_try_advisory_lock_shared | boolean
| bigint
pg_catalog | pg_try_advisory_lock_shared | boolean
| integer, integer
pg_catalog | pg_ts_config_is_visible | boolean
| oid
pg_catalog | pg_ts_dict_is_visible | boolean
| oid
pg_catalog | pg_ts_parser_is_visible | boolean
| oid
pg_catalog | pg_ts_template_is_visible | boolean
| oid
pg_catalog | pg_type_is_visible | boolean
| oid
pg_catalog | pg_xlogfile_name | text
| text
pg_catalog | pg_xlogfile_name_offset | record
| wal_location text, OUT file_name text, OUT file_offset integer
pg_catalog | pi | double
precision |
pg_catalog | plainto_tsquery | tsquery
| regconfig, text
pg_catalog | plainto_tsquery | tsquery
| text
pg_catalog | plpgsql_call_handler |
language_handler |
pg_catalog | plpgsql_validator | void
| oid
pg_catalog | point | point
| box
pg_catalog | point | point
| circle
pg_catalog | point | point
| double precision, double precision
pg_catalog | point | point
| lseg
pg_catalog | point | point
| path
pg_catalog | point | point
| polygon
pg_catalog | point_above | boolean
| point, point
pg_catalog | point_add | point
| point, point
pg_catalog | point_below | boolean
| point, point
pg_catalog | point_distance | double
precision | point, point
pg_catalog | point_div | point
| point, point
pg_catalog | point_eq | boolean
| point, point
pg_catalog | point_horiz | boolean
| point, point
pg_catalog | point_left | boolean
| point, point
pg_catalog | point_mul | point
| point, point
pg_catalog | point_ne | boolean
| point, point
pg_catalog | point_recv | point
| internal
pg_catalog | point_right | boolean
| point, point
pg_catalog | point_send | bytea
| point
pg_catalog | point_sub | point
| point, point
pg_catalog | point_vert | boolean
| point, point
pg_catalog | poly_above | boolean
| polygon, polygon
pg_catalog | poly_below | boolean
| polygon, polygon
pg_catalog | poly_center | point
| polygon
pg_catalog | poly_contain | boolean
| polygon, polygon
pg_catalog | poly_contain_pt | boolean
| polygon, point
pg_catalog | poly_contained | boolean
| polygon, polygon
pg_catalog | poly_distance | double
precision | polygon, polygon
pg_catalog | poly_left | boolean
| polygon, polygon
pg_catalog | poly_npoints | integer
| polygon
pg_catalog | poly_overabove | boolean
| polygon, polygon
pg_catalog | poly_overbelow | boolean
| polygon, polygon
pg_catalog | poly_overlap | boolean
| polygon, polygon
pg_catalog | poly_overleft | boolean
| polygon, polygon
pg_catalog | poly_overright | boolean
| polygon, polygon
pg_catalog | poly_recv | polygon
| internal
pg_catalog | poly_right | boolean
| polygon, polygon
pg_catalog | poly_same | boolean
| polygon, polygon
pg_catalog | poly_send | bytea
| polygon
pg_catalog | polygon | polygon
| box
pg_catalog | polygon | polygon
| circle
pg_catalog | polygon | polygon
| integer, circle
pg_catalog | polygon | polygon
| path
pg_catalog | popen | path
| path
pg_catalog | position | integer
| bit, bit
pg_catalog | position | integer
| bytea, bytea
pg_catalog | position | integer
| text, text
pg_catalog | positionjoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | positionsel | double
precision | internal, oid, internal, integer
pg_catalog | pow | double
precision | double precision, double precision
pg_catalog | pow | numeric
| numeric, numeric
pg_catalog | power | double
precision | double precision, double precision
pg_catalog | power | numeric
| numeric, numeric
pg_catalog | prsd_end | void
| internal
pg_catalog | prsd_headline | internal
| internal, internal, tsquery
pg_catalog | prsd_lextype | internal
| internal
pg_catalog | prsd_nexttoken | internal
| internal, internal, internal
pg_catalog | prsd_start | internal
| internal, integer
pg_catalog | pt_contained_circle | boolean
| point, circle
pg_catalog | pt_contained_poly | boolean
| point, polygon
pg_catalog | query_to_xml | xml
| query text, nulls boolean, tableforest boolean, targetns text
pg_catalog | query_to_xml_and_xmlschema | xml
| query text, nulls boolean, tableforest boolean, targetns text
pg_catalog | query_to_xmlschema | xml
| query text, nulls boolean, tableforest boolean, targetns text
pg_catalog | querytree | text
| tsquery
pg_catalog | quote_ident | text
| text
pg_catalog | quote_literal | text
| anyelement
pg_catalog | quote_literal | text
| text
pg_catalog | radians | double
precision | double precision
pg_catalog | radius | double
precision | circle
pg_catalog | random | double
precision |
pg_catalog | record_recv | record
| internal, oid, integer
pg_catalog | record_send | bytea
| record
pg_catalog | regclass | regclass
| text
pg_catalog | regclassrecv | regclass
| internal
pg_catalog | regclasssend | bytea
| regclass
pg_catalog | regconfigrecv | regconfig
| internal
pg_catalog | regconfigsend | bytea
| regconfig
pg_catalog | regdictionaryrecv |
regdictionary | internal
pg_catalog | regdictionarysend | bytea
| regdictionary
pg_catalog | regexeqjoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | regexeqsel | double
precision | internal, oid, internal, integer
pg_catalog | regexnejoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | regexnesel | double
precision | internal, oid, internal, integer
pg_catalog | regexp_matches | setof
text[] | text, text
pg_catalog | regexp_matches | setof
text[] | text, text, text
pg_catalog | regexp_replace | text
| text, text, text
pg_catalog | regexp_replace | text
| text, text, text, text
pg_catalog | regexp_split_to_array | text[]
| text, text
pg_catalog | regexp_split_to_array | text[]
| text, text, text
pg_catalog | regexp_split_to_table | setof text
| text, text
pg_catalog | regexp_split_to_table | setof text
| text, text, text
pg_catalog | regoperatorrecv | regoperator
| internal
pg_catalog | regoperatorsend | bytea
| regoperator
pg_catalog | regoperrecv | regoper
| internal
pg_catalog | regopersend | bytea
| regoper
pg_catalog | regprocedurerecv |
regprocedure | internal
pg_catalog | regproceduresend | bytea
| regprocedure
pg_catalog | regprocrecv | regproc
| internal
pg_catalog | regprocsend | bytea
| regproc
pg_catalog | regtyperecv | regtype
| internal
pg_catalog | regtypesend | bytea
| regtype
pg_catalog | reltime | reltime
| interval
pg_catalog | reltimeeq | boolean
| reltime, reltime
pg_catalog | reltimege | boolean
| reltime, reltime
pg_catalog | reltimegt | boolean
| reltime, reltime
pg_catalog | reltimele | boolean
| reltime, reltime
pg_catalog | reltimelt | boolean
| reltime, reltime
pg_catalog | reltimene | boolean
| reltime, reltime
pg_catalog | reltimerecv | reltime
| internal
pg_catalog | reltimesend | bytea
| reltime
pg_catalog | repeat | text
| text, integer
pg_catalog | replace | text
| text, text, text
pg_catalog | round | double
precision | double precision
pg_catalog | round | numeric
| numeric
pg_catalog | round | numeric
| numeric, integer
pg_catalog | rpad | text
| text, integer
pg_catalog | rpad | text
| text, integer, text
pg_catalog | rtrim | text
| text
pg_catalog | rtrim | text
| text, text
pg_catalog | scalargtjoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | scalargtsel | double
precision | internal, oid, internal, integer
pg_catalog | scalarltjoinsel | double
precision | internal, oid, internal, smallint
pg_catalog | scalarltsel | double
precision | internal, oid, internal, integer
pg_catalog | schema_to_xml | xml
| schema name, nulls boolean, tableforest boolean, targetns text
pg_catalog | schema_to_xml_and_xmlschema | xml
| schema name, nulls boolean, tableforest boolean, targetns text
pg_catalog | schema_to_xmlschema | xml
| schema name, nulls boolean, tableforest boolean, targetns text
pg_catalog | session_user | name
|
pg_catalog | set_bit | bytea
| bytea, integer, integer
pg_catalog | set_byte | bytea
| bytea, integer, integer
pg_catalog | set_config | text
| text, text, boolean
pg_catalog | set_masklen | cidr
| cidr, integer
pg_catalog | set_masklen | inet
| inet, integer
pg_catalog | setseed | void
| double precision
pg_catalog | setval | bigint
| regclass, bigint
pg_catalog | setval | bigint
| regclass, bigint, boolean
pg_catalog | setweight | tsvector
| tsvector, "char"
pg_catalog | shift_jis_2004_to_euc_jis_2004 | void
| integer, integer, cstring, internal, integer
pg_catalog | shift_jis_2004_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | shobj_description | text
| oid, name
pg_catalog | sign | double
precision | double precision
pg_catalog | sign | numeric
| numeric
pg_catalog | similar_escape | text
| text, text
pg_catalog | sin | double
precision | double precision
pg_catalog | sjis_to_euc_jp | void
| integer, integer, cstring, internal, integer
pg_catalog | sjis_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | sjis_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | slope | double
precision | point, point
pg_catalog | smgreq | boolean
| smgr, smgr
pg_catalog | smgrne | boolean
| smgr, smgr
pg_catalog | split_part | text
| text, text, integer
pg_catalog | sqrt | double
precision | double precision
pg_catalog | sqrt | numeric
| numeric
pg_catalog | statement_timestamp | timestamp
with time zone |
pg_catalog | string_to_array | text[]
| text, text
pg_catalog | strip | tsvector
| tsvector
pg_catalog | strpos | integer
| text, text
pg_catalog | substr | bytea
| bytea, integer
pg_catalog | substr | bytea
| bytea, integer, integer
pg_catalog | substr | text
| text, integer
pg_catalog | substr | text
| text, integer, integer
pg_catalog | substring | bit
| bit, integer
pg_catalog | substring | bit
| bit, integer, integer
pg_catalog | substring | bytea
| bytea, integer
pg_catalog | substring | bytea
| bytea, integer, integer
pg_catalog | substring | text
| text, integer
pg_catalog | substring | text
| text, integer, integer
pg_catalog | substring | text
| text, text
pg_catalog | substring | text
| text, text, text
pg_catalog | table_to_xml | xml
| tbl regclass, nulls boolean, tableforest boolean, targetns text
pg_catalog | table_to_xml_and_xmlschema | xml
| tbl regclass, nulls boolean, tableforest boolean, targetns text
pg_catalog | table_to_xmlschema | xml
| tbl regclass, nulls boolean, tableforest boolean, targetns text
pg_catalog | tan | double
precision | double precision
pg_catalog | text | text
| boolean
pg_catalog | text | text
| "char"
pg_catalog | text | text
| character
pg_catalog | text | text
| inet
pg_catalog | text | text
| name
pg_catalog | text | text
| xml
pg_catalog | text_ge | boolean
| text, text
pg_catalog | text_gt | boolean
| text, text
pg_catalog | text_larger | text
| text, text
pg_catalog | text_le | boolean
| text, text
pg_catalog | text_lt | boolean
| text, text
pg_catalog | text_pattern_eq | boolean
| text, text
pg_catalog | text_pattern_ge | boolean
| text, text
pg_catalog | text_pattern_gt | boolean
| text, text
pg_catalog | text_pattern_le | boolean
| text, text
pg_catalog | text_pattern_lt | boolean
| text, text
pg_catalog | text_pattern_ne | boolean
| text, text
pg_catalog | text_smaller | text
| text, text
pg_catalog | textanycat | text
| text, anynonarray
pg_catalog | textcat | text
| text, text
pg_catalog | texteq | boolean
| text, text
pg_catalog | texticlike | boolean
| text, text
pg_catalog | texticnlike | boolean
| text, text
pg_catalog | texticregexeq | boolean
| text, text
pg_catalog | texticregexne | boolean
| text, text
pg_catalog | textlen | integer
| text
pg_catalog | textlike | boolean
| text, text
pg_catalog | textne | boolean
| text, text
pg_catalog | textnlike | boolean
| text, text
pg_catalog | textrecv | text
| internal
pg_catalog | textregexeq | boolean
| text, text
pg_catalog | textregexne | boolean
| text, text
pg_catalog | textsend | bytea
| text
pg_catalog | thesaurus_init | internal
| internal
pg_catalog | thesaurus_lexize | internal
| internal, internal, internal, internal
pg_catalog | tideq | boolean
| tid, tid
pg_catalog | tidge | boolean
| tid, tid
pg_catalog | tidgt | boolean
| tid, tid
pg_catalog | tidlarger | tid
| tid, tid
pg_catalog | tidle | boolean
| tid, tid
pg_catalog | tidlt | boolean
| tid, tid
pg_catalog | tidne | boolean
| tid, tid
pg_catalog | tidrecv | tid
| internal
pg_catalog | tidsend | bytea
| tid
pg_catalog | tidsmaller | tid
| tid, tid
pg_catalog | time | time
without time zone | abstime
pg_catalog | time | time
without time zone | interval
pg_catalog | time | time
without time zone | timestamp without time zone
pg_catalog | time | time
without time zone | timestamp with time zone
pg_catalog | time | time
without time zone | time without time zone, integer
pg_catalog | time | time
without time zone | time with time zone
pg_catalog | time_cmp | integer
| time without time zone, time without time zone
pg_catalog | time_eq | boolean
| time without time zone, time without time zone
pg_catalog | time_ge | boolean
| time without time zone, time without time zone
pg_catalog | time_gt | boolean
| time without time zone, time without time zone
pg_catalog | time_hash | integer
| time without time zone
pg_catalog | time_larger | time
without time zone | time without time zone, time without time zone
pg_catalog | time_le | boolean
| time without time zone, time without time zone
pg_catalog | time_lt | boolean
| time without time zone, time without time zone
pg_catalog | time_mi_interval | time
without time zone | time without time zone, interval
pg_catalog | time_mi_time | interval
| time without time zone, time without time zone
pg_catalog | time_ne | boolean
| time without time zone, time without time zone
pg_catalog | time_pl_interval | time
without time zone | time without time zone, interval
pg_catalog | time_recv | time
without time zone | internal, oid, integer
pg_catalog | time_send | bytea
| time without time zone
pg_catalog | time_smaller | time
without time zone | time without time zone, time without time zone
pg_catalog | timedate_pl | timestamp
without time zone | time without time zone, date
pg_catalog | timemi | abstime
| abstime, reltime
pg_catalog | timenow | abstime
|
pg_catalog | timeofday | text
|
pg_catalog | timepl | abstime
| abstime, reltime
pg_catalog | timestamp | timestamp
without time zone | abstime
pg_catalog | timestamp | timestamp
without time zone | date
pg_catalog | timestamp | timestamp
without time zone | date, time without time zone
pg_catalog | timestamp | timestamp
without time zone | timestamp without time zone, integer
pg_catalog | timestamp | timestamp
without time zone | timestamp with time zone
pg_catalog | timestamp_cmp | integer
| timestamp without time zone, timestamp without time zone
pg_catalog | timestamp_cmp_date | integer
| timestamp without time zone, date
pg_catalog | timestamp_cmp_timestamptz | integer
| timestamp without time zone, timestamp with time zone
pg_catalog | timestamp_eq | boolean
| timestamp without time zone, timestamp without time zone
pg_catalog | timestamp_eq_date | boolean
| timestamp without time zone, date
pg_catalog | timestamp_eq_timestamptz | boolean
| timestamp without time zone, timestamp with time zone
pg_catalog | timestamp_ge | boolean
| timestamp without time zone, timestamp without time zone
pg_catalog | timestamp_ge_date | boolean
| timestamp without time zone, date
pg_catalog | timestamp_ge_timestamptz | boolean
| timestamp without time zone, timestamp with time zone
pg_catalog | timestamp_gt | boolean
| timestamp without time zone, timestamp without time zone
pg_catalog | timestamp_gt_date | boolean
| timestamp without time zone, date
pg_catalog | timestamp_gt_timestamptz | boolean
| timestamp without time zone, timestamp with time zone
pg_catalog | timestamp_hash | integer
| timestamp without time zone
pg_catalog | timestamp_larger | timestamp
without time zone | timestamp without time zone, timestamp without time
zone
pg_catalog | timestamp_le | boolean
| timestamp without time zone, timestamp without time zone
pg_catalog | timestamp_le_date | boolean
| timestamp without time zone, date
pg_catalog | timestamp_le_timestamptz | boolean
| timestamp without time zone, timestamp with time zone
pg_catalog | timestamp_lt | boolean
| timestamp without time zone, timestamp without time zone
pg_catalog | timestamp_lt_date | boolean
| timestamp without time zone, date
pg_catalog | timestamp_lt_timestamptz | boolean
| timestamp without time zone, timestamp with time zone
pg_catalog | timestamp_mi | interval
| timestamp without time zone, timestamp without time zone
pg_catalog | timestamp_mi_interval | timestamp
without time zone | timestamp without time zone, interval
pg_catalog | timestamp_ne | boolean
| timestamp without time zone, timestamp without time zone
pg_catalog | timestamp_ne_date | boolean
| timestamp without time zone, date
pg_catalog | timestamp_ne_timestamptz | boolean
| timestamp without time zone, timestamp with time zone
pg_catalog | timestamp_pl_interval | timestamp
without time zone | timestamp without time zone, interval
pg_catalog | timestamp_recv | timestamp
without time zone | internal, oid, integer
pg_catalog | timestamp_send | bytea
| timestamp without time zone
pg_catalog | timestamp_smaller | timestamp
without time zone | timestamp without time zone, timestamp without time
zone
pg_catalog | timestamptypmodin | integer
| cstring[]
pg_catalog | timestamptz | timestamp
with time zone | abstime
pg_catalog | timestamptz | timestamp
with time zone | date
pg_catalog | timestamptz | timestamp
with time zone | date, time without time zone
pg_catalog | timestamptz | timestamp
with time zone | date, time with time zone
pg_catalog | timestamptz | timestamp
with time zone | timestamp without time zone
pg_catalog | timestamptz | timestamp
with time zone | timestamp with time zone, integer
pg_catalog | timestamptz_cmp | integer
| timestamp with time zone, timestamp with time zone
pg_catalog | timestamptz_cmp_date | integer
| timestamp with time zone, date
pg_catalog | timestamptz_cmp_timestamp | integer
| timestamp with time zone, timestamp without time zone
pg_catalog | timestamptz_eq | boolean
| timestamp with time zone, timestamp with time zone
pg_catalog | timestamptz_eq_date | boolean
| timestamp with time zone, date
pg_catalog | timestamptz_eq_timestamp | boolean
| timestamp with time zone, timestamp without time zone
pg_catalog | timestamptz_ge | boolean
| timestamp with time zone, timestamp with time zone
pg_catalog | timestamptz_ge_date | boolean
| timestamp with time zone, date
pg_catalog | timestamptz_ge_timestamp | boolean
| timestamp with time zone, timestamp without time zone
pg_catalog | timestamptz_gt | boolean
| timestamp with time zone, timestamp with time zone
pg_catalog | timestamptz_gt_date | boolean
| timestamp with time zone, date
pg_catalog | timestamptz_gt_timestamp | boolean
| timestamp with time zone, timestamp without time zone
pg_catalog | timestamptz_larger | timestamp
with time zone | timestamp with time zone, timestamp with time zone
pg_catalog | timestamptz_le | boolean
| timestamp with time zone, timestamp with time zone
pg_catalog | timestamptz_le_date | boolean
| timestamp with time zone, date
pg_catalog | timestamptz_le_timestamp | boolean
| timestamp with time zone, timestamp without time zone
pg_catalog | timestamptz_lt | boolean
| timestamp with time zone, timestamp with time zone
pg_catalog | timestamptz_lt_date | boolean
| timestamp with time zone, date
pg_catalog | timestamptz_lt_timestamp | boolean
| timestamp with time zone, timestamp without time zone
pg_catalog | timestamptz_mi | interval
| timestamp with time zone, timestamp with time zone
pg_catalog | timestamptz_mi_interval | timestamp
with time zone | timestamp with time zone, interval
pg_catalog | timestamptz_ne | boolean
| timestamp with time zone, timestamp with time zone
pg_catalog | timestamptz_ne_date | boolean
| timestamp with time zone, date
pg_catalog | timestamptz_ne_timestamp | boolean
| timestamp with time zone, timestamp without time zone
pg_catalog | timestamptz_pl_interval | timestamp
with time zone | timestamp with time zone, interval
pg_catalog | timestamptz_recv | timestamp
with time zone | internal, oid, integer
pg_catalog | timestamptz_send | bytea
| timestamp with time zone
pg_catalog | timestamptz_smaller | timestamp
with time zone | timestamp with time zone, timestamp with time zone
pg_catalog | timestamptztypmodin | integer
| cstring[]
pg_catalog | timetypmodin | integer
| cstring[]
pg_catalog | timetz | time with
time zone | timestamp with time zone
pg_catalog | timetz | time with
time zone | time without time zone
pg_catalog | timetz | time with
time zone | time with time zone, integer
pg_catalog | timetz_cmp | integer
| time with time zone, time with time zone
pg_catalog | timetz_eq | boolean
| time with time zone, time with time zone
pg_catalog | timetz_ge | boolean
| time with time zone, time with time zone
pg_catalog | timetz_gt | boolean
| time with time zone, time with time zone
pg_catalog | timetz_hash | integer
| time with time zone
pg_catalog | timetz_larger | time with
time zone | time with time zone, time with time zone
pg_catalog | timetz_le | boolean
| time with time zone, time with time zone
pg_catalog | timetz_lt | boolean
| time with time zone, time with time zone
pg_catalog | timetz_mi_interval | time with
time zone | time with time zone, interval
pg_catalog | timetz_ne | boolean
| time with time zone, time with time zone
pg_catalog | timetz_pl_interval | time with
time zone | time with time zone, interval
pg_catalog | timetz_recv | time with
time zone | internal, oid, integer
pg_catalog | timetz_send | bytea
| time with time zone
pg_catalog | timetz_smaller | time with
time zone | time with time zone, time with time zone
pg_catalog | timetzdate_pl | timestamp
with time zone | time with time zone, date
pg_catalog | timetztypmodin | integer
| cstring[]
pg_catalog | timezone | timestamp
without time zone | interval, timestamp with time zone
pg_catalog | timezone | timestamp
without time zone | text, timestamp with time zone
pg_catalog | timezone | timestamp
with time zone | interval, timestamp without time zone
pg_catalog | timezone | timestamp
with time zone | text, timestamp without time zone
pg_catalog | timezone | time with
time zone | interval, time with time zone
pg_catalog | timezone | time with
time zone | text, time with time zone
pg_catalog | tinterval | tinterval
| abstime, abstime
pg_catalog | tintervalct | boolean
| tinterval, tinterval
pg_catalog | tintervalend | abstime
| tinterval
pg_catalog | tintervaleq | boolean
| tinterval, tinterval
pg_catalog | tintervalge | boolean
| tinterval, tinterval
pg_catalog | tintervalgt | boolean
| tinterval, tinterval
pg_catalog | tintervalle | boolean
| tinterval, tinterval
pg_catalog | tintervalleneq | boolean
| tinterval, reltime
pg_catalog | tintervallenge | boolean
| tinterval, reltime
pg_catalog | tintervallengt | boolean
| tinterval, reltime
pg_catalog | tintervallenle | boolean
| tinterval, reltime
pg_catalog | tintervallenlt | boolean
| tinterval, reltime
pg_catalog | tintervallenne | boolean
| tinterval, reltime
pg_catalog | tintervallt | boolean
| tinterval, tinterval
pg_catalog | tintervalne | boolean
| tinterval, tinterval
pg_catalog | tintervalov | boolean
| tinterval, tinterval
pg_catalog | tintervalrecv | tinterval
| internal
pg_catalog | tintervalrel | reltime
| tinterval
pg_catalog | tintervalsame | boolean
| tinterval, tinterval
pg_catalog | tintervalsend | bytea
| tinterval
pg_catalog | tintervalstart | abstime
| tinterval
pg_catalog | to_ascii | text
| text
pg_catalog | to_ascii | text
| text, integer
pg_catalog | to_ascii | text
| text, name
pg_catalog | to_char | text
| bigint, text
pg_catalog | to_char | text
| double precision, text
pg_catalog | to_char | text
| integer, text
pg_catalog | to_char | text
| interval, text
pg_catalog | to_char | text
| numeric, text
pg_catalog | to_char | text
| real, text
pg_catalog | to_char | text
| timestamp without time zone, text
pg_catalog | to_char | text
| timestamp with time zone, text
pg_catalog | to_date | date
| text, text
pg_catalog | to_hex | text
| bigint
pg_catalog | to_hex | text
| integer
pg_catalog | to_number | numeric
| text, text
pg_catalog | to_timestamp | timestamp
with time zone | double precision
pg_catalog | to_timestamp | timestamp
with time zone | text, text
pg_catalog | to_tsquery | tsquery
| regconfig, text
pg_catalog | to_tsquery | tsquery
| text
pg_catalog | to_tsvector | tsvector
| regconfig, text
pg_catalog | to_tsvector | tsvector
| text
pg_catalog | transaction_timestamp | timestamp
with time zone |
pg_catalog | translate | text
| text, text, text
pg_catalog | trunc | double
precision | double precision
pg_catalog | trunc | macaddr
| macaddr
pg_catalog | trunc | numeric
| numeric
pg_catalog | trunc | numeric
| numeric, integer
pg_catalog | ts_debug | setof
record | config regconfig, document text, OUT alias text,
OUT description text, OUT token text, OUT dictionaries regdictionary[],
OUT dictionary regdictionary, OUT lexemes text[]
pg_catalog | ts_debug | setof
record | document text, OUT alias text, OUT description
text, OUT token text, OUT dictionaries regdictionary[], OUT dictionary
regdictionary, OUT lexemes text[]
pg_catalog | ts_headline | text
| regconfig, text, tsquery
pg_catalog | ts_headline | text
| regconfig, text, tsquery, text
pg_catalog | ts_headline | text
| text, tsquery
pg_catalog | ts_headline | text
| text, tsquery, text
pg_catalog | ts_lexize | text[]
| regdictionary, text
pg_catalog | ts_match_qv | boolean
| tsquery, tsvector
pg_catalog | ts_match_tq | boolean
| text, tsquery
pg_catalog | ts_match_tt | boolean
| text, text
pg_catalog | ts_match_vq | boolean
| tsvector, tsquery
pg_catalog | ts_parse | setof
record | parser_name text, txt text, OUT tokid integer,
OUT token text
pg_catalog | ts_parse | setof
record | parser_oid oid, txt text, OUT tokid integer, OUT
token text
pg_catalog | ts_rank | real
| real[], tsvector, tsquery
pg_catalog | ts_rank | real
| real[], tsvector, tsquery, integer
pg_catalog | ts_rank | real
| tsvector, tsquery
pg_catalog | ts_rank | real
| tsvector, tsquery, integer
pg_catalog | ts_rank_cd | real
| real[], tsvector, tsquery
pg_catalog | ts_rank_cd | real
| real[], tsvector, tsquery, integer
pg_catalog | ts_rank_cd | real
| tsvector, tsquery
pg_catalog | ts_rank_cd | real
| tsvector, tsquery, integer
pg_catalog | ts_rewrite | tsquery
| tsquery, text
pg_catalog | ts_rewrite | tsquery
| tsquery, tsquery, tsquery
pg_catalog | ts_stat | setof
record | query text, OUT word text, OUT ndoc integer, OUT
nentry integer
pg_catalog | ts_stat | setof
record | query text, weights text, OUT word text, OUT
ndoc integer, OUT nentry integer
pg_catalog | ts_token_type | setof
record | parser_name text, OUT tokid integer, OUT alias
text, OUT description text
pg_catalog | ts_token_type | setof
record | parser_oid oid, OUT tokid integer, OUT alias
text, OUT description text
pg_catalog | tsq_mcontained | boolean
| tsquery, tsquery
pg_catalog | tsq_mcontains | boolean
| tsquery, tsquery
pg_catalog | tsquery_and | tsquery
| tsquery, tsquery
pg_catalog | tsquery_cmp | integer
| tsquery, tsquery
pg_catalog | tsquery_eq | boolean
| tsquery, tsquery
pg_catalog | tsquery_ge | boolean
| tsquery, tsquery
pg_catalog | tsquery_gt | boolean
| tsquery, tsquery
pg_catalog | tsquery_le | boolean
| tsquery, tsquery
pg_catalog | tsquery_lt | boolean
| tsquery, tsquery
pg_catalog | tsquery_ne | boolean
| tsquery, tsquery
pg_catalog | tsquery_not | tsquery
| tsquery
pg_catalog | tsquery_or | tsquery
| tsquery, tsquery
pg_catalog | tsqueryrecv | tsquery
| internal
pg_catalog | tsquerysend | bytea
| tsquery
pg_catalog | tsvector_cmp | integer
| tsvector, tsvector
pg_catalog | tsvector_concat | tsvector
| tsvector, tsvector
pg_catalog | tsvector_eq | boolean
| tsvector, tsvector
pg_catalog | tsvector_ge | boolean
| tsvector, tsvector
pg_catalog | tsvector_gt | boolean
| tsvector, tsvector
pg_catalog | tsvector_le | boolean
| tsvector, tsvector
pg_catalog | tsvector_lt | boolean
| tsvector, tsvector
pg_catalog | tsvector_ne | boolean
| tsvector, tsvector
pg_catalog | tsvector_update_trigger | trigger
|
pg_catalog | tsvector_update_trigger_column | trigger
|
pg_catalog | tsvectorrecv | tsvector
| internal
pg_catalog | tsvectorsend | bytea
| tsvector
pg_catalog | txid_current | bigint
|
pg_catalog | txid_current_snapshot |
txid_snapshot |
pg_catalog | txid_snapshot_recv |
txid_snapshot | internal
pg_catalog | txid_snapshot_send | bytea
| txid_snapshot
pg_catalog | txid_snapshot_xip | setof
bigint | txid_snapshot
pg_catalog | txid_snapshot_xmax | bigint
| txid_snapshot
pg_catalog | txid_snapshot_xmin | bigint
| txid_snapshot
pg_catalog | txid_visible_in_snapshot | boolean
| bigint, txid_snapshot
pg_catalog | uhc_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | unknownrecv | unknown
| internal
pg_catalog | unknownsend | bytea
| unknown
pg_catalog | upper | text
| text
pg_catalog | utf8_to_ascii | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_big5 | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_euc_cn | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_euc_jis_2004 | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_euc_jp | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_euc_kr | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_euc_tw | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_gb18030 | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_gbk | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_iso8859 | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_iso8859_1 | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_johab | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_koi8r | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_shift_jis_2004 | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_sjis | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_uhc | void
| integer, integer, cstring, internal, integer
pg_catalog | utf8_to_win | void
| integer, integer, cstring, internal, integer
pg_catalog | uuid_cmp | integer
| uuid, uuid
pg_catalog | uuid_eq | boolean
| uuid, uuid
pg_catalog | uuid_ge | boolean
| uuid, uuid
pg_catalog | uuid_gt | boolean
| uuid, uuid
pg_catalog | uuid_hash | integer
| uuid
pg_catalog | uuid_le | boolean
| uuid, uuid
pg_catalog | uuid_lt | boolean
| uuid, uuid
pg_catalog | uuid_ne | boolean
| uuid, uuid
pg_catalog | uuid_recv | uuid
| internal
pg_catalog | uuid_send | bytea
| uuid
pg_catalog | varbit | bit varying
| bit varying, integer, boolean
pg_catalog | varbit_recv | bit varying
| internal, oid, integer
pg_catalog | varbit_send | bytea
| bit varying
pg_catalog | varbitcmp | integer
| bit varying, bit varying
pg_catalog | varbiteq | boolean
| bit varying, bit varying
pg_catalog | varbitge | boolean
| bit varying, bit varying
pg_catalog | varbitgt | boolean
| bit varying, bit varying
pg_catalog | varbitle | boolean
| bit varying, bit varying
pg_catalog | varbitlt | boolean
| bit varying, bit varying
pg_catalog | varbitne | boolean
| bit varying, bit varying
pg_catalog | varbittypmodin | integer
| cstring[]
pg_catalog | varchar | character
varying | character varying, integer, boolean
pg_catalog | varchar | character
varying | name
pg_catalog | varcharrecv | character
varying | internal, oid, integer
pg_catalog | varcharsend | bytea
| character varying
pg_catalog | varchartypmodin | integer
| cstring[]
pg_catalog | version | text
|
pg_catalog | width | double
precision | box
pg_catalog | width_bucket | integer
| double precision, double precision, double precision, integer
pg_catalog | width_bucket | integer
| numeric, numeric, numeric, integer
pg_catalog | win1250_to_latin2 | void
| integer, integer, cstring, internal, integer
pg_catalog | win1250_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | win1251_to_iso | void
| integer, integer, cstring, internal, integer
pg_catalog | win1251_to_koi8r | void
| integer, integer, cstring, internal, integer
pg_catalog | win1251_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | win1251_to_win866 | void
| integer, integer, cstring, internal, integer
pg_catalog | win866_to_iso | void
| integer, integer, cstring, internal, integer
pg_catalog | win866_to_koi8r | void
| integer, integer, cstring, internal, integer
pg_catalog | win866_to_mic | void
| integer, integer, cstring, internal, integer
pg_catalog | win866_to_win1251 | void
| integer, integer, cstring, internal, integer
pg_catalog | win_to_utf8 | void
| integer, integer, cstring, internal, integer
pg_catalog | xideq | boolean
| xid, xid
pg_catalog | xideqint4 | boolean
| xid, integer
pg_catalog | xidrecv | xid
| internal
pg_catalog | xidsend | bytea
| xid
pg_catalog | xml | xml
| text
pg_catalog | xml_recv | xml
| internal
pg_catalog | xml_send | bytea
| xml
pg_catalog | xmlcomment | xml
| text
pg_catalog | xmlconcat2 | xml
| xml, xml
pg_catalog | xmlvalidate | boolean
| xml, text
pg_catalog | xpath | xml[]
| text, xml
pg_catalog | xpath | xml[]
| text, xml, text[]
public | drop_table | integer
|
public | foo | setof text
|
public | plfoo | setof text
|
(1858 rows)

--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997