pg catalog tables and views

sachi=> \dt pg_catalog.*
List of relations
Schema    | Name | Type | Owner | Storage
------------+-------------------------------+-------+---------+---------
pg_catalog | gp_configuration | table | gpadmin | heap
pg_catalog | gp_configuration_history | table | gpadmin | heap
pg_catalog | gp_db_interfaces | table | gpadmin | heap
pg_catalog | gp_distribution_policy | table | gpadmin | heap
pg_catalog | gp_fastsequence | table | gpadmin | heap
pg_catalog | gp_fault_strategy | table | gpadmin | heap
pg_catalog | gp_global_sequence | table | gpadmin | heap
pg_catalog | gp_id | table | gpadmin | heap
pg_catalog | gp_interfaces | table | gpadmin | heap
pg_catalog | gp_master_mirroring | table | gpadmin | heap
pg_catalog | gp_persistent_database_node | table | gpadmin | heap
pg_catalog | gp_persistent_filespace_node | table | gpadmin | heap
pg_catalog | gp_persistent_relation_node | table | gpadmin | heap
pg_catalog | gp_persistent_tablespace_node | table | gpadmin | heap
pg_catalog | gp_relation_node | table | gpadmin | heap
pg_catalog | gp_san_configuration | table | gpadmin | heap
pg_catalog | gp_segment_configuration | table | gpadmin | heap
pg_catalog | gp_verification_history | table | gpadmin | heap
pg_catalog | gp_version_at_initdb | table | gpadmin | heap
The gadget spec URL could not be found
pg_catalog | pg_aggregate | table | gpadmin | heap
pg_catalog | pg_am | table | gpadmin | heap
pg_catalog | pg_amop | table | gpadmin | heap
pg_catalog | pg_amproc | table | gpadmin | heap
pg_catalog | pg_appendonly | table | gpadmin | heap
pg_catalog | pg_appendonly_alter_column | table | gpadmin | heap
pg_catalog | pg_attrdef | table | gpadmin | heap
pg_catalog | pg_attribute | table | gpadmin | heap
pg_catalog | pg_attribute_encoding | table | gpadmin | heap
pg_catalog | pg_auth_members | table | gpadmin | heap
pg_catalog | pg_auth_time_constraint | table | gpadmin | heap
pg_catalog | pg_authid | table | gpadmin | heap
pg_catalog | pg_autovacuum | table | gpadmin | heap
pg_catalog | pg_cast | table | gpadmin | heap
pg_catalog | pg_class | table | gpadmin | heap
pg_catalog | pg_compression | table | gpadmin | heap
pg_catalog | pg_constraint | table | gpadmin | heap
pg_catalog | pg_conversion | table | gpadmin | heap
pg_catalog | pg_database | table | gpadmin | heap
pg_catalog | pg_depend | table | gpadmin | heap
pg_catalog | pg_description | table | gpadmin | heap
pg_catalog | pg_extprotocol | table | gpadmin | heap
pg_catalog | pg_exttable | table | gpadmin | heap
pg_catalog | pg_filespace | table | gpadmin | heap
pg_catalog | pg_filespace_entry | table | gpadmin | heap
pg_catalog | pg_foreign_data_wrapper | table | gpadmin | heap
pg_catalog | pg_foreign_server | table | gpadmin | heap
pg_catalog | pg_foreign_table | table | gpadmin | heap
pg_catalog | pg_index | table | gpadmin | heap
pg_catalog | pg_inherits | table | gpadmin | heap
pg_catalog | pg_language | table | gpadmin | heap
pg_catalog | pg_largeobject | table | gpadmin | heap
pg_catalog | pg_listener | table | gpadmin | heap
pg_catalog | pg_namespace | table | gpadmin | heap
pg_catalog | pg_opclass | table | gpadmin | heap
pg_catalog | pg_operator | table | gpadmin | heap
pg_catalog | pg_partition | table | gpadmin | heap
pg_catalog | pg_partition_encoding | table | gpadmin | heap
pg_catalog | pg_partition_rule | table | gpadmin | heap
pg_catalog | pg_pltemplate | table | gpadmin | heap
pg_catalog | pg_proc | table | gpadmin | heap
pg_catalog | pg_proc_callback | table | gpadmin | heap
pg_catalog | pg_resourcetype | table | gpadmin | heap
pg_catalog | pg_resqueue | table | gpadmin | heap
pg_catalog | pg_resqueuecapability | table | gpadmin | heap
pg_catalog | pg_rewrite | table | gpadmin | heap
pg_catalog | pg_shdepend | table | gpadmin | heap
pg_catalog | pg_shdescription | table | gpadmin | heap
pg_catalog | pg_stat_last_operation | table | gpadmin | heap
pg_catalog | pg_stat_last_shoperation | table | gpadmin | heap
pg_catalog | pg_statistic | table | gpadmin | heap
pg_catalog | pg_tablespace | table | gpadmin | heap
pg_catalog | pg_trigger | table | gpadmin | heap
pg_catalog | pg_type | table | gpadmin | heap
pg_catalog | pg_type_encoding | table | gpadmin | heap
pg_catalog | pg_user_mapping | table | gpadmin | heap
pg_catalog | pg_window | table | gpadmin | heap
(76 rows)

sachi=>
sachi=> \dv pg_catalog.*
List of relations
Schema     | Name | Type | Owner | Storage
------------+------------------------------+------+---------+---------
pg_catalog | gp_distributed_log | view | gpadmin | none
pg_catalog | gp_distributed_xacts | view | gpadmin | none
pg_catalog | gp_pgdatabase | view | gpadmin | none
pg_catalog | gp_transaction_log | view | gpadmin | none

pg_catalog | pg_cursors | view | gpadmin | none
pg_catalog | pg_group | view | gpadmin | none
pg_catalog | pg_indexes | view | gpadmin | none
pg_catalog | pg_locks | view | gpadmin | none
pg_catalog | pg_max_external_files | view | gpadmin | none
pg_catalog | pg_partition_columns | view | gpadmin | none
pg_catalog | pg_partition_templates | view | gpadmin | none
pg_catalog | pg_partitions | view | gpadmin | none
pg_catalog | pg_prepared_statements | view | gpadmin | none
pg_catalog | pg_prepared_xacts | view | gpadmin | none
pg_catalog | pg_resqueue_attributes | view | gpadmin | none
pg_catalog | pg_resqueue_status | view | gpadmin | none
pg_catalog | pg_roles | view | gpadmin | none
pg_catalog | pg_rules | view | gpadmin | none
pg_catalog | pg_settings | view | gpadmin | none
pg_catalog | pg_shadow | view | gpadmin | none
pg_catalog | pg_stat_activity | view | gpadmin | none
pg_catalog | pg_stat_all_indexes | view | gpadmin | none
pg_catalog | pg_stat_all_tables | view | gpadmin | none
pg_catalog | pg_stat_database | view | gpadmin | none
pg_catalog | pg_stat_operations | view | gpadmin | none
pg_catalog | pg_stat_partition_operations | view | gpadmin | none
pg_catalog | pg_stat_resqueues | view | gpadmin | none
pg_catalog | pg_stat_sys_indexes | view | gpadmin | none
pg_catalog | pg_stat_sys_tables | view | gpadmin | none
pg_catalog | pg_stat_user_indexes | view | gpadmin | none
pg_catalog | pg_stat_user_tables | view | gpadmin | none
pg_catalog | pg_statio_all_indexes | view | gpadmin | none
pg_catalog | pg_statio_all_sequences | view | gpadmin | none
pg_catalog | pg_statio_all_tables | view | gpadmin | none
pg_catalog | pg_statio_sys_indexes | view | gpadmin | none
pg_catalog | pg_statio_sys_sequences | view | gpadmin | none
pg_catalog | pg_statio_sys_tables | view | gpadmin | none
pg_catalog | pg_statio_user_indexes | view | gpadmin | none
pg_catalog | pg_statio_user_sequences | view | gpadmin | none
pg_catalog | pg_statio_user_tables | view | gpadmin | none
pg_catalog | pg_stats | view | gpadmin | none
pg_catalog | pg_tables | view | gpadmin | none
pg_catalog | pg_timezone_abbrevs | view | gpadmin | none
pg_catalog | pg_timezone_names | view | gpadmin | none
pg_catalog | pg_user | view | gpadmin | none
pg_catalog | pg_user_mappings | view | gpadmin | none
pg_catalog | pg_views | view | gpadmin | none
(47 rows)

sachi=> \df pg_catalog.*

Schema | Name | Result data type | Argument data types | Type
------------+-----------------------------------------------+-----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------
pg_catalog | RI_FKey_cascade_del | trigger | | trigger
pg_catalog | RI_FKey_cascade_upd | trigger | | trigger
pg_catalog | RI_FKey_check_ins | trigger | | trigger
pg_catalog | RI_FKey_check_upd | trigger | | trigger
pg_catalog | RI_FKey_noaction_del | trigger | | trigger
pg_catalog | RI_FKey_noaction_upd | trigger | | trigger
pg_catalog | RI_FKey_restrict_del | trigger | | trigger
pg_catalog | RI_FKey_restrict_upd | trigger | | trigger
pg_catalog | RI_FKey_setdefault_del | trigger | | trigger
pg_catalog | RI_FKey_setdefault_upd | trigger | | trigger
pg_catalog | RI_FKey_setnull_del | trigger | | trigger
pg_catalog | RI_FKey_setnull_upd | trigger | | trigger
pg_catalog | abbrev | text | cidr | normal
pg_catalog | abbrev | text | inet | normal
pg_catalog | abs | bigint | bigint | normal
pg_catalog | abs | double precision | double precision | normal
pg_catalog | abs | integer | integer | normal
pg_catalog | abs | numeric | numeric | normal
pg_catalog | abs | real | real | normal
pg_catalog | abs | smallint | smallint | normal
pg_catalog | abstime | abstime | timestamp without time zone | normal
pg_catalog | abstime | abstime | timestamp with time zone | normal
pg_catalog | abstimeeq | boolean | abstime, abstime | normal
pg_catalog | abstimege | boolean | abstime, abstime | normal
pg_catalog | abstimegt | boolean | abstime, abstime | normal
pg_catalog | abstimein | abstime | cstring | normal
pg_catalog | abstimele | boolean | abstime, abstime | normal
pg_catalog | abstimelt | boolean | abstime, abstime | normal
pg_catalog | abstimene | boolean | abstime, abstime | normal
pg_catalog | abstimeout | cstring | abstime | normal
pg_catalog | abstimerecv | abstime | internal | normal
pg_catalog | abstimesend | bytea | abstime | normal
pg_catalog | aclcontains | boolean | aclitem[], aclitem | normal
pg_catalog | aclinsert | aclitem[] | aclitem[], aclitem | normal
pg_catalog | aclitemeq | boolean | aclitem, aclitem | normal
pg_catalog | aclitemin | aclitem | cstring | normal
pg_catalog | aclitemout | cstring | aclitem | normal
pg_catalog | aclremove | aclitem[] | aclitem[], aclitem | normal
pg_catalog | acos | double precision | double precision | normal
pg_catalog | age | interval | timestamp without time zone | normal
pg_catalog | age | interval | timestamp without time zone, timestamp without time zone | normal
pg_catalog | age | interval | timestamp with time zone | normal
pg_catalog | age | interval | timestamp with time zone, timestamp with time zone | normal
pg_catalog | age | integer | xid | normal
pg_catalog | any_in | "any" | cstring | normal
pg_catalog | any_out | cstring | "any" | normal
pg_catalog | anyarray_in | anyarray | cstring | normal
pg_catalog | anyarray_out | cstring | anyarray | normal
pg_catalog | anyarray_recv | anyarray | internal | normal
pg_catalog | anyarray_send | bytea | anyarray | normal
pg_catalog | anyelement_in | anyelement | cstring | normal
pg_catalog | anyelement_out | cstring | anyelement | normal
pg_catalog | anytable_in | anytable | cstring | normal
pg_catalog | anytable_out | cstring | anytable | normal
pg_catalog | aocsvpinfo_decode | bigint | bit varying, integer, integer | normal
pg_catalog | area | double precision | box | normal
pg_catalog | area | double precision | circle | normal
pg_catalog | area | double precision | path | normal
pg_catalog | areajoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | areasel | double precision | internal, oid, internal, integer | normal
pg_catalog | array_add | integer[] | integer[], integer[] | normal
pg_catalog | array_agg | anyarray | anyelement | agg
pg_catalog | array_agg_finalfn | anyarray | internal | normal
pg_catalog | array_agg_transfn | internal | internal, anyelement | normal
pg_catalog | array_append | anyarray | anyarray, anyelement | normal
pg_catalog | array_cat | anyarray | anyarray, anyarray | normal
pg_catalog | array_coerce | anyarray | anyarray | normal
pg_catalog | array_dims | text | anyarray | normal
pg_catalog | array_eq | boolean | anyarray, anyarray | normal
pg_catalog | array_ge | boolean | anyarray, anyarray | normal
pg_catalog | array_gt | boolean | anyarray, anyarray | normal
pg_catalog | array_in | anyarray | cstring, oid, integer | normal
pg_catalog | array_larger | anyarray | anyarray, anyarray | normal
pg_catalog | array_le | boolean | anyarray, anyarray | normal
pg_catalog | array_length_coerce | anyarray | anyarray, integer, boolean | normal
pg_catalog | array_lower | integer | anyarray, integer | normal
pg_catalog | array_lt | boolean | anyarray, anyarray | normal
pg_catalog | array_ne | boolean | anyarray, anyarray | normal
pg_catalog | array_out | cstring | anyarray | normal
pg_catalog | array_prepend | anyarray | anyelement, anyarray | normal
pg_catalog | array_recv | anyarray | internal, oid, integer | normal
pg_catalog | array_send | bytea | anyarray | normal
pg_catalog | array_smaller | anyarray | anyarray, anyarray | normal
pg_catalog | array_sum | integer[] | integer[] | agg
pg_catalog | array_to_string | text | anyarray, text | normal
pg_catalog | array_type_length_coerce | anyarray | anyarray, integer, boolean | normal
pg_catalog | array_upper | integer | anyarray, integer | normal
pg_catalog | arraycontained | boolean | anyarray, anyarray | normal
pg_catalog | arraycontains | boolean | anyarray, anyarray | normal
pg_catalog | arrayoverlap | boolean | anyarray, anyarray | normal
pg_catalog | ascii | integer | text | normal
pg_catalog | ascii_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | ascii_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | asin | double precision | double precision | normal
pg_catalog | atan | double precision | double precision | normal
pg_catalog | atan2 | double precision | double precision, double precision | normal
pg_catalog | avg | numeric | bigint | agg
pg_catalog | avg | double precision | double precision | agg
pg_catalog | avg | numeric | integer | agg
pg_catalog | avg | interval | interval | agg
pg_catalog | avg | numeric | numeric | agg
pg_catalog | avg | double precision | real | agg
pg_catalog | avg | numeric | smallint | agg
pg_catalog | big5_to_euc_tw | void | integer, integer, cstring, internal, integer | normal
pg_catalog | big5_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | big5_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | bit | bit | bigint, integer | normal
pg_catalog | bit | bit | bit, integer, boolean | normal
pg_catalog | bit | bit | integer, integer | normal
pg_catalog | bit_and | bigint | bigint | agg
pg_catalog | bit_and | bit | bit | agg
pg_catalog | bit_and | integer | integer | agg
pg_catalog | bit_and | smallint | smallint | agg
pg_catalog | bit_in | bit | cstring, oid, integer | normal
pg_catalog | bit_length | integer | bit | normal
pg_catalog | bit_length | integer | bytea | normal
pg_catalog | bit_length | integer | text | normal
pg_catalog | bit_or | bigint | bigint | agg
pg_catalog | bit_or | bit | bit | agg
pg_catalog | bit_or | integer | integer | agg
pg_catalog | bit_or | smallint | smallint | agg
pg_catalog | bit_out | cstring | bit | normal
pg_catalog | bit_recv | bit | internal, oid, integer | normal
pg_catalog | bit_send | bytea | bit | normal
pg_catalog | bitand | bit | bit, bit | normal
pg_catalog | bitcat | bit | bit, bit | normal
pg_catalog | bitcmp | integer | bit, bit | normal
pg_catalog | biteq | boolean | bit, bit | normal
pg_catalog | bitge | boolean | bit, bit | normal
pg_catalog | bitgt | boolean | bit, bit | normal
pg_catalog | bitle | boolean | bit, bit | normal
pg_catalog | bitlt | boolean | bit, bit | normal
pg_catalog | bitne | boolean | bit, bit | normal
pg_catalog | bitnot | bit | bit | normal
pg_catalog | bitor | bit | bit, bit | normal
pg_catalog | bitshiftleft | bit | bit, integer | normal
pg_catalog | bitshiftright | bit | bit, integer | normal
pg_catalog | bitxor | bit | bit, bit | normal
pg_catalog | bmbeginscan | internal | internal, internal, internal | normal
pg_catalog | bmbuild | internal | internal, internal, internal | normal
pg_catalog | bmbulkdelete | internal | internal, internal, internal, internal | normal
pg_catalog | bmcostestimate | void | internal, internal, internal, internal, internal, internal, internal, internal | normal
pg_catalog | bmendscan | void | internal | normal
pg_catalog | bmgetmulti | internal | internal, internal | normal
pg_catalog | bmgettuple | boolean | internal, internal | normal
pg_catalog | bminsert | boolean | internal, internal, internal, internal, internal, internal | normal
pg_catalog | bmmarkpos | void | internal | normal
pg_catalog | bmoptions | bytea | text[], boolean | normal
pg_catalog | bmrescan | void | internal, internal | normal
pg_catalog | bmrestrpos | void | internal | normal
pg_catalog | bmvacuumcleanup | internal | internal, internal | normal
pg_catalog | bool | boolean | integer | normal
pg_catalog | bool_and | boolean | boolean | agg
pg_catalog | bool_or | boolean | boolean | agg
pg_catalog | booland_statefunc | boolean | boolean, boolean | normal
pg_catalog | booleq | boolean | boolean, boolean | normal
pg_catalog | boolge | boolean | boolean, boolean | normal
pg_catalog | boolgt | boolean | boolean, boolean | normal
pg_catalog | boolin | boolean | cstring | normal
pg_catalog | boolle | boolean | boolean, boolean | normal
pg_catalog | boollt | boolean | boolean, boolean | normal
pg_catalog | boolne | boolean | boolean, boolean | normal
pg_catalog | boolor_statefunc | boolean | boolean, boolean | normal
pg_catalog | boolout | cstring | boolean | normal
pg_catalog | boolrecv | boolean | internal | normal
pg_catalog | boolsend | bytea | boolean | normal
pg_catalog | box | box | circle | normal
pg_catalog | box | box | point, point | normal
pg_catalog | box | box | polygon | normal
pg_catalog | box_above | boolean | box, box | normal
pg_catalog | box_above_eq | boolean | box, box | normal
pg_catalog | box_add | box | box, point | normal
pg_catalog | box_below | boolean | box, box | normal
pg_catalog | box_below_eq | boolean | box, box | normal
pg_catalog | box_center | point | box | normal
pg_catalog | box_contain | boolean | box, box | normal
pg_catalog | box_contained | boolean | box, box | normal
pg_catalog | box_distance | double precision | box, box | normal
pg_catalog | box_div | box | box, point | normal
pg_catalog | box_eq | boolean | box, box | normal
pg_catalog | box_ge | boolean | box, box | normal
pg_catalog | box_gt | boolean | box, box | normal
pg_catalog | box_in | box | cstring | normal
pg_catalog | box_intersect | box | box, box | normal
pg_catalog | box_le | boolean | box, box | normal
pg_catalog | box_left | boolean | box, box | normal
pg_catalog | box_lt | boolean | box, box | normal
pg_catalog | box_mul | box | box, point | normal
pg_catalog | box_out | cstring | box | normal
pg_catalog | box_overabove | boolean | box, box | normal
pg_catalog | box_overbelow | boolean | box, box | normal
pg_catalog | box_overlap | boolean | box, box | normal
pg_catalog | box_overleft | boolean | box, box | normal
pg_catalog | box_overright | boolean | box, box | normal
pg_catalog | box_recv | box | internal | normal
pg_catalog | box_right | boolean | box, box | normal
pg_catalog | box_same | boolean | box, box | normal
pg_catalog | box_send | bytea | box | normal
pg_catalog | box_sub | box | box, point | normal
pg_catalog | bpchar | character | "char" | normal
pg_catalog | bpchar | character | character, integer, boolean | normal
pg_catalog | bpchar | character | name | normal
pg_catalog | bpchar_larger | character | character, character | normal
pg_catalog | bpchar_pattern_eq | boolean | character, character | normal
pg_catalog | bpchar_pattern_ge | boolean | character, character | normal
pg_catalog | bpchar_pattern_gt | boolean | character, character | normal
pg_catalog | bpchar_pattern_le | boolean | character, character | normal
pg_catalog | bpchar_pattern_lt | boolean | character, character | normal
pg_catalog | bpchar_pattern_ne | boolean | character, character | normal
pg_catalog | bpchar_smaller | character | character, character | normal
pg_catalog | bpcharcmp | integer | character, character | normal
pg_catalog | bpchareq | boolean | character, character | normal
pg_catalog | bpcharge | boolean | character, character | normal
pg_catalog | bpchargt | boolean | character, character | normal
pg_catalog | bpchariclike | boolean | character, text | normal
pg_catalog | bpcharicnlike | boolean | character, text | normal
pg_catalog | bpcharicregexeq | boolean | character, text | normal
pg_catalog | bpcharicregexne | boolean | character, text | normal
pg_catalog | bpcharin | character | cstring, oid, integer | normal
pg_catalog | bpcharle | boolean | character, character | normal
pg_catalog | bpcharlike | boolean | character, text | normal
pg_catalog | bpcharlt | boolean | character, character | normal
pg_catalog | bpcharne | boolean | character, character | normal
pg_catalog | bpcharnlike | boolean | character, text | normal
pg_catalog | bpcharout | cstring | character | normal
pg_catalog | bpcharrecv | character | internal, oid, integer | normal
pg_catalog | bpcharregexeq | boolean | character, text | normal
pg_catalog | bpcharregexne | boolean | character, text | normal
pg_catalog | bpcharsend | bytea | character | normal
pg_catalog | broadcast | inet | inet | normal
pg_catalog | btabstimecmp | integer | abstime, abstime | normal
pg_catalog | btarraycmp | integer | anyarray, anyarray | normal
pg_catalog | btbeginscan | internal | internal, internal, internal | normal
pg_catalog | btboolcmp | integer | boolean, boolean | normal
pg_catalog | btbpchar_pattern_cmp | integer | character, character | normal
pg_catalog | btbuild | internal | internal, internal, internal | normal
pg_catalog | btbulkdelete | internal | internal, internal, internal, internal | normal
pg_catalog | btcharcmp | integer | "char", "char" | normal
pg_catalog | btcostestimate | void | internal, internal, internal, internal, internal, internal, internal, internal | normal
pg_catalog | btendscan | void | internal | normal
pg_catalog | btfloat48cmp | integer | real, double precision | normal
pg_catalog | btfloat4cmp | integer | real, real | normal
pg_catalog | btfloat84cmp | integer | double precision, real | normal
pg_catalog | btfloat8cmp | integer | double precision, double precision | normal
pg_catalog | btgetmulti | internal | internal, internal | normal
pg_catalog | btgettuple | boolean | internal, internal | normal
pg_catalog | btgpxlogloccmp | integer | gpxlogloc, gpxlogloc | normal
pg_catalog | btinsert | boolean | internal, internal, internal, internal, internal, internal | normal
pg_catalog | btint24cmp | integer | smallint, integer | normal
pg_catalog | btint28cmp | integer | smallint, bigint | normal
pg_catalog | btint2cmp | integer | smallint, smallint | normal
pg_catalog | btint42cmp | integer | integer, smallint | normal
pg_catalog | btint48cmp | integer | integer, bigint | normal
pg_catalog | btint4cmp | integer | integer, integer | normal
pg_catalog | btint82cmp | integer | bigint, smallint | normal
pg_catalog | btint84cmp | integer | bigint, integer | normal
pg_catalog | btint8cmp | integer | bigint, bigint | normal
pg_catalog | btmarkpos | void | internal | normal
pg_catalog | btname_pattern_cmp | integer | name, name | normal
pg_catalog | btnamecmp | integer | name, name | normal
pg_catalog | btoidcmp | integer | oid, oid | normal
pg_catalog | btoidvectorcmp | integer | oidvector, oidvector | normal
pg_catalog | btoptions | bytea | text[], boolean | normal
pg_catalog | btreltimecmp | integer | reltime, reltime | normal
pg_catalog | btrescan | void | internal, internal | normal
pg_catalog | btrestrpos | void | internal | normal
pg_catalog | btrim | bytea | bytea, bytea | normal
pg_catalog | btrim | text | text | normal
pg_catalog | btrim | text | text, text | normal
pg_catalog | bttext_pattern_cmp | integer | text, text | normal
pg_catalog | bttextcmp | integer | text, text | normal
pg_catalog | bttidcmp | integer | tid, tid | normal
pg_catalog | bttintervalcmp | integer | tinterval, tinterval | normal
pg_catalog | btvacuumcleanup | internal | internal, internal | normal
pg_catalog | byteacat | bytea | bytea, bytea | normal
pg_catalog | byteacmp | integer | bytea, bytea | normal
pg_catalog | byteaeq | boolean | bytea, bytea | normal
pg_catalog | byteage | boolean | bytea, bytea | normal
pg_catalog | byteagt | boolean | bytea, bytea | normal
pg_catalog | byteain | bytea | cstring | normal
pg_catalog | byteale | boolean | bytea, bytea | normal
pg_catalog | bytealike | boolean | bytea, bytea | normal
pg_catalog | bytealt | boolean | bytea, bytea | normal
pg_catalog | byteane | boolean | bytea, bytea | normal
pg_catalog | byteanlike | boolean | bytea, bytea | normal
pg_catalog | byteaout | cstring | bytea | normal
pg_catalog | bytearecv | bytea | internal | normal
pg_catalog | byteasend | bytea | bytea | normal
pg_catalog | cash_cmp | integer | money, money | normal
pg_catalog | cash_div_flt4 | money | money, real | normal
pg_catalog | cash_div_flt8 | money | money, double precision | normal
pg_catalog | cash_div_int2 | money | money, smallint | normal
pg_catalog | cash_div_int4 | money | money, integer | normal
pg_catalog | cash_eq | boolean | money, money | normal
pg_catalog | cash_ge | boolean | money, money | normal
pg_catalog | cash_gt | boolean | money, money | normal
pg_catalog | cash_in | money | cstring | normal
pg_catalog | cash_le | boolean | money, money | normal
pg_catalog | cash_lt | boolean | money, money | normal
pg_catalog | cash_mi | money | money, money | normal
pg_catalog | cash_mul_flt4 | money | money, real | normal
pg_catalog | cash_mul_flt8 | money | money, double precision | normal
pg_catalog | cash_mul_int2 | money | money, smallint | normal
pg_catalog | cash_mul_int4 | money | money, integer | normal
pg_catalog | cash_ne | boolean | money, money | normal
pg_catalog | cash_out | cstring | money | normal
pg_catalog | cash_pl | money | money, money | normal
pg_catalog | cash_recv | money | internal | normal
pg_catalog | cash_send | bytea | money | normal
pg_catalog | cash_words | text | money | normal
pg_catalog | cashlarger | money | money, money | normal
pg_catalog | cashsmaller | money | money, money | normal
pg_catalog | cbrt | double precision | double precision | normal
pg_catalog | ceil | double precision | double precision | normal
pg_catalog | ceil | numeric | numeric | normal
pg_catalog | ceiling | double precision | double precision | normal
pg_catalog | ceiling | numeric | numeric | normal
pg_catalog | center | point | box | normal
pg_catalog | center | point | circle | normal
pg_catalog | char | "char" | integer | normal
pg_catalog | char | "char" | text | normal
pg_catalog | char_length | integer | character | normal
pg_catalog | char_length | integer | text | normal
pg_catalog | character_length | integer | character | normal
pg_catalog | character_length | integer | text | normal
pg_catalog | chareq | boolean | "char", "char" | normal
pg_catalog | charge | boolean | "char", "char" | normal
pg_catalog | chargt | boolean | "char", "char" | normal
pg_catalog | charin | "char" | cstring | normal
pg_catalog | charle | boolean | "char", "char" | normal
pg_catalog | charlt | boolean | "char", "char" | normal
pg_catalog | charne | boolean | "char", "char" | normal
pg_catalog | charout | cstring | "char" | normal
pg_catalog | charrecv | "char" | internal | normal
pg_catalog | charsend | bytea | "char" | normal
pg_catalog | chr | text | integer | normal
pg_catalog | cideq | boolean | cid, cid | normal
pg_catalog | cidin | cid | cstring | normal
pg_catalog | cidout | cstring | cid | normal
pg_catalog | cidr | cidr | inet | normal
pg_catalog | cidr | cidr | text | normal
pg_catalog | cidr_in | cidr | cstring | normal
pg_catalog | cidr_out | cstring | cidr | normal
pg_catalog | cidr_recv | cidr | internal | normal
pg_catalog | cidr_send | bytea | cidr | normal
pg_catalog | cidrecv | cid | internal | normal
pg_catalog | cidsend | bytea | cid | normal
pg_catalog | circle | circle | box | normal
pg_catalog | circle | circle | point, double precision | normal
pg_catalog | circle | circle | polygon | normal
pg_catalog | circle_above | boolean | circle, circle | normal
pg_catalog | circle_add_pt | circle | circle, point | normal
pg_catalog | circle_below | boolean | circle, circle | normal
pg_catalog | circle_center | point | circle | normal
pg_catalog | circle_contain | boolean | circle, circle | normal
pg_catalog | circle_contain_pt | boolean | circle, point | normal
pg_catalog | circle_contained | boolean | circle, circle | normal
pg_catalog | circle_distance | double precision | circle, circle | normal
pg_catalog | circle_div_pt | circle | circle, point | normal
pg_catalog | circle_eq | boolean | circle, circle | normal
pg_catalog | circle_ge | boolean | circle, circle | normal
pg_catalog | circle_gt | boolean | circle, circle | normal
pg_catalog | circle_in | circle | cstring | normal
pg_catalog | circle_le | boolean | circle, circle | normal
pg_catalog | circle_left | boolean | circle, circle | normal
pg_catalog | circle_lt | boolean | circle, circle | normal
pg_catalog | circle_mul_pt | circle | circle, point | normal
pg_catalog | circle_ne | boolean | circle, circle | normal
pg_catalog | circle_out | cstring | circle | normal
pg_catalog | circle_overabove | boolean | circle, circle | normal
pg_catalog | circle_overbelow | boolean | circle, circle | normal
pg_catalog | circle_overlap | boolean | circle, circle | normal
pg_catalog | circle_overleft | boolean | circle, circle | normal
pg_catalog | circle_overright | boolean | circle, circle | normal
pg_catalog | circle_recv | circle | internal | normal
pg_catalog | circle_right | boolean | circle, circle | normal
pg_catalog | circle_same | boolean | circle, circle | normal
pg_catalog | circle_send | bytea | circle | normal
pg_catalog | circle_sub_pt | circle | circle, point | normal
pg_catalog | clock_timestamp | timestamp with time zone | | normal
pg_catalog | close_lb | point | line, box | normal
pg_catalog | close_ls | point | line, lseg | normal
pg_catalog | close_lseg | point | lseg, lseg | normal
pg_catalog | close_pb | point | point, box | normal
pg_catalog | close_pl | point | point, line | normal
pg_catalog | close_ps | point | point, lseg | normal
pg_catalog | close_sb | point | lseg, box | normal
pg_catalog | close_sl | point | lseg, line | normal
pg_catalog | col_description | text | oid, integer | normal
pg_catalog | contjoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | contsel | double precision | internal, oid, internal, integer | normal
pg_catalog | convert | text | text, name | normal
pg_catalog | convert | text | text, name, name | normal
pg_catalog | convert_using | text | text, text | normal
pg_catalog | corr | double precision | double precision, double precision | agg
pg_catalog | cos | double precision | double precision | normal
pg_catalog | cosh | double precision | double precision | normal
pg_catalog | cot | double precision | double precision | normal
pg_catalog | count | bigint | "any" | agg
pg_catalog | count | bigint | | agg
pg_catalog | covar_pop | double precision | double precision, double precision | agg
pg_catalog | covar_samp | double precision | double precision, double precision | agg
pg_catalog | cstring_in | cstring | cstring | normal
pg_catalog | cstring_out | cstring | cstring | normal
pg_catalog | cstring_recv | cstring | internal | normal
pg_catalog | cstring_send | bytea | cstring | normal
pg_catalog | cume_dist | double precision | | normal
pg_catalog | cume_dist_final | double precision | bigint, bigint | normal
pg_catalog | cume_dist_prelim | bigint | internal | normal
pg_catalog | current_database | name | | normal
pg_catalog | current_query | text | | normal
pg_catalog | current_schema | name | | normal
pg_catalog | current_schemas | name[] | boolean | normal
pg_catalog | current_setting | text | text | normal
pg_catalog | current_user | name | | normal
pg_catalog | currtid | tid | oid, tid | normal
pg_catalog | currtid2 | tid | text, tid | normal
pg_catalog | currval | bigint | regclass | normal
pg_catalog | date | date | abstime | normal
pg_catalog | date | date | text | normal
pg_catalog | date | date | timestamp without time zone | normal
pg_catalog | date | date | timestamp with time zone | normal
pg_catalog | date_cmp | integer | date, date | normal
pg_catalog | date_cmp_timestamp | integer | date, timestamp without time zone | normal
pg_catalog | date_cmp_timestamptz | integer | date, timestamp with time zone | normal
pg_catalog | date_eq | boolean | date, date | normal
pg_catalog | date_eq_timestamp | boolean | date, timestamp without time zone | normal
pg_catalog | date_eq_timestamptz | boolean | date, timestamp with time zone | normal
pg_catalog | date_ge | boolean | date, date | normal
pg_catalog | date_ge_timestamp | boolean | date, timestamp without time zone | normal
pg_catalog | date_ge_timestamptz | boolean | date, timestamp with time zone | normal
pg_catalog | date_gt | boolean | date, date | normal
pg_catalog | date_gt_timestamp | boolean | date, timestamp without time zone | normal
pg_catalog | date_gt_timestamptz | boolean | date, timestamp with time zone | normal
pg_catalog | date_in | date | cstring | normal
pg_catalog | date_larger | date | date, date | normal
pg_catalog | date_le | boolean | date, date | normal
pg_catalog | date_le_timestamp | boolean | date, timestamp without time zone | normal
pg_catalog | date_le_timestamptz | boolean | date, timestamp with time zone | normal
pg_catalog | date_lt | boolean | date, date | normal
pg_catalog | date_lt_timestamp | boolean | date, timestamp without time zone | normal
pg_catalog | date_lt_timestamptz | boolean | date, timestamp with time zone | normal
pg_catalog | date_mi | integer | date, date | normal
pg_catalog | date_mi_interval | timestamp without time zone | date, interval | normal
pg_catalog | date_mii | date | date, integer | normal
pg_catalog | date_ne | boolean | date, date | normal
pg_catalog | date_ne_timestamp | boolean | date, timestamp without time zone | normal
pg_catalog | date_ne_timestamptz | boolean | date, timestamp with time zone | normal
pg_catalog | date_out | cstring | date | normal
pg_catalog | date_part | double precision | text, abstime | normal
pg_catalog | date_part | double precision | text, date | normal
pg_catalog | date_part | double precision | text, interval | normal
pg_catalog | date_part | double precision | text, reltime | normal
pg_catalog | date_part | double precision | text, timestamp without time zone | normal
pg_catalog | date_part | double precision | text, timestamp with time zone | normal
pg_catalog | date_part | double precision | text, time without time zone | normal
pg_catalog | date_part | double precision | text, time with time zone | normal
pg_catalog | date_pl_interval | timestamp without time zone | date, interval | normal
pg_catalog | date_pli | date | date, integer | normal
pg_catalog | date_recv | date | internal | normal
pg_catalog | date_send | bytea | date | normal
pg_catalog | date_smaller | date | date, date | normal
pg_catalog | date_trunc | interval | text, interval | normal
pg_catalog | date_trunc | timestamp without time zone | text, timestamp without time zone | normal
pg_catalog | date_trunc | timestamp with time zone | text, timestamp with time zone | normal
pg_catalog | datetime_pl | timestamp without time zone | date, time without time zone | normal
pg_catalog | datetimetz_pl | timestamp with time zone | date, time with time zone | normal
pg_catalog | dcbrt | double precision | double precision | normal
pg_catalog | decode | bytea | text, text | normal
pg_catalog | degrees | double precision | double precision | normal
pg_catalog | dense_rank | bigint | | normal
pg_catalog | dense_rank_immed | bigint | internal | normal
pg_catalog | dexp | double precision | double precision | normal
pg_catalog | diagonal | lseg | box | normal
pg_catalog | diameter | double precision | circle | normal
pg_catalog | dist_cpoly | double precision | circle, polygon | normal
pg_catalog | dist_lb | double precision | line, box | normal
pg_catalog | dist_pb | double precision | point, box | normal
pg_catalog | dist_pc | double precision | point, circle | normal
pg_catalog | dist_pl | double precision | point, line | normal
pg_catalog | dist_ppath | double precision | point, path | normal
pg_catalog | dist_ps | double precision | point, lseg | normal
pg_catalog | dist_sb | double precision | lseg, box | normal
pg_catalog | dist_sl | double precision | lseg, line | normal
pg_catalog | dlog1 | double precision | double precision | normal
pg_catalog | dlog10 | double precision | double precision | normal
pg_catalog | domain_in | "any" | cstring, oid, integer | normal
pg_catalog | domain_recv | "any" | internal, oid, integer | normal
pg_catalog | dpow | double precision | double precision, double precision | normal
pg_catalog | dround | double precision | double precision | normal
pg_catalog | dsqrt | double precision | double precision | normal
pg_catalog | dtrunc | double precision | double precision | normal
pg_catalog | encode | text | bytea, text | normal
pg_catalog | eqjoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | eqsel | double precision | internal, oid, internal, integer | normal
pg_catalog | euc_cn_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_cn_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_jis_2004_to_shift_jis_2004 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_jis_2004_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_jp_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_jp_to_sjis | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_jp_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_kr_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_kr_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_tw_to_big5 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_tw_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | euc_tw_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | every | boolean | boolean | agg
pg_catalog | exp | double precision | double precision | normal
pg_catalog | exp | numeric | numeric | normal
pg_catalog | factorial | numeric | bigint | normal
pg_catalog | family | integer | inet | normal
pg_catalog | first_value | anyarray | anyarray | normal
pg_catalog | first_value | bigint | bigint | normal
pg_catalog | first_value | bit | bit | normal
pg_catalog | first_value | bit varying | bit varying | normal
pg_catalog | first_value | boolean | boolean | normal
pg_catalog | first_value | box | box | normal
pg_catalog | first_value | bytea | bytea | normal
pg_catalog | first_value | "char" | "char" | normal
pg_catalog | first_value | character varying | character varying | normal
pg_catalog | first_value | cidr | cidr | normal
pg_catalog | first_value | circle | circle | normal
pg_catalog | first_value | double precision | double precision | normal
pg_catalog | first_value | inet | inet | normal
pg_catalog | first_value | integer | integer | normal
pg_catalog | first_value | interval | interval | normal
pg_catalog | first_value | line | line | normal
pg_catalog | first_value | lseg | lseg | normal
pg_catalog | first_value | macaddr | macaddr | normal
pg_catalog | first_value | money | money | normal
pg_catalog | first_value | name | name | normal
pg_catalog | first_value | numeric | numeric | normal
pg_catalog | first_value | oid | oid | normal
pg_catalog | first_value | path | path | normal
pg_catalog | first_value | point | point | normal
pg_catalog | first_value | polygon | polygon | normal
pg_catalog | first_value | real | real | normal
pg_catalog | first_value | reltime | reltime | normal
pg_catalog | first_value | smallint | smallint | normal
pg_catalog | first_value | text | text | normal
pg_catalog | first_value | tid | tid | normal
pg_catalog | first_value | timestamp without time zone | timestamp without time zone | normal
pg_catalog | first_value | timestamp with time zone | timestamp with time zone | normal
pg_catalog | first_value | time without time zone | time without time zone | normal
pg_catalog | first_value | time with time zone | time with time zone | normal
pg_catalog | first_value | xid | xid | normal
pg_catalog | first_value_any | anyarray | internal, anyarray | normal
pg_catalog | first_value_bit | bit | internal, bit | normal
pg_catalog | first_value_bool | boolean | internal, boolean | normal
pg_catalog | first_value_box | box | internal, box | normal
pg_catalog | first_value_bytea | bytea | internal, bytea | normal
pg_catalog | first_value_char | "char" | internal, "char" | normal
pg_catalog | first_value_cidr | cidr | internal, cidr | normal
pg_catalog | first_value_circle | circle | internal, circle | normal
pg_catalog | first_value_float4 | real | internal, real | normal
pg_catalog | first_value_float8 | double precision | internal, double precision | normal
pg_catalog | first_value_inet | inet | internal, inet | normal
pg_catalog | first_value_int4 | integer | internal, integer | normal
pg_catalog | first_value_int8 | bigint | internal, bigint | normal
pg_catalog | first_value_interval | interval | internal, interval | normal
pg_catalog | first_value_line | line | internal, line | normal
pg_catalog | first_value_lseg | lseg | internal, lseg | normal
pg_catalog | first_value_macaddr | macaddr | internal, macaddr | normal
pg_catalog | first_value_money | money | internal, money | normal
pg_catalog | first_value_name | name | internal, name | normal
pg_catalog | first_value_numeric | numeric | internal, numeric | normal
pg_catalog | first_value_oid | oid | internal, oid | normal
pg_catalog | first_value_path | path | internal, path | normal
pg_catalog | first_value_point | point | internal, point | normal
pg_catalog | first_value_polygon | polygon | internal, polygon | normal
pg_catalog | first_value_reltime | reltime | internal, reltime | normal
pg_catalog | first_value_smallint | smallint | internal, smallint | normal
pg_catalog | first_value_text | text | internal, text | normal
pg_catalog | first_value_tid | tid | internal, tid | normal
pg_catalog | first_value_time | time without time zone | internal, time without time zone | normal
pg_catalog | first_value_timestamp | timestamp without time zone | internal, timestamp without time zone | normal
pg_catalog | first_value_timestamptz | timestamp with time zone | internal, timestamp with time zone | normal
pg_catalog | first_value_timetz | time with time zone | internal, time with time zone | normal
pg_catalog | first_value_varbit | bit varying | internal, bit varying | normal
pg_catalog | first_value_varchar | character varying | internal, character varying | normal
pg_catalog | first_value_xid | xid | internal, xid | normal
pg_catalog | fixedwidth_in | record | | normal
pg_catalog | fixedwidth_out | bytea | record | normal
pg_catalog | flatfile_update_trigger | trigger | | trigger
pg_catalog | float4 | real | bigint | normal
pg_catalog | float4 | real | double precision | normal
pg_catalog | float4 | real | integer | normal
pg_catalog | float4 | real | numeric | normal
pg_catalog | float4 | real | smallint | normal
pg_catalog | float4 | real | text | normal
pg_catalog | float48div | double precision | real, double precision | normal
pg_catalog | float48eq | boolean | real, double precision | normal
pg_catalog | float48ge | boolean | real, double precision | normal
pg_catalog | float48gt | boolean | real, double precision | normal
pg_catalog | float48le | boolean | real, double precision | normal
pg_catalog | float48lt | boolean | real, double precision | normal
pg_catalog | float48mi | double precision | real, double precision | normal
pg_catalog | float48mul | double precision | real, double precision | normal
pg_catalog | float48ne | boolean | real, double precision | normal
pg_catalog | float48pl | double precision | real, double precision | normal
pg_catalog | float4_accum | double precision[] | double precision[], real | normal
pg_catalog | float4_avg_accum | bytea | bytea, real | normal
pg_catalog | float4_avg_decum | bytea | bytea, real | normal
pg_catalog | float4_decum | double precision[] | double precision[], real | normal
pg_catalog | float4abs | real | real | normal
pg_catalog | float4div | real | real, real | normal
pg_catalog | float4eq | boolean | real, real | normal
pg_catalog | float4ge | boolean | real, real | normal
pg_catalog | float4gt | boolean | real, real | normal
pg_catalog | float4in | real | cstring | normal
pg_catalog | float4larger | real | real, real | normal
pg_catalog | float4le | boolean | real, real | normal
pg_catalog | float4lt | boolean | real, real | normal
pg_catalog | float4mi | real | real, real | normal
pg_catalog | float4mul | real | real, real | normal
pg_catalog | float4ne | boolean | real, real | normal
pg_catalog | float4out | cstring | real | normal
pg_catalog | float4pl | real | real, real | normal
pg_catalog | float4recv | real | internal | normal
pg_catalog | float4send | bytea | real | normal
pg_catalog | float4smaller | real | real, real | normal
pg_catalog | float4um | real | real | normal
pg_catalog | float4up | real | real | normal
pg_catalog | float8 | double precision | bigint | normal
pg_catalog | float8 | double precision | integer | normal
pg_catalog | float8 | double precision | numeric | normal
pg_catalog | float8 | double precision | real | normal
pg_catalog | float8 | double precision | smallint | normal
pg_catalog | float8 | double precision | text | normal
pg_catalog | float84div | double precision | double precision, real | normal
pg_catalog | float84eq | boolean | double precision, real | normal
pg_catalog | float84ge | boolean | double precision, real | normal
pg_catalog | float84gt | boolean | double precision, real | normal
pg_catalog | float84le | boolean | double precision, real | normal
pg_catalog | float84lt | boolean | double precision, real | normal
pg_catalog | float84mi | double precision | double precision, real | normal
pg_catalog | float84mul | double precision | double precision, real | normal
pg_catalog | float84ne | boolean | double precision, real | normal
pg_catalog | float84pl | double precision | double precision, real | normal
pg_catalog | float8_accum | double precision[] | double precision[], double precision | normal
pg_catalog | float8_amalg | double precision[] | double precision[], double precision[] | normal
pg_catalog | float8_avg | double precision | bytea | normal
pg_catalog | float8_avg_accum | bytea | bytea, double precision | normal
pg_catalog | float8_avg_amalg | bytea | bytea, bytea | normal
pg_catalog | float8_avg_decum | bytea | bytea, double precision | normal
pg_catalog | float8_avg_demalg | bytea | bytea, bytea | normal
pg_catalog | float8_corr | double precision | double precision[] | normal
pg_catalog | float8_covar_pop | double precision | double precision[] | normal
pg_catalog | float8_covar_samp | double precision | double precision[] | normal
pg_catalog | float8_decum | double precision[] | double precision[], double precision | normal
pg_catalog | float8_demalg | double precision[] | double precision[], double precision[] | normal
pg_catalog | float8_matrix_accum | double precision[] | double precision[], double precision[] | normal
pg_catalog | float8_mregr_accum | double precision[] | double precision[], double precision, double precision[] | normal
pg_catalog | float8_mregr_coef | double precision[] | double precision[] | normal
pg_catalog | float8_mregr_combine | double precision[] | double precision[], double precision[] | normal
pg_catalog | float8_mregr_pvalues | double precision[] | double precision[] | normal
pg_catalog | float8_mregr_r2 | double precision | double precision[] | normal
pg_catalog | float8_mregr_tstats | double precision[] | double precision[] | normal
pg_catalog | float8_pivot_accum | double precision[] | double precision[], text[], text, double precision | normal
pg_catalog | float8_regr_accum | double precision[] | double precision[], double precision, double precision | normal
pg_catalog | float8_regr_amalg | double precision[] | double precision[], double precision[] | normal
pg_catalog | float8_regr_avgx | double precision | double precision[] | normal
pg_catalog | float8_regr_avgy | double precision | double precision[] | normal
pg_catalog | float8_regr_intercept | double precision | double precision[] | normal
pg_catalog | float8_regr_r2 | double precision | double precision[] | normal
pg_catalog | float8_regr_slope | double precision | double precision[] | normal
pg_catalog | float8_regr_sxx | double precision | double precision[] | normal
pg_catalog | float8_regr_sxy | double precision | double precision[] | normal
pg_catalog | float8_regr_syy | double precision | double precision[] | normal
pg_catalog | float8_stddev_pop | double precision | double precision[] | normal
pg_catalog | float8_stddev_samp | double precision | double precision[] | normal
pg_catalog | float8_var_pop | double precision | double precision[] | normal
pg_catalog | float8_var_samp | double precision | double precision[] | normal
pg_catalog | float8abs | double precision | double precision | normal
pg_catalog | float8div | double precision | double precision, double precision | normal
pg_catalog | float8eq | boolean | double precision, double precision | normal
pg_catalog | float8ge | boolean | double precision, double precision | normal
pg_catalog | float8gt | boolean | double precision, double precision | normal
pg_catalog | float8in | double precision | cstring | normal
pg_catalog | float8larger | double precision | double precision, double precision | normal
pg_catalog | float8le | boolean | double precision, double precision | normal
pg_catalog | float8lt | boolean | double precision, double precision | normal
pg_catalog | float8mi | double precision | double precision, double precision | normal
pg_catalog | float8mul | double precision | double precision, double precision | normal
pg_catalog | float8ne | boolean | double precision, double precision | normal
pg_catalog | float8out | cstring | double precision | normal
pg_catalog | float8pl | double precision | double precision, double precision | normal
pg_catalog | float8recv | double precision | internal | normal
pg_catalog | float8send | bytea | double precision | normal
pg_catalog | float8smaller | double precision | double precision, double precision | normal
pg_catalog | float8um | double precision | double precision | normal
pg_catalog | float8up | double precision | double precision | normal
pg_catalog | floor | double precision | double precision | normal
pg_catalog | floor | numeric | numeric | normal
pg_catalog | flt4_mul_cash | money | real, money | normal
pg_catalog | flt8_mul_cash | money | double precision, money | normal
pg_catalog | fmgr_c_validator | void | oid | normal
pg_catalog | fmgr_internal_validator | void | oid | normal
pg_catalog | fmgr_sql_validator | void | oid | normal
pg_catalog | format_type | text | oid, integer | normal
pg_catalog | gb18030_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | gbk_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | generate_series | SETOF bigint | bigint, bigint | normal
pg_catalog | generate_series | SETOF bigint | bigint, bigint, bigint | normal
pg_catalog | generate_series | SETOF integer | integer, integer | normal
pg_catalog | generate_series | SETOF integer | integer, integer, integer | normal
pg_catalog | get_ao_compression_ratio | double precision | oid | normal
pg_catalog | get_ao_compression_ratio | double precision | text | normal
pg_catalog | get_ao_distribution | SETOF record | relname text, OUT segmentid integer, OUT tupcount double precision | normal
pg_catalog | get_ao_distribution | SETOF record | reloid oid, OUT segmentid integer, OUT tupcount double precision | normal
pg_catalog | get_bit | integer | bytea, integer | normal
pg_catalog | get_byte | integer | bytea, integer | normal
pg_catalog | getdatabaseencoding | name | | normal
pg_catalog | getpgusername | name | | normal
pg_catalog | ginarrayconsistent | boolean | internal, smallint, internal | normal
pg_catalog | ginarrayextract | internal | anyarray, internal | normal
pg_catalog | ginbeginscan | internal | internal, internal, internal | normal
pg_catalog | ginbuild | internal | internal, internal, internal | normal
pg_catalog | ginbulkdelete | internal | internal, internal, internal, internal | normal
pg_catalog | gincostestimate | void | internal, internal, internal, internal, internal, internal, internal, internal | normal
pg_catalog | ginendscan | void | internal | normal
pg_catalog | gingetmulti | internal | internal, internal | normal
pg_catalog | gingettuple | boolean | internal, internal | normal
pg_catalog | gininsert | boolean | internal, internal, internal, internal, internal, internal | normal
pg_catalog | ginmarkpos | void | internal | normal
pg_catalog | ginoptions | bytea | text[], boolean | normal
pg_catalog | ginrescan | void | internal, internal | normal
pg_catalog | ginrestrpos | void | internal | normal
pg_catalog | ginvacuumcleanup | internal | internal, internal | normal
pg_catalog | gist_box_compress | internal | internal | normal
pg_catalog | gist_box_consistent | boolean | internal, box, integer | normal
pg_catalog | gist_box_decompress | internal | internal | normal
pg_catalog | gist_box_penalty | internal | internal, internal, internal | normal
pg_catalog | gist_box_picksplit | internal | internal, internal | normal
pg_catalog | gist_box_same | internal | box, box, internal | normal
pg_catalog | gist_box_union | box | internal, internal | normal
pg_catalog | gist_circle_compress | internal | internal | normal
pg_catalog | gist_circle_consistent | boolean | internal, circle, integer | normal
pg_catalog | gist_poly_compress | internal | internal | normal
pg_catalog | gist_poly_consistent | boolean | internal, polygon, integer | normal
pg_catalog | gistbeginscan | internal | internal, internal, internal | normal
pg_catalog | gistbuild | internal | internal, internal, internal | normal
pg_catalog | gistbulkdelete | internal | internal, internal, internal, internal | normal
pg_catalog | gistcostestimate | void | internal, internal, internal, internal, internal, internal, internal, internal | normal
pg_catalog | gistendscan | void | internal | normal
pg_catalog | gistgetmulti | internal | internal, internal | normal
pg_catalog | gistgettuple | boolean | internal, internal | normal
pg_catalog | gistinsert | boolean | internal, internal, internal, internal, internal, internal | normal
pg_catalog | gistmarkpos | void | internal | normal
pg_catalog | gistoptions | bytea | text[], boolean | normal
pg_catalog | gistrescan | void | internal, internal | normal
pg_catalog | gistrestrpos | void | internal | normal
pg_catalog | gistvacuumcleanup | internal | internal, internal | normal
pg_catalog | gp_activate_standby | boolean | | normal
pg_catalog | gp_add_global_sequence_entry | boolean | tid, bigint | normal
pg_catalog | gp_add_master_standby | smallint | text, text, text[] | normal
pg_catalog | gp_add_persistent_database_node_entry | boolean | tid, oid, oid, smallint, bigint, smallint, integer, integer, bigint, tid | normal
pg_catalog | gp_add_persistent_filespace_node_entry | boolean | tid, oid, smallint, text, smallint, text, smallint, bigint, smallint, integer, integer, bigint, tid | normal
pg_catalog | gp_add_persistent_relation_node_entry | boolean | tid, oid, oid, oid, integer, smallint, smallint, bigint, smallint, smallint, boolean, bigint, gpxlogloc, integer, bigint, bigint, integer, integer, bigint, tid | normal
pg_catalog | gp_add_persistent_tablespace_node_entry | boolean | tid, oid, oid, smallint, bigint, smallint, integer, integer, bigint, tid | normal
pg_catalog | gp_add_relation_node_entry | boolean | tid, oid, integer, bigint, tid, bigint | normal
pg_catalog | gp_add_segment | smallint | text, text, integer, text[] | normal
pg_catalog | gp_add_segment_mirror | smallint | smallint, text, text, integer, integer, text[] | normal
pg_catalog | gp_add_segment_persistent_entries | boolean | smallint, smallint, text[] | normal
pg_catalog | gp_adjust_priority | integer | integer, integer, integer | normal
pg_catalog | gp_adjust_priority | integer | integer, integer, text | normal
pg_catalog | gp_backup_launch | text | text, text, text, text, text | normal
pg_catalog | gp_changetracking_log | SETOF record | filetype integer, OUT segment_id smallint, OUT dbid smallint, OUT space oid, OUT db oid, OUT rel oid, OUT xlogloc gpxlogloc, OUT blocknum integer, OUT persistent_tid tid, OUT persistent_sn bigint | normal
pg_catalog | gp_delete_global_sequence_entry | boolean | tid | normal
pg_catalog | gp_delete_persistent_database_node_entry | boolean | tid | normal
pg_catalog | gp_delete_persistent_filespace_node_entry | boolean | tid | normal
pg_catalog | gp_delete_persistent_relation_node_entry | boolean | tid | normal
pg_catalog | gp_delete_persistent_tablespace_node_entry | boolean | tid | normal
pg_catalog | gp_delete_relation_node_entry | boolean | tid | normal
pg_catalog | gp_deprecated | void | | normal
pg_catalog | gp_distributed_log | SETOF record | | normal
pg_catalog | gp_distributed_xacts | SETOF record | | normal
pg_catalog | gp_distributed_xid | xid | | normal
pg_catalog | gp_dummy_compression_compress | internal | internal, integer, internal, integer, internal, internal | normal
pg_catalog | gp_dummy_compression_constructor | internal | internal, internal, boolean | normal
pg_catalog | gp_dummy_compression_decompress | internal | internal, integer, internal, integer, internal, internal | normal
pg_catalog | gp_dummy_compression_destructor | internal | internal | normal
pg_catalog | gp_dummy_compression_validator | internal | internal | normal
pg_catalog | gp_elog | void | text | normal
pg_catalog | gp_elog | void | text, boolean | normal
pg_catalog | gp_execution_dbid | integer | | normal
pg_catalog | gp_execution_segment | SETOF integer | | normal
pg_catalog | gp_fault_inject | bigint | integer, bigint | normal
pg_catalog | gp_list_backend_priorities | SETOF record | | normal
pg_catalog | gp_max_distributed_xid | xid | | normal
pg_catalog | gp_persistent_build_all | integer | boolean | normal
pg_catalog | gp_persistent_build_db | integer | boolean | normal
pg_catalog | gp_persistent_relation_node_check | SETOF gp_persistent_relation_node | | normal
pg_catalog | gp_persistent_repair_delete | integer | integer, tid | normal
pg_catalog | gp_persistent_reset_all | integer | | normal
pg_catalog | gp_persistent_set_relation_bufpool_kind_all | integer | | normal
pg_catalog | gp_pgdatabase | SETOF record | | normal
pg_catalog | gp_prep_new_segment | boolean | text[] | normal
pg_catalog | gp_quicklz_compress | void | internal, integer, internal, integer, internal, internal | normal
pg_catalog | gp_quicklz_constructor | internal | internal, internal, boolean | normal
pg_catalog | gp_quicklz_decompress | void | internal, integer, internal, integer, internal, internal | normal
pg_catalog | gp_quicklz_destructor | void | internal | normal
pg_catalog | gp_quicklz_validator | void | internal | normal
pg_catalog | gp_read_backup_file | text | text, text, regproc | normal
pg_catalog | gp_remove_master_standby | boolean | | normal
pg_catalog | gp_remove_segment | boolean | smallint | normal
pg_catalog | gp_remove_segment_mirror | boolean | smallint | normal
pg_catalog | gp_remove_segment_persistent_entries | boolean | smallint, smallint | normal
pg_catalog | gp_restore_launch | text | text, text, text, text, text, text, integer, boolean | normal
pg_catalog | gp_rle_type_compress | void | internal, integer, internal, integer, internal, internal | normal
pg_catalog | gp_rle_type_constructor | internal | internal, internal, boolean | normal
pg_catalog | gp_rle_type_decompress | void | internal, integer, internal, integer, internal, internal | normal
pg_catalog | gp_rle_type_destructor | void | internal | normal
pg_catalog | gp_rle_type_validator | void | internal | normal
pg_catalog | gp_statistics_estimate_reltuples_relpages_oid | real[] | oid | normal
pg_catalog | gp_transaction_log | SETOF record | | normal
pg_catalog | gp_update_ao_master_stats | double precision | oid | normal
pg_catalog | gp_update_ao_master_stats | double precision | text | normal
pg_catalog | gp_update_global_sequence_entry | boolean | tid, bigint | normal
pg_catalog | gp_update_persistent_database_node_entry | boolean | tid, oid, oid, smallint, bigint, smallint, integer, integer, bigint, tid | normal
pg_catalog | gp_update_persistent_filespace_node_entry | boolean | tid, oid, smallint, text, smallint, text, smallint, bigint, smallint, integer, integer, bigint, tid | normal
pg_catalog | gp_update_persistent_relation_node_entry | boolean | tid, oid, oid, oid, integer, smallint, smallint, bigint, smallint, smallint, boolean, bigint, gpxlogloc, integer, bigint, bigint, integer, integer, bigint, tid | normal
pg_catalog | gp_update_persistent_tablespace_node_entry | boolean | tid, oid, oid, smallint, bigint, smallint, integer, integer, bigint, tid | normal
pg_catalog | gp_update_relation_node_entry | boolean | tid, oid, integer, bigint, tid, bigint | normal
pg_catalog | gp_write_backup_file | text | text, text, text | normal
pg_catalog | gp_zlib_compress | void | internal, integer, internal, integer, internal, internal | normal
pg_catalog | gp_zlib_constructor | internal | internal, internal, boolean | normal
pg_catalog | gp_zlib_decompress | void | internal, integer, internal, integer, internal, internal | normal
pg_catalog | gp_zlib_destructor | void | internal | normal
pg_catalog | gp_zlib_validator | void | internal | normal
pg_catalog | gpaotidin | gpaotid | cstring | normal
pg_catalog | gpaotidout | cstring | gpaotid | normal
pg_catalog | gpaotidrecv | gpaotid | internal | normal
pg_catalog | gpaotidsend | bytea | gpaotid | normal
pg_catalog | gpdb_fdw_validator | boolean | text[], oid | normal
pg_catalog | gphdfs_export | bytea | record | normal
pg_catalog | gphdfs_import | record | | normal
pg_catalog | gphdfs_read | integer | | normal
pg_catalog | gphdfs_validate | void | | normal
pg_catalog | gphdfs_write | integer | | normal
pg_catalog | gpxlogloceq | boolean | gpxlogloc, gpxlogloc | normal
pg_catalog | gpxloglocge | boolean | gpxlogloc, gpxlogloc | normal
pg_catalog | gpxloglocgt | boolean | gpxlogloc, gpxlogloc | normal
pg_catalog | gpxloglocin | gpxlogloc | cstring | normal
pg_catalog | gpxlogloclarger | gpxlogloc | gpxlogloc, gpxlogloc | normal
pg_catalog | gpxloglocle | boolean | gpxlogloc, gpxlogloc | normal
pg_catalog | gpxlogloclt | boolean | gpxlogloc, gpxlogloc | normal
pg_catalog | gpxloglocne | boolean | gpxlogloc, gpxlogloc | normal
pg_catalog | gpxloglocout | cstring | gpxlogloc | normal
pg_catalog | gpxloglocrecv | gpxlogloc | internal | normal
pg_catalog | gpxloglocsend | bytea | gpxlogloc | normal
pg_catalog | gpxloglocsmaller | gpxlogloc | gpxlogloc, gpxlogloc | normal
pg_catalog | has_database_privilege | boolean | name, oid, text | normal
pg_catalog | has_database_privilege | boolean | name, text, text | normal
pg_catalog | has_database_privilege | boolean | oid, oid, text | normal
pg_catalog | has_database_privilege | boolean | oid, text | normal
pg_catalog | has_database_privilege | boolean | oid, text, text | normal
pg_catalog | has_database_privilege | boolean | text, text | normal
pg_catalog | has_foreign_data_wrapper_privilege | boolean | name, oid, text | normal
pg_catalog | has_foreign_data_wrapper_privilege | boolean | name, text, text | normal
pg_catalog | has_foreign_data_wrapper_privilege | boolean | oid, oid, text | normal
pg_catalog | has_foreign_data_wrapper_privilege | boolean | oid, text | normal
pg_catalog | has_foreign_data_wrapper_privilege | boolean | oid, text, text | normal
pg_catalog | has_foreign_data_wrapper_privilege | boolean | text, text | normal
pg_catalog | has_function_privilege | boolean | name, oid, text | normal
pg_catalog | has_function_privilege | boolean | name, text, text | normal
pg_catalog | has_function_privilege | boolean | oid, oid, text | normal
pg_catalog | has_function_privilege | boolean | oid, text | normal
pg_catalog | has_function_privilege | boolean | oid, text, text | normal
pg_catalog | has_function_privilege | boolean | text, text | normal
pg_catalog | has_language_privilege | boolean | name, oid, text | normal
pg_catalog | has_language_privilege | boolean | name, text, text | normal
pg_catalog | has_language_privilege | boolean | oid, oid, text | normal
pg_catalog | has_language_privilege | boolean | oid, text | normal
pg_catalog | has_language_privilege | boolean | oid, text, text | normal
pg_catalog | has_language_privilege | boolean | text, text | normal
pg_catalog | has_schema_privilege | boolean | name, oid, text | normal
pg_catalog | has_schema_privilege | boolean | name, text, text | normal
pg_catalog | has_schema_privilege | boolean | oid, oid, text | normal
pg_catalog | has_schema_privilege | boolean | oid, text | normal
pg_catalog | has_schema_privilege | boolean | oid, text, text | normal
pg_catalog | has_schema_privilege | boolean | text, text | normal
pg_catalog | has_server_privilege | boolean | name, oid, text | normal
pg_catalog | has_server_privilege | boolean | name, text, text | normal
pg_catalog | has_server_privilege | boolean | oid, oid, text | normal
pg_catalog | has_server_privilege | boolean | oid, text | normal
pg_catalog | has_server_privilege | boolean | oid, text, text | normal
pg_catalog | has_server_privilege | boolean | text, text | normal
pg_catalog | has_table_privilege | boolean | name, oid, text | normal
pg_catalog | has_table_privilege | boolean | name, text, text | normal
pg_catalog | has_table_privilege | boolean | oid, oid, text | normal
pg_catalog | has_table_privilege | boolean | oid, text | normal
pg_catalog | has_table_privilege | boolean | oid, text, text | normal
pg_catalog | has_table_privilege | boolean | text, text | normal
pg_catalog | has_tablespace_privilege | boolean | name, oid, text | normal
pg_catalog | has_tablespace_privilege | boolean | name, text, text | normal
pg_catalog | has_tablespace_privilege | boolean | oid, oid, text | normal
pg_catalog | has_tablespace_privilege | boolean | oid, text | normal
pg_catalog | has_tablespace_privilege | boolean | oid, text, text | normal
pg_catalog | has_tablespace_privilege | boolean | text, text | normal
pg_catalog | hash_aclitem | integer | aclitem | normal
pg_catalog | hash_numeric | integer | numeric | normal
pg_catalog | hashbeginscan | internal | internal, internal, internal | normal
pg_catalog | hashbpchar | integer | character | normal
pg_catalog | hashbuild | internal | internal, internal, internal | normal
pg_catalog | hashbulkdelete | internal | internal, internal, internal, internal | normal
pg_catalog | hashchar | integer | "char" | normal
pg_catalog | hashcostestimate | void | internal, internal, internal, internal, internal, internal, internal, internal | normal
pg_catalog | hashendscan | void | internal | normal
pg_catalog | hashfloat4 | integer | real | normal
pg_catalog | hashfloat8 | integer | double precision | normal
pg_catalog | hashgetmulti | internal | internal, internal | normal
pg_catalog | hashgettuple | boolean | internal, internal | normal
pg_catalog | hashinet | integer | inet | normal
pg_catalog | hashinsert | boolean | internal, internal, internal, internal, internal, internal | normal
pg_catalog | hashint2 | integer | smallint | normal
pg_catalog | hashint2vector | integer | int2vector | normal
pg_catalog | hashint4 | integer | integer | normal
pg_catalog | hashint8 | integer | bigint | normal
pg_catalog | hashmacaddr | integer | macaddr | normal
pg_catalog | hashmarkpos | void | internal | normal
pg_catalog | hashname | integer | name | normal
pg_catalog | hashoid | integer | oid | normal
pg_catalog | hashoidvector | integer | oidvector | normal
pg_catalog | hashoptions | bytea | text[], boolean | normal
pg_catalog | hashrescan | void | internal, internal | normal
pg_catalog | hashrestrpos | void | internal | normal
pg_catalog | hashtext | integer | text | normal
pg_catalog | hashvacuumcleanup | internal | internal, internal | normal
pg_catalog | hashvarlena | integer | internal | normal
pg_catalog | height | double precision | box | normal
pg_catalog | host | text | inet | normal
pg_catalog | hostmask | inet | inet | normal
pg_catalog | iclikejoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | iclikesel | double precision | internal, oid, internal, integer | normal
pg_catalog | icnlikejoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | icnlikesel | double precision | internal, oid, internal, integer | normal
pg_catalog | icregexeqjoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | icregexeqsel | double precision | internal, oid, internal, integer | normal
pg_catalog | icregexnejoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | icregexnesel | double precision | internal, oid, internal, integer | normal
pg_catalog | inet | inet | text | normal
pg_catalog | inet_client_addr | inet | | normal
pg_catalog | inet_client_port | integer | | normal
pg_catalog | inet_in | inet | cstring | normal
pg_catalog | inet_out | cstring | inet | normal
pg_catalog | inet_recv | inet | internal | normal
pg_catalog | inet_send | bytea | inet | normal
pg_catalog | inet_server_addr | inet | | normal
pg_catalog | inet_server_port | integer | | normal
pg_catalog | inetand | inet | inet, inet | normal
pg_catalog | inetmi | bigint | inet, inet | normal
pg_catalog | inetmi_int8 | inet | inet, bigint | normal
pg_catalog | inetnot | inet | inet | normal
pg_catalog | inetor | inet | inet, inet | normal
pg_catalog | inetpl | inet | inet, bigint | normal
pg_catalog | initcap | text | text | normal
pg_catalog | int2 | smallint | bigint | normal
pg_catalog | int2 | smallint | double precision | normal
pg_catalog | int2 | smallint | integer | normal
pg_catalog | int2 | smallint | numeric | normal
pg_catalog | int2 | smallint | real | normal
pg_catalog | int2 | smallint | text | normal
pg_catalog | int24div | integer | smallint, integer | normal
pg_catalog | int24eq | boolean | smallint, integer | normal
pg_catalog | int24ge | boolean | smallint, integer | normal
pg_catalog | int24gt | boolean | smallint, integer | normal
pg_catalog | int24le | boolean | smallint, integer | normal
pg_catalog | int24lt | boolean | smallint, integer | normal
pg_catalog | int24mi | integer | smallint, integer | normal
pg_catalog | int24mod | integer | smallint, integer | normal
pg_catalog | int24mul | integer | smallint, integer | normal
pg_catalog | int24ne | boolean | smallint, integer | normal
pg_catalog | int24pl | integer | smallint, integer | normal
pg_catalog | int28eq | boolean | smallint, bigint | normal
pg_catalog | int28ge | boolean | smallint, bigint | normal
pg_catalog | int28gt | boolean | smallint, bigint | normal
pg_catalog | int28le | boolean | smallint, bigint | normal
pg_catalog | int28lt | boolean | smallint, bigint | normal
pg_catalog | int28ne | boolean | smallint, bigint | normal
pg_catalog | int2_accum | numeric[] | numeric[], smallint | normal
pg_catalog | int2_avg_accum | bytea | bytea, smallint | normal
pg_catalog | int2_avg_decum | bytea | bytea, smallint | normal
pg_catalog | int2_decum | numeric[] | numeric[], smallint | normal
pg_catalog | int2_invsum | bigint | bigint, smallint | normal
pg_catalog | int2_matrix_accum | bigint[] | bigint[], smallint[] | normal
pg_catalog | int2_mul_cash | money | smallint, money | normal
pg_catalog | int2_sum | bigint | bigint, smallint | normal
pg_catalog | int2abs | smallint | smallint | normal
pg_catalog | int2and | smallint | smallint, smallint | normal
pg_catalog | int2div | smallint | smallint, smallint | normal
pg_catalog | int2eq | boolean | smallint, smallint | normal
pg_catalog | int2ge | boolean | smallint, smallint | normal
pg_catalog | int2gt | boolean | smallint, smallint | normal
pg_catalog | int2in | smallint | cstring | normal
pg_catalog | int2larger | smallint | smallint, smallint | normal
pg_catalog | int2le | boolean | smallint, smallint | normal
pg_catalog | int2lt | boolean | smallint, smallint | normal
pg_catalog | int2mi | smallint | smallint, smallint | normal
pg_catalog | int2mod | smallint | smallint, smallint | normal
pg_catalog | int2mul | smallint | smallint, smallint | normal
pg_catalog | int2ne | boolean | smallint, smallint | normal
pg_catalog | int2not | smallint | smallint | normal
pg_catalog | int2or | smallint | smallint, smallint | normal
pg_catalog | int2out | cstring | smallint | normal
pg_catalog | int2pl | smallint | smallint, smallint | normal
pg_catalog | int2recv | smallint | internal | normal
pg_catalog | int2send | bytea | smallint | normal
pg_catalog | int2shl | smallint | smallint, integer | normal
pg_catalog | int2shr | smallint | smallint, integer | normal
pg_catalog | int2smaller | smallint | smallint, smallint | normal
pg_catalog | int2um | smallint | smallint | normal
pg_catalog | int2up | smallint | smallint | normal
pg_catalog | int2vectoreq | boolean | int2vector, int2vector | normal
pg_catalog | int2vectorin | int2vector | cstring | normal
pg_catalog | int2vectorout | cstring | int2vector | normal
pg_catalog | int2vectorrecv | int2vector | internal | normal
pg_catalog | int2vectorsend | bytea | int2vector | normal
pg_catalog | int2xor | smallint | smallint, smallint | normal
pg_catalog | int4 | integer | bigint | normal
pg_catalog | int4 | integer | bit | normal
pg_catalog | int4 | integer | boolean | normal
pg_catalog | int4 | integer | "char" | normal
pg_catalog | int4 | integer | double precision | normal
pg_catalog | int4 | integer | numeric | normal
pg_catalog | int4 | integer | real | normal
pg_catalog | int4 | integer | smallint | normal
pg_catalog | int4 | integer | text | normal
pg_catalog | int42div | integer | integer, smallint | normal
pg_catalog | int42eq | boolean | integer, smallint | normal
pg_catalog | int42ge | boolean | integer, smallint | normal
pg_catalog | int42gt | boolean | integer, smallint | normal
pg_catalog | int42le | boolean | integer, smallint | normal
pg_catalog | int42lt | boolean | integer, smallint | normal
pg_catalog | int42mi | integer | integer, smallint | normal
pg_catalog | int42mod | integer | integer, smallint | normal
pg_catalog | int42mul | integer | integer, smallint | normal
pg_catalog | int42ne | boolean | integer, smallint | normal
pg_catalog | int42pl | integer | integer, smallint | normal
pg_catalog | int48div | bigint | integer, bigint | normal
pg_catalog | int48eq | boolean | integer, bigint | normal
pg_catalog | int48ge | boolean | integer, bigint | normal
pg_catalog | int48gt | boolean | integer, bigint | normal
pg_catalog | int48le | boolean | integer, bigint | normal
pg_catalog | int48lt | boolean | integer, bigint | normal
pg_catalog | int48mi | bigint | integer, bigint | normal
pg_catalog | int48mul | bigint | integer, bigint | normal
pg_catalog | int48ne | boolean | integer, bigint | normal
pg_catalog | int48pl | bigint | integer, bigint | normal
pg_catalog | int4_accum | numeric[] | numeric[], integer | normal
pg_catalog | int4_avg_accum | bytea | bytea, integer | normal
pg_catalog | int4_avg_decum | bytea | bytea, integer | normal
pg_catalog | int4_decum | numeric[] | numeric[], integer | normal
pg_catalog | int4_invsum | bigint | bigint, integer | normal
pg_catalog | int4_matrix_accum | bigint[] | bigint[], integer[] | normal
pg_catalog | int4_mul_cash | money | integer, money | normal
pg_catalog | int4_pivot_accum | integer[] | integer[], text[], text, integer | normal
pg_catalog | int4_sum | bigint | bigint, integer | normal
pg_catalog | int4abs | integer | integer | normal
pg_catalog | int4and | integer | integer, integer | normal
pg_catalog | int4div | integer | integer, integer | normal
pg_catalog | int4eq | boolean | integer, integer | normal
pg_catalog | int4ge | boolean | integer, integer | normal
pg_catalog | int4gt | boolean | integer, integer | normal
pg_catalog | int4in | integer | cstring | normal
pg_catalog | int4inc | integer | integer | normal
pg_catalog | int4larger | integer | integer, integer | normal
pg_catalog | int4le | boolean | integer, integer | normal
pg_catalog | int4lt | boolean | integer, integer | normal
pg_catalog | int4mi | integer | integer, integer | normal
pg_catalog | int4mod | integer | integer, integer | normal
pg_catalog | int4mul | integer | integer, integer | normal
pg_catalog | int4ne | boolean | integer, integer | normal
pg_catalog | int4not | integer | integer | normal
pg_catalog | int4notin | boolean | integer, text | normal
pg_catalog | int4or | integer | integer, integer | normal
pg_catalog | int4out | cstring | integer | normal
pg_catalog | int4pl | integer | integer, integer | normal
pg_catalog | int4recv | integer | internal | normal
pg_catalog | int4send | bytea | integer | normal
pg_catalog | int4shl | integer | integer, integer | normal
pg_catalog | int4shr | integer | integer, integer | normal
pg_catalog | int4smaller | integer | integer, integer | normal
pg_catalog | int4um | integer | integer | normal
pg_catalog | int4up | integer | integer | normal
pg_catalog | int4xor | integer | integer, integer | normal
pg_catalog | int8 | bigint | bit | normal
pg_catalog | int8 | bigint | double precision | normal
pg_catalog | int8 | bigint | integer | normal
pg_catalog | int8 | bigint | numeric | normal
pg_catalog | int8 | bigint | oid | normal
pg_catalog | int8 | bigint | real | normal
pg_catalog | int8 | bigint | smallint | normal
pg_catalog | int8 | bigint | text | normal
pg_catalog | int8 | bigint | tid | normal
pg_catalog | int82eq | boolean | bigint, smallint | normal
pg_catalog | int82ge | boolean | bigint, smallint | normal
pg_catalog | int82gt | boolean | bigint, smallint | normal
pg_catalog | int82le | boolean | bigint, smallint | normal
pg_catalog | int82lt | boolean | bigint, smallint | normal
pg_catalog | int82ne | boolean | bigint, smallint | normal
pg_catalog | int84div | bigint | bigint, integer | normal
pg_catalog | int84eq | boolean | bigint, integer | normal
pg_catalog | int84ge | boolean | bigint, integer | normal
pg_catalog | int84gt | boolean | bigint, integer | normal
pg_catalog | int84le | boolean | bigint, integer | normal
pg_catalog | int84lt | boolean | bigint, integer | normal
pg_catalog | int84mi | bigint | bigint, integer | normal
pg_catalog | int84mul | bigint | bigint, integer | normal
pg_catalog | int84ne | boolean | bigint, integer | normal
pg_catalog | int84pl | bigint | bigint, integer | normal
pg_catalog | int8_accum | numeric[] | numeric[], bigint | normal
pg_catalog | int8_avg | numeric | bytea | normal
pg_catalog | int8_avg_accum | bytea | bytea, bigint | normal
pg_catalog | int8_avg_amalg | bytea | bytea, bytea | normal
pg_catalog | int8_avg_decum | bytea | bytea, bigint | normal
pg_catalog | int8_avg_demalg | bytea | bytea, bytea | normal
pg_catalog | int8_decum | numeric[] | numeric[], bigint | normal
pg_catalog | int8_invsum | numeric | numeric, bigint | normal
pg_catalog | int8_matrix_accum | bigint[] | bigint[], bigint[] | normal
pg_catalog | int8_pivot_accum | bigint[] | bigint[], text[], text, bigint | normal
pg_catalog | int8_sum | numeric | numeric, bigint | normal
pg_catalog | int8abs | bigint | bigint | normal
pg_catalog | int8and | bigint | bigint, bigint | normal
pg_catalog | int8dec | bigint | bigint | normal
pg_catalog | int8div | bigint | bigint, bigint | normal
pg_catalog | int8eq | boolean | bigint, bigint | normal
pg_catalog | int8ge | boolean | bigint, bigint | normal
pg_catalog | int8gt | boolean | bigint, bigint | normal
pg_catalog | int8in | bigint | cstring | normal
pg_catalog | int8inc | bigint | bigint | normal
pg_catalog | int8inc_any | bigint | bigint, "any" | normal
pg_catalog | int8inc_float8_float8 | bigint | bigint, double precision, double precision | normal
pg_catalog | int8larger | bigint | bigint, bigint | normal
pg_catalog | int8le | boolean | bigint, bigint | normal
pg_catalog | int8lt | boolean | bigint, bigint | normal
pg_catalog | int8mi | bigint | bigint, bigint | normal
pg_catalog | int8mod | bigint | bigint, bigint | normal
pg_catalog | int8mul | bigint | bigint, bigint | normal
pg_catalog | int8ne | boolean | bigint, bigint | normal
pg_catalog | int8not | bigint | bigint | normal
pg_catalog | int8or | bigint | bigint, bigint | normal
pg_catalog | int8out | cstring | bigint | normal
pg_catalog | int8pl | bigint | bigint, bigint | normal
pg_catalog | int8pl_inet | inet | bigint, inet | normal
pg_catalog | int8recv | bigint | internal | normal
pg_catalog | int8send | bytea | bigint | normal
pg_catalog | int8shl | bigint | bigint, integer | normal
pg_catalog | int8shr | bigint | bigint, integer | normal
pg_catalog | int8smaller | bigint | bigint, bigint | normal
pg_catalog | int8um | bigint | bigint | normal
pg_catalog | int8up | bigint | bigint | normal
pg_catalog | int8xor | bigint | bigint, bigint | normal
pg_catalog | integer_pl_date | date | integer, date | normal
pg_catalog | inter_lb | boolean | line, box | normal
pg_catalog | inter_sb | boolean | lseg, box | normal
pg_catalog | inter_sl | boolean | lseg, line | normal
pg_catalog | internal_in | internal | cstring | normal
pg_catalog | internal_out | cstring | internal | normal
pg_catalog | interval | interval | interval, integer | normal
pg_catalog | interval | interval | reltime | normal
pg_catalog | interval | interval | text | normal
pg_catalog | interval | interval | time without time zone | normal
pg_catalog | interval_accum | interval[] | interval[], interval | normal
pg_catalog | interval_amalg | interval[] | interval[], interval[] | normal
pg_catalog | interval_avg | interval | interval[] | normal
pg_catalog | interval_cmp | integer | interval, interval | normal
pg_catalog | interval_decum | interval[] | interval[], interval | normal
pg_catalog | interval_demalg | interval[] | interval[], interval[] | normal
pg_catalog | interval_div | interval | interval, double precision | normal
pg_catalog | interval_eq | boolean | interval, interval | normal
pg_catalog | interval_ge | boolean | interval, interval | normal
pg_catalog | interval_gt | boolean | interval, interval | normal
pg_catalog | interval_hash | integer | interval | normal
pg_catalog | interval_in | interval | cstring, oid, integer | normal
pg_catalog | interval_larger | interval | interval, interval | normal
pg_catalog | interval_le | boolean | interval, interval | normal
pg_catalog | interval_lt | boolean | interval, interval | normal
pg_catalog | interval_mi | interval | interval, interval | normal
pg_catalog | interval_mul | interval | interval, double precision | normal
pg_catalog | interval_ne | boolean | interval, interval | normal
pg_catalog | interval_out | cstring | interval | normal
pg_catalog | interval_pl | interval | interval, interval | normal
pg_catalog | interval_pl_date | timestamp without time zone | interval, date | normal
pg_catalog | interval_pl_time | time without time zone | interval, time without time zone | normal
pg_catalog | interval_pl_timestamp | timestamp without time zone | interval, timestamp without time zone | normal
pg_catalog | interval_pl_timestamptz | timestamp with time zone | interval, timestamp with time zone | normal
pg_catalog | interval_pl_timetz | time with time zone | interval, time with time zone | normal
pg_catalog | interval_recv | interval | internal, oid, integer | normal
pg_catalog | interval_send | bytea | interval | normal
pg_catalog | interval_smaller | interval | interval, interval | normal
pg_catalog | interval_um | interval | interval | normal
pg_catalog | intinterval | boolean | abstime, tinterval | normal
pg_catalog | isclosed | boolean | path | normal
pg_catalog | isfalse | boolean | boolean | normal
pg_catalog | isfinite | boolean | abstime | normal
pg_catalog | isfinite | boolean | interval | normal
pg_catalog | isfinite | boolean | timestamp without time zone | normal
pg_catalog | isfinite | boolean | timestamp with time zone | normal
pg_catalog | ishorizontal | boolean | line | normal
pg_catalog | ishorizontal | boolean | lseg | normal
pg_catalog | ishorizontal | boolean | point, point | normal
pg_catalog | isnotfalse | boolean | boolean | normal
pg_catalog | isnottrue | boolean | boolean | normal
pg_catalog | iso8859_1_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | iso8859_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | iso_to_koi8r | void | integer, integer, cstring, internal, integer | normal
pg_catalog | iso_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | iso_to_win1251 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | iso_to_win866 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | isopen | boolean | path | normal
pg_catalog | isparallel | boolean | line, line | normal
pg_catalog | isparallel | boolean | lseg, lseg | normal
pg_catalog | isperp | boolean | line, line | normal
pg_catalog | isperp | boolean | lseg, lseg | normal
pg_catalog | istrue | boolean | boolean | normal
pg_catalog | isvertical | boolean | line | normal
pg_catalog | isvertical | boolean | lseg | normal
pg_catalog | isvertical | boolean | point, point | normal
pg_catalog | johab_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | justify_days | interval | interval | normal
pg_catalog | justify_hours | interval | interval | normal
pg_catalog | justify_interval | interval | interval | normal
pg_catalog | koi8r_to_iso | void | integer, integer, cstring, internal, integer | normal
pg_catalog | koi8r_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | koi8r_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | koi8r_to_win1251 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | koi8r_to_win866 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | koi8u_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | lag | anyarray | anyarray | normal
pg_catalog | lag | anyarray | anyarray, bigint | normal
pg_catalog | lag | anyarray | anyarray, bigint, anyarray | normal
pg_catalog | lag | bigint | bigint | normal
pg_catalog | lag | bigint | bigint, bigint | normal
pg_catalog | lag | bigint | bigint, bigint, bigint | normal
pg_catalog | lag | bit | bit | normal
pg_catalog | lag | bit | bit, bigint | normal
pg_catalog | lag | bit | bit, bigint, bit | normal
pg_catalog | lag | bit varying | bit varying | normal
pg_catalog | lag | bit varying | bit varying, bigint | normal
pg_catalog | lag | bit varying | bit varying, bigint, bit varying | normal
pg_catalog | lag | boolean | boolean | normal
pg_catalog | lag | boolean | boolean, bigint | normal
pg_catalog | lag | boolean | boolean, bigint, boolean | normal
pg_catalog | lag | box | box | normal
pg_catalog | lag | box | box, bigint | normal
pg_catalog | lag | box | box, bigint, box | normal
pg_catalog | lag | bytea | bytea | normal
pg_catalog | lag | bytea | bytea, bigint | normal
pg_catalog | lag | bytea | bytea, bigint, bytea | normal
pg_catalog | lag | "char" | "char" | normal
pg_catalog | lag | character varying | character varying | normal
pg_catalog | lag | character varying | character varying, bigint | normal
pg_catalog | lag | character varying | character varying, bigint, character varying | normal
pg_catalog | lag | "char" | "char", bigint | normal
pg_catalog | lag | "char" | "char", bigint, "char" | normal
pg_catalog | lag | cidr | cidr | normal
pg_catalog | lag | cidr | cidr, bigint | normal
pg_catalog | lag | cidr | cidr, bigint, cidr | normal
pg_catalog | lag | circle | circle | normal
pg_catalog | lag | circle | circle, bigint | normal
pg_catalog | lag | circle | circle, bigint, circle | normal
pg_catalog | lag | double precision | double precision | normal
pg_catalog | lag | double precision | double precision, bigint | normal
pg_catalog | lag | double precision | double precision, bigint, double precision | normal
pg_catalog | lag | inet | inet | normal
pg_catalog | lag | inet | inet, bigint | normal
pg_catalog | lag | inet | inet, bigint, inet | normal
pg_catalog | lag | integer | integer | normal
pg_catalog | lag | integer | integer, bigint | normal
pg_catalog | lag | integer | integer, bigint, integer | normal
pg_catalog | lag | interval | interval | normal
pg_catalog | lag | interval | interval, bigint | normal
pg_catalog | lag | interval | interval, bigint, interval | normal
pg_catalog | lag | line | line | normal
pg_catalog | lag | line | line, bigint | normal
pg_catalog | lag | line | line, bigint, line | normal
pg_catalog | lag | lseg | lseg | normal
pg_catalog | lag | lseg | lseg, bigint | normal
pg_catalog | lag | lseg | lseg, bigint, lseg | normal
pg_catalog | lag | macaddr | macaddr | normal
pg_catalog | lag | macaddr | macaddr, bigint | normal
pg_catalog | lag | macaddr | macaddr, bigint, macaddr | normal
pg_catalog | lag | money | money | normal
pg_catalog | lag | money | money, bigint | normal
pg_catalog | lag | money | money, bigint, money | normal
pg_catalog | lag | name | name | normal
pg_catalog | lag | name | name, bigint | normal
pg_catalog | lag | name | name, bigint, name | normal
pg_catalog | lag | numeric | numeric | normal
pg_catalog | lag | numeric | numeric, bigint | normal
pg_catalog | lag | numeric | numeric, bigint, numeric | normal
pg_catalog | lag | oid | oid | normal
pg_catalog | lag | oid | oid, bigint | normal
pg_catalog | lag | oid | oid, bigint, oid | normal
pg_catalog | lag | path | path | normal
pg_catalog | lag | path | path, bigint | normal
pg_catalog | lag | path | path, bigint, path | normal
pg_catalog | lag | point | point | normal
pg_catalog | lag | point | point, bigint | normal
pg_catalog | lag | point | point, bigint, point | normal
pg_catalog | lag | polygon | polygon | normal
pg_catalog | lag | polygon | polygon, bigint | normal
pg_catalog | lag | polygon | polygon, bigint, polygon | normal
pg_catalog | lag | real | real | normal
pg_catalog | lag | real | real, bigint | normal
pg_catalog | lag | real | real, bigint, real | normal
pg_catalog | lag | reltime | reltime | normal
pg_catalog | lag | reltime | reltime, bigint | normal
pg_catalog | lag | reltime | reltime, bigint, reltime | normal
pg_catalog | lag | smallint | smallint | normal
pg_catalog | lag | smallint | smallint, bigint | normal
pg_catalog | lag | smallint | smallint, bigint, smallint | normal
pg_catalog | lag | text | text | normal
pg_catalog | lag | text | text, bigint | normal
pg_catalog | lag | text | text, bigint, text | normal
pg_catalog | lag | tid | tid | normal
pg_catalog | lag | tid | tid, bigint | normal
pg_catalog | lag | tid | tid, bigint, tid | normal
pg_catalog | lag | timestamp without time zone | timestamp without time zone | normal
pg_catalog | lag | timestamp without time zone | timestamp without time zone, bigint | normal
pg_catalog | lag | timestamp without time zone | timestamp without time zone, bigint, timestamp without time zone | normal
pg_catalog | lag | timestamp with time zone | timestamp with time zone | normal
pg_catalog | lag | timestamp with time zone | timestamp with time zone, bigint | normal
pg_catalog | lag | timestamp with time zone | timestamp with time zone, bigint, timestamp with time zone | normal
pg_catalog | lag | time without time zone | time without time zone | normal
pg_catalog | lag | time without time zone | time without time zone, bigint | normal
pg_catalog | lag | time without time zone | time without time zone, bigint, time without time zone | normal
pg_catalog | lag | time with time zone | time with time zone | normal
pg_catalog | lag | time with time zone | time with time zone, bigint | normal
pg_catalog | lag | time with time zone | time with time zone, bigint, time with time zone | normal
pg_catalog | lag | xid | xid | normal
pg_catalog | lag | xid | xid, bigint | normal
pg_catalog | lag | xid | xid, bigint, xid | normal
pg_catalog | lag_any | anyarray | internal, anyarray | normal
pg_catalog | lag_any | anyarray | internal, anyarray, bigint | normal
pg_catalog | lag_any | anyarray | internal, anyarray, bigint, anyarray | normal
pg_catalog | lag_bit | bit | internal, bit | normal
pg_catalog | lag_bit | bit | internal, bit, bigint | normal
pg_catalog | lag_bit | bit | internal, bit, bigint, bit | normal
pg_catalog | lag_bool | boolean | internal, boolean | normal
pg_catalog | lag_bool | boolean | internal, boolean, bigint | normal
pg_catalog | lag_bool | boolean | internal, boolean, bigint, boolean | normal
pg_catalog | lag_box | box | internal, box | normal
pg_catalog | lag_box | box | internal, box, bigint | normal
pg_catalog | lag_box | box | internal, box, bigint, box | normal
pg_catalog | lag_bytea | bytea | internal, bytea | normal
pg_catalog | lag_bytea | bytea | internal, bytea, bigint | normal
pg_catalog | lag_bytea | bytea | internal, bytea, bigint, bytea | normal



pg_catalog | lag_char | "char" | internal, "char" | normal
pg_catalog | lag_char | "char" | internal, "char", bigint | normal
pg_catalog | lag_char | "char" | internal, "char", bigint, "char" | normal
pg_catalog | lag_cidr | cidr | internal, cidr | normal
pg_catalog | lag_cidr | cidr | internal, cidr, bigint | normal
pg_catalog | lag_cidr | cidr | internal, cidr, bigint, cidr | normal
pg_catalog | lag_circle | circle | internal, circle | normal
pg_catalog | lag_circle | circle | internal, circle, bigint | normal
pg_catalog | lag_circle | circle | internal, circle, bigint, circle | normal
pg_catalog | lag_float4 | real | internal, real | normal
pg_catalog | lag_float4 | real | internal, real, bigint | normal
pg_catalog | lag_float4 | real | internal, real, bigint, real | normal
pg_catalog | lag_float8 | double precision | internal, double precision | normal
pg_catalog | lag_float8 | double precision | internal, double precision, bigint | normal
pg_catalog | lag_float8 | double precision | internal, double precision, bigint, double precision | normal
pg_catalog | lag_inet | inet | internal, inet | normal
pg_catalog | lag_inet | inet | internal, inet, bigint | normal
pg_catalog | lag_inet | inet | internal, inet, bigint, inet | normal
pg_catalog | lag_int4 | integer | internal, integer | normal
pg_catalog | lag_int4 | integer | internal, integer, bigint | normal
pg_catalog | lag_int4 | integer | internal, integer, bigint, integer | normal
pg_catalog | lag_int8 | bigint | internal, bigint | normal
pg_catalog | lag_int8 | bigint | internal, bigint, bigint | normal
pg_catalog | lag_int8 | bigint | internal, bigint, bigint, bigint | normal
pg_catalog | lag_interval | interval | internal, interval | normal
pg_catalog | lag_interval | interval | internal, interval, bigint | normal
pg_catalog | lag_interval | interval | internal, interval, bigint, interval | normal
pg_catalog | lag_line | line | internal, line | normal
pg_catalog | lag_line | line | internal, line, bigint | normal
pg_catalog | lag_line | line | internal, line, bigint, line | normal
pg_catalog | lag_lseg | lseg | internal, lseg | normal
pg_catalog | lag_lseg | lseg | internal, lseg, bigint | normal
pg_catalog | lag_lseg | lseg | internal, lseg, bigint, lseg | normal
pg_catalog | lag_macaddr | macaddr | internal, macaddr | normal
pg_catalog | lag_macaddr | macaddr | internal, macaddr, bigint | normal
pg_catalog | lag_macaddr | macaddr | internal, macaddr, bigint, macaddr | normal
pg_catalog | lag_money | money | internal, money | normal
pg_catalog | lag_money | money | internal, money, bigint | normal
pg_catalog | lag_money | money | internal, money, bigint, money | normal
pg_catalog | lag_name | name | internal, name | normal
pg_catalog | lag_name | name | internal, name, bigint | normal
pg_catalog | lag_name | name | internal, name, bigint, name | normal
pg_catalog | lag_numeric | numeric | internal, numeric | normal
pg_catalog | lag_numeric | numeric | internal, numeric, bigint | normal
pg_catalog | lag_numeric | numeric | internal, numeric, bigint, numeric | normal
pg_catalog | lag_oid | oid | internal, oid | normal
pg_catalog | lag_oid | oid | internal, oid, bigint | normal
pg_catalog | lag_oid | oid | internal, oid, bigint, oid | normal
pg_catalog | lag_path | path | internal, path | normal
pg_catalog | lag_path | path | internal, path, bigint | normal
pg_catalog | lag_path | path | internal, path, bigint, path | normal
pg_catalog | lag_point | point | internal, point | normal
pg_catalog | lag_point | point | internal, point, bigint | normal
pg_catalog | lag_point | point | internal, point, bigint, point | normal
pg_catalog | lag_polygon | polygon | internal, polygon | normal
pg_catalog | lag_polygon | polygon | internal, polygon, bigint | normal
pg_catalog | lag_polygon | polygon | internal, polygon, bigint, polygon | normal
pg_catalog | lag_reltime | reltime | internal, reltime | normal
pg_catalog | lag_reltime | reltime | internal, reltime, bigint | normal
pg_catalog | lag_reltime | reltime | internal, reltime, bigint, reltime | normal
pg_catalog | lag_smallint | smallint | internal, smallint | normal
pg_catalog | lag_smallint | smallint | internal, smallint, bigint | normal
pg_catalog | lag_smallint | smallint | internal, smallint, bigint, smallint | normal
pg_catalog | lag_text | text | internal, text | normal
pg_catalog | lag_text | text | internal, text, bigint | normal
pg_catalog | lag_text | text | internal, text, bigint, text | normal
pg_catalog | lag_tid | tid | internal, tid | normal
pg_catalog | lag_tid | tid | internal, tid, bigint | normal
pg_catalog | lag_tid | tid | internal, tid, bigint, tid | normal
pg_catalog | lag_time | time without time zone | internal, time without time zone | normal
pg_catalog | lag_time | time without time zone | internal, time without time zone, bigint | normal
The gadget spec URL could not be found
pg_catalog | lag_time | time without time zone | internal, time without time zone, bigint, time without time zone | normal
pg_catalog | lag_timestamp | timestamp without time zone | internal, timestamp without time zone | normal
pg_catalog | lag_timestamp | timestamp without time zone | internal, timestamp without time zone, bigint | normal
pg_catalog | lag_timestamp | timestamp without time zone | internal, timestamp without time zone, bigint, timestamp without time zone | normal
pg_catalog | lag_timestamptz | timestamp with time zone | internal, timestamp with time zone | normal
pg_catalog | lag_timestamptz | timestamp with time zone | internal, timestamp with time zone, bigint | normal
pg_catalog | lag_timestamptz | timestamp with time zone | internal, timestamp with time zone, bigint, timestamp with time zone | normal
pg_catalog | lag_timetz | time with time zone | internal, time with time zone | normal
pg_catalog | lag_timetz | time with time zone | internal, time with time zone, bigint | normal
pg_catalog | lag_timetz | time with time zone | internal, time with time zone, bigint, time with time zone | normal
pg_catalog | lag_varbit | bit varying | internal, bit varying | normal
pg_catalog | lag_varbit | bit varying | internal, bit varying, bigint | normal
pg_catalog | lag_varbit | bit varying | internal, bit varying, bigint, bit varying | normal
pg_catalog | lag_varchar | character varying | internal, character varying | normal
pg_catalog | lag_varchar | character varying | internal, character varying, bigint | normal
pg_catalog | lag_varchar | character varying | internal, character varying, bigint, character varying | normal
pg_catalog | lag_xid | xid | internal, xid | normal
pg_catalog | lag_xid | xid | internal, xid, bigint | normal
pg_catalog | lag_xid | xid | internal, xid, bigint, xid | normal
pg_catalog | language_handler_in | language_handler | cstring | normal
pg_catalog | language_handler_out | cstring | language_handler | normal
pg_catalog | last_value | anyarray | anyarray | normal
pg_catalog | last_value | bigint | bigint | normal
pg_catalog | last_value | bit | bit | normal
pg_catalog | last_value | bit varying | bit varying | normal
pg_catalog | last_value | boolean | boolean | normal
pg_catalog | last_value | box | box | normal
pg_catalog | last_value | bytea | bytea | normal
pg_catalog | last_value | "char" | "char" | normal
pg_catalog | last_value | character varying | character varying | normal
pg_catalog | last_value | cidr | cidr | normal
pg_catalog | last_value | circle | circle | normal
pg_catalog | last_value | double precision | double precision | normal
pg_catalog | last_value | inet | inet | normal
pg_catalog | last_value | integer | integer | normal
pg_catalog | last_value | interval | interval | normal
pg_catalog | last_value | line | line | normal
pg_catalog | last_value | lseg | lseg | normal
pg_catalog | last_value | macaddr | macaddr | normal
pg_catalog | last_value | money | money | normal
pg_catalog | last_value | name | name | normal
pg_catalog | last_value | numeric | numeric | normal
pg_catalog | last_value | oid | oid | normal
pg_catalog | last_value | path | path | normal
pg_catalog | last_value | point | point | normal
pg_catalog | last_value | polygon | polygon | normal
pg_catalog | last_value | real | real | normal
pg_catalog | last_value | reltime | reltime | normal
pg_catalog | last_value | smallint | smallint | normal
pg_catalog | last_value | text | text | normal
pg_catalog | last_value | tid | tid | normal
pg_catalog | last_value | timestamp without time zone | timestamp without time zone | normal
pg_catalog | last_value | timestamp with time zone | timestamp with time zone | normal
pg_catalog | last_value | time without time zone | time without time zone | normal
pg_catalog | last_value | time with time zone | time with time zone | normal
pg_catalog | last_value | xid | xid | normal
pg_catalog | last_value_any | anyarray | internal, anyarray | normal
pg_catalog | last_value_bigint | bigint | internal, bigint | normal
pg_catalog | last_value_bit | bit | internal, bit | normal
pg_catalog | last_value_bool | boolean | internal, boolean | normal
pg_catalog | last_value_box | box | internal, box | normal
pg_catalog | last_value_bytea | bytea | internal, bytea | normal
pg_catalog | last_value_char | "char" | internal, "char" | normal
pg_catalog | last_value_cidr | cidr | internal, cidr | normal
pg_catalog | last_value_circle | circle | internal, circle | normal
pg_catalog | last_value_float4 | real | internal, real | normal
pg_catalog | last_value_float8 | double precision | internal, double precision | normal
pg_catalog | last_value_inet | inet | internal, inet | normal
pg_catalog | last_value_int | integer | internal, integer | normal
pg_catalog | last_value_interval | interval | internal, interval | normal
pg_catalog | last_value_line | line | internal, line | normal
pg_catalog | last_value_lseg | lseg | internal, lseg | normal
pg_catalog | last_value_macaddr | macaddr | internal, macaddr | normal
pg_catalog | last_value_money | money | internal, money | normal
pg_catalog | last_value_name | name | internal, name | normal
pg_catalog | last_value_numeric | numeric | internal, numeric | normal
pg_catalog | last_value_oid | oid | internal, oid | normal
pg_catalog | last_value_path | path | internal, path | normal
pg_catalog | last_value_point | point | internal, point | normal
pg_catalog | last_value_polygon | polygon | internal, polygon | normal
pg_catalog | last_value_reltime | reltime | internal, reltime | normal
pg_catalog | last_value_smallint | smallint | internal, smallint | normal
pg_catalog | last_value_text | text | internal, text | normal
pg_catalog | last_value_tid | tid | internal, tid | normal
pg_catalog | last_value_time | time without time zone | internal, time without time zone | normal
pg_catalog | last_value_timestamp | timestamp without time zone | internal, timestamp without time zone | normal
pg_catalog | last_value_timestamptz | timestamp with time zone | internal, timestamp with time zone | normal
pg_catalog | last_value_timetz | time with time zone | internal, time with time zone | normal
pg_catalog | last_value_varbit | bit varying | internal, bit varying | normal
pg_catalog | last_value_varchar | character varying | internal, character varying | normal
pg_catalog | last_value_xid | xid | internal, xid | normal
pg_catalog | lastval | bigint | | normal
pg_catalog | latin1_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | latin2_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | latin2_to_win1250 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | latin3_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | latin4_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | lead | anyarray | anyarray | normal
pg_catalog | lead | anyarray | anyarray, bigint | normal
pg_catalog | lead | anyarray | anyarray, bigint, anyarray | normal
pg_catalog | lead | bigint | bigint | normal
pg_catalog | lead | bigint | bigint, bigint | normal
pg_catalog | lead | bigint | bigint, bigint, bigint | normal
pg_catalog | lead | bit | bit | normal
pg_catalog | lead | bit | bit, bigint | normal
pg_catalog | lead | bit | bit, bigint, bit | normal
pg_catalog | lead | bit varying | bit varying | normal
pg_catalog | lead | bit varying | bit varying, bigint | normal
pg_catalog | lead | bit varying | bit varying, bigint, bit varying | normal
pg_catalog | lead | boolean | boolean | normal
pg_catalog | lead | boolean | boolean, bigint | normal
pg_catalog | lead | boolean | boolean, bigint, boolean | normal
pg_catalog | lead | box | box | normal
pg_catalog | lead | box | box, bigint | normal
pg_catalog | lead | box | box, bigint, box | normal
pg_catalog | lead | bytea | bytea | normal
pg_catalog | lead | bytea | bytea, bigint | normal
pg_catalog | lead | bytea | bytea, bigint, bytea | normal
pg_catalog | lead | "char" | "char" | normal
pg_catalog | lead | character varying | character varying | normal
pg_catalog | lead | character varying | character varying, bigint | normal
pg_catalog | lead | character varying | character varying, bigint, character varying | normal
pg_catalog | lead | "char" | "char", bigint | normal
pg_catalog | lead | "char" | "char", bigint, "char" | normal
pg_catalog | lead | cidr | cidr | normal
pg_catalog | lead | cidr | cidr, bigint | normal
pg_catalog | lead | cidr | cidr, bigint, cidr | normal
pg_catalog | lead | circle | circle | normal
pg_catalog | lead | circle | circle, bigint | normal
pg_catalog | lead | circle | circle, bigint, circle | normal
pg_catalog | lead | double precision | double precision | normal
pg_catalog | lead | double precision | double precision, bigint | normal
pg_catalog | lead | double precision | double precision, bigint, double precision | normal
pg_catalog | lead | inet | inet | normal
pg_catalog | lead | inet | inet, bigint | normal
pg_catalog | lead | inet | inet, bigint, inet | normal
pg_catalog | lead | integer | integer | normal
pg_catalog | lead | integer | integer, bigint | normal
pg_catalog | lead | integer | integer, bigint, integer | normal
pg_catalog | lead | interval | interval | normal
pg_catalog | lead | interval | interval, bigint | normal
pg_catalog | lead | interval | interval, bigint, interval | normal
pg_catalog | lead | line | line | normal
pg_catalog | lead | line | line, bigint | normal
pg_catalog | lead | line | line, bigint, line | normal
pg_catalog | lead | lseg | lseg | normal
pg_catalog | lead | lseg | lseg, bigint | normal
pg_catalog | lead | lseg | lseg, bigint, lseg | normal
pg_catalog | lead | macaddr | macaddr | normal
pg_catalog | lead | macaddr | macaddr, bigint | normal
pg_catalog | lead | macaddr | macaddr, bigint, macaddr | normal
pg_catalog | lead | money | money | normal
pg_catalog | lead | money | money, bigint | normal
pg_catalog | lead | money | money, bigint, money | normal
pg_catalog | lead | name | name | normal
pg_catalog | lead | name | name, bigint | normal
pg_catalog | lead | name | name, bigint, name | normal
pg_catalog | lead | numeric | numeric | normal
pg_catalog | lead | numeric | numeric, bigint | normal
pg_catalog | lead | numeric | numeric, bigint, numeric | normal
pg_catalog | lead | oid | oid | normal
pg_catalog | lead | oid | oid, bigint | normal
pg_catalog | lead | oid | oid, bigint, oid | normal
pg_catalog | lead | path | path | normal
pg_catalog | lead | path | path, bigint | normal
pg_catalog | lead | path | path, bigint, path | normal
pg_catalog | lead | point | point | normal
pg_catalog | lead | point | point, bigint | normal
pg_catalog | lead | point | point, bigint, point | normal
pg_catalog | lead | polygon | polygon | normal
pg_catalog | lead | polygon | polygon, bigint | normal
pg_catalog | lead | polygon | polygon, bigint, polygon | normal
pg_catalog | lead | real | real | normal
pg_catalog | lead | real | real, bigint | normal
pg_catalog | lead | real | real, bigint, real | normal
pg_catalog | lead | reltime | reltime | normal
pg_catalog | lead | reltime | reltime, bigint | normal
pg_catalog | lead | reltime | reltime, bigint, reltime | normal
pg_catalog | lead | smallint | smallint | normal
pg_catalog | lead | smallint | smallint, bigint | normal
pg_catalog | lead | smallint | smallint, bigint, smallint | normal
pg_catalog | lead | text | text | normal
pg_catalog | lead | text | text, bigint | normal
pg_catalog | lead | text | text, bigint, text | normal
pg_catalog | lead | tid | tid | normal
pg_catalog | lead | tid | tid, bigint | normal
pg_catalog | lead | tid | tid, bigint, tid | normal
pg_catalog | lead | timestamp without time zone | timestamp without time zone | normal
pg_catalog | lead | timestamp without time zone | timestamp without time zone, bigint | normal
pg_catalog | lead | timestamp without time zone | timestamp without time zone, bigint, timestamp without time zone | normal
pg_catalog | lead | timestamp with time zone | timestamp with time zone | normal
pg_catalog | lead | timestamp with time zone | timestamp with time zone, bigint | normal
pg_catalog | lead | timestamp with time zone | timestamp with time zone, bigint, timestamp with time zone | normal
pg_catalog | lead | time without time zone | time without time zone | normal
pg_catalog | lead | time without time zone | time without time zone, bigint | normal
pg_catalog | lead | time without time zone | time without time zone, bigint, time without time zone | normal
pg_catalog | lead | time with time zone | time with time zone | normal
pg_catalog | lead | time with time zone | time with time zone, bigint | normal
pg_catalog | lead | time with time zone | time with time zone, bigint, time with time zone | normal
pg_catalog | lead | xid | xid | normal
pg_catalog | lead | xid | xid, bigint | normal
pg_catalog | lead | xid | xid, bigint, xid | normal
pg_catalog | lead_any | anyarray | internal, anyarray | normal
pg_catalog | lead_any | anyarray | internal, anyarray, bigint | normal
pg_catalog | lead_any | anyarray | internal, anyarray, bigint, anyarray | normal
pg_catalog | lead_bit | bit | internal, bit | normal
pg_catalog | lead_bit | bit | internal, bit, bigint | normal
pg_catalog | lead_bit | bit | internal, bit, bigint, bit | normal
pg_catalog | lead_bool | boolean | internal, boolean | normal
pg_catalog | lead_bool | boolean | internal, boolean, bigint | normal
pg_catalog | lead_bool | boolean | internal, boolean, bigint, boolean | normal
pg_catalog | lead_box | box | internal, box | normal
pg_catalog | lead_box | box | internal, box, bigint | normal
pg_catalog | lead_box | box | internal, box, bigint, box | normal
pg_catalog | lead_bytea | bytea | internal, bytea | normal
pg_catalog | lead_bytea | bytea | internal, bytea, bigint | normal
pg_catalog | lead_bytea | bytea | internal, bytea, bigint, bytea | normal
pg_catalog | lead_char | "char" | internal, "char" | normal
pg_catalog | lead_char | "char" | internal, "char", bigint | normal
pg_catalog | lead_char | "char" | internal, "char", bigint, "char" | normal
pg_catalog | lead_cidr | cidr | internal, cidr | normal
pg_catalog | lead_cidr | cidr | internal, cidr, bigint | normal
pg_catalog | lead_cidr | cidr | internal, cidr, bigint, cidr | normal
pg_catalog | lead_circle | circle | internal, circle | normal
pg_catalog | lead_circle | circle | internal, circle, bigint | normal
pg_catalog | lead_circle | circle | internal, circle, bigint, circle | normal
pg_catalog | lead_float4 | real | internal, real | normal
pg_catalog | lead_float4 | real | internal, real, bigint | normal
pg_catalog | lead_float4 | real | internal, real, bigint, real | normal
pg_catalog | lead_float8 | double precision | internal, double precision | normal
pg_catalog | lead_float8 | double precision | internal, double precision, bigint | normal
pg_catalog | lead_float8 | double precision | internal, double precision, bigint, double precision | normal
pg_catalog | lead_inet | inet | internal, inet | normal
pg_catalog | lead_inet | inet | internal, inet, bigint | normal
pg_catalog | lead_inet | inet | internal, inet, bigint, inet | normal
pg_catalog | lead_int | integer | internal, integer | normal
pg_catalog | lead_int | integer | internal, integer, bigint | normal
pg_catalog | lead_int | integer | internal, integer, bigint, integer | normal
pg_catalog | lead_int8 | bigint | internal, bigint | normal
pg_catalog | lead_int8 | bigint | internal, bigint, bigint | normal
pg_catalog | lead_int8 | bigint | internal, bigint, bigint, bigint | normal
pg_catalog | lead_interval | interval | internal, interval | normal
pg_catalog | lead_interval | interval | internal, interval, bigint | normal
pg_catalog | lead_interval | interval | internal, interval, bigint, interval | normal
pg_catalog | lead_line | line | internal, line | normal
pg_catalog | lead_line | line | internal, line, bigint | normal
pg_catalog | lead_line | line | internal, line, bigint, line | normal
pg_catalog | lead_lseg | lseg | internal, lseg | normal
pg_catalog | lead_lseg | lseg | internal, lseg, bigint | normal
pg_catalog | lead_lseg | lseg | internal, lseg, bigint, lseg | normal
pg_catalog | lead_macaddr | macaddr | internal, macaddr | normal
pg_catalog | lead_macaddr | macaddr | internal, macaddr, bigint | normal
pg_catalog | lead_macaddr | macaddr | internal, macaddr, bigint, macaddr | normal
pg_catalog | lead_money | money | internal, money | normal
pg_catalog | lead_money | money | internal, money, bigint | normal
pg_catalog | lead_money | money | internal, money, bigint, money | normal
pg_catalog | lead_name | name | internal, name | normal
pg_catalog | lead_name | name | internal, name, bigint | normal
pg_catalog | lead_name | name | internal, name, bigint, name | normal
pg_catalog | lead_numeric | numeric | internal, numeric | normal
pg_catalog | lead_numeric | numeric | internal, numeric, bigint | normal
pg_catalog | lead_numeric | numeric | internal, numeric, bigint, numeric | normal
pg_catalog | lead_oid | oid | internal, oid | normal
pg_catalog | lead_oid | oid | internal, oid, bigint | normal
pg_catalog | lead_oid | oid | internal, oid, bigint, oid | normal
pg_catalog | lead_path | path | internal, path | normal
pg_catalog | lead_path | path | internal, path, bigint | normal
pg_catalog | lead_path | path | internal, path, bigint, path | normal
pg_catalog | lead_point | point | internal, point | normal
pg_catalog | lead_point | point | internal, point, bigint | normal
pg_catalog | lead_point | point | internal, point, bigint, point | normal
pg_catalog | lead_polygon | polygon | internal, polygon | normal
pg_catalog | lead_polygon | polygon | internal, polygon, bigint | normal
pg_catalog | lead_polygon | polygon | internal, polygon, bigint, polygon | normal
pg_catalog | lead_reltime | reltime | internal, reltime | normal
pg_catalog | lead_reltime | reltime | internal, reltime, bigint | normal
pg_catalog | lead_reltime | reltime | internal, reltime, bigint, reltime | normal
pg_catalog | lead_smallint | smallint | internal, smallint | normal
pg_catalog | lead_smallint | smallint | internal, smallint, bigint | normal
pg_catalog | lead_smallint | smallint | internal, smallint, bigint, smallint | normal
pg_catalog | lead_text | text | internal, text | normal
pg_catalog | lead_text | text | internal, text, bigint | normal
pg_catalog | lead_text | text | internal, text, bigint, text | normal
pg_catalog | lead_tid | tid | internal, tid | normal
pg_catalog | lead_tid | tid | internal, tid, bigint | normal
pg_catalog | lead_tid | tid | internal, tid, bigint, tid | normal
pg_catalog | lead_time | time without time zone | internal, time without time zone | normal
pg_catalog | lead_time | time without time zone | internal, time without time zone, bigint | normal
pg_catalog | lead_time | time without time zone | internal, time without time zone, bigint, time without time zone | normal
pg_catalog | lead_timestamp | timestamp without time zone | internal, timestamp without time zone | normal
pg_catalog | lead_timestamp | timestamp without time zone | internal, timestamp without time zone, bigint | normal
pg_catalog | lead_timestamp | timestamp without time zone | internal, timestamp without time zone, bigint, timestamp without time zone | normal
pg_catalog | lead_timestamptz | timestamp with time zone | internal, timestamp with time zone | normal
pg_catalog | lead_timestamptz | timestamp with time zone | internal, timestamp with time zone, bigint | normal
pg_catalog | lead_timestamptz | timestamp with time zone | internal, timestamp with time zone, bigint, timestamp with time zone | normal
pg_catalog | lead_timetz | time with time zone | internal, time with time zone | normal
pg_catalog | lead_timetz | time with time zone | internal, time with time zone, bigint | normal
pg_catalog | lead_timetz | time with time zone | internal, time with time zone, bigint, time with time zone | normal
pg_catalog | lead_varbit | bit varying | internal, bit varying | normal
pg_catalog | lead_varbit | bit varying | internal, bit varying, bigint | normal
pg_catalog | lead_varbit | bit varying | internal, bit varying, bigint, bit varying | normal
pg_catalog | lead_varchar | character varying | internal, character varying | normal
pg_catalog | lead_varchar | character varying | internal, character varying, bigint | normal
pg_catalog | lead_varchar | character varying | internal, character varying, bigint, character varying | normal
pg_catalog | lead_xid | xid | internal, xid | normal
pg_catalog | lead_xid | xid | internal, xid, bigint | normal
pg_catalog | lead_xid | xid | internal, xid, bigint, xid | normal
pg_catalog | length | integer | bit | normal
pg_catalog | length | integer | bytea | normal
pg_catalog | length | integer | character | normal
pg_catalog | length | double precision | lseg | normal
pg_catalog | length | double precision | path | normal
pg_catalog | length | integer | text | normal
pg_catalog | like | boolean | bytea, bytea | normal
pg_catalog | like | boolean | name, text | normal
pg_catalog | like | boolean | text, text | normal
pg_catalog | like_escape | bytea | bytea, bytea | normal
pg_catalog | like_escape | text | text, text | normal
pg_catalog | likejoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | likesel | double precision | internal, oid, internal, integer | normal
pg_catalog | line | line | point, point | normal
pg_catalog | line_distance | double precision | line, line | normal
pg_catalog | line_eq | boolean | line, line | normal
pg_catalog | line_horizontal | boolean | line | normal
pg_catalog | line_in | line | cstring | normal
pg_catalog | line_interpt | point | line, line | normal
pg_catalog | line_intersect | boolean | line, line | normal
pg_catalog | line_out | cstring | line | normal
pg_catalog | line_parallel | boolean | line, line | normal
pg_catalog | line_perp | boolean | line, line | normal
pg_catalog | line_recv | line | internal | normal
pg_catalog | line_send | bytea | line | normal
pg_catalog | line_vertical | boolean | line | normal
pg_catalog | ln | double precision | double precision | normal
pg_catalog | ln | numeric | numeric | normal
pg_catalog | lo_close | integer | integer | normal
pg_catalog | lo_creat | oid | integer | normal
pg_catalog | lo_create | oid | oid | normal
pg_catalog | lo_export | integer | oid, text | normal
pg_catalog | lo_import | oid | text | normal
pg_catalog | lo_lseek | integer | integer, integer, integer | normal
pg_catalog | lo_open | integer | oid, integer | normal
pg_catalog | lo_tell | integer | integer | normal
pg_catalog | lo_truncate | integer | integer, integer | normal
pg_catalog | lo_unlink | integer | oid | normal
pg_catalog | log | double precision | double precision | normal
pg_catalog | log | numeric | numeric | normal
pg_catalog | log | numeric | numeric, numeric | normal
pg_catalog | loread | bytea | integer, integer | normal
pg_catalog | lower | text | text | normal
pg_catalog | lowrite | integer | integer, bytea | normal
pg_catalog | lpad | text | text, integer | normal
pg_catalog | lpad | text | text, integer, text | normal
pg_catalog | lseg | lseg | box | normal
pg_catalog | lseg | lseg | point, point | normal
pg_catalog | lseg_center | point | lseg | normal
pg_catalog | lseg_distance | double precision | lseg, lseg | normal
pg_catalog | lseg_eq | boolean | lseg, lseg | normal
pg_catalog | lseg_ge | boolean | lseg, lseg | normal
pg_catalog | lseg_gt | boolean | lseg, lseg | normal
pg_catalog | lseg_horizontal | boolean | lseg | normal
pg_catalog | lseg_in | lseg | cstring | normal
pg_catalog | lseg_interpt | point | lseg, lseg | normal
pg_catalog | lseg_intersect | boolean | lseg, lseg | normal
pg_catalog | lseg_le | boolean | lseg, lseg | normal
pg_catalog | lseg_length | double precision | lseg | normal
pg_catalog | lseg_lt | boolean | lseg, lseg | normal
pg_catalog | lseg_ne | boolean | lseg, lseg | normal
pg_catalog | lseg_out | cstring | lseg | normal
pg_catalog | lseg_parallel | boolean | lseg, lseg | normal
pg_catalog | lseg_perp | boolean | lseg, lseg | normal
pg_catalog | lseg_recv | lseg | internal | normal
pg_catalog | lseg_send | bytea | lseg | normal
pg_catalog | lseg_vertical | boolean | lseg | normal
pg_catalog | ltrim | text | text | normal
pg_catalog | ltrim | text | text, text | normal
pg_catalog | macaddr | macaddr | text | normal
pg_catalog | macaddr_cmp | integer | macaddr, macaddr | normal
pg_catalog | macaddr_eq | boolean | macaddr, macaddr | normal
pg_catalog | macaddr_ge | boolean | macaddr, macaddr | normal
pg_catalog | macaddr_gt | boolean | macaddr, macaddr | normal
pg_catalog | macaddr_in | macaddr | cstring | normal
pg_catalog | macaddr_le | boolean | macaddr, macaddr | normal
pg_catalog | macaddr_lt | boolean | macaddr, macaddr | normal
pg_catalog | macaddr_ne | boolean | macaddr, macaddr | normal
pg_catalog | macaddr_out | cstring | macaddr | normal
pg_catalog | macaddr_recv | macaddr | internal | normal
pg_catalog | macaddr_send | bytea | macaddr | normal
pg_catalog | makeaclitem | aclitem | oid, oid, text, boolean | normal
pg_catalog | masklen | integer | inet | normal
pg_catalog | matrix_add | bigint[] | bigint[], bigint[] | normal
pg_catalog | matrix_add | double precision[] | double precision[], double precision[] | normal
pg_catalog | matrix_add | integer[] | integer[], integer[] | normal
pg_catalog | matrix_add | smallint[] | smallint[], smallint[] | normal
pg_catalog | matrix_multiply | bigint[] | bigint[], bigint | normal
pg_catalog | matrix_multiply | bigint[] | bigint[], bigint[] | normal
pg_catalog | matrix_multiply | double precision[] | double precision[], double precision | normal
pg_catalog | matrix_multiply | double precision[] | double precision[], double precision[] | normal
pg_catalog | matrix_multiply | bigint[] | integer[], integer[] | normal
pg_catalog | matrix_multiply | bigint[] | smallint[], smallint[] | normal
pg_catalog | matrix_transpose | anyarray | anyarray | normal
pg_catalog | max | abstime | abstime | agg
pg_catalog | max | anyarray | anyarray | agg
pg_catalog | max | bigint | bigint | agg
pg_catalog | max | character | character | agg
pg_catalog | max | date | date | agg
pg_catalog | max | double precision | double precision | agg
pg_catalog | max | gpxlogloc | gpxlogloc | agg
pg_catalog | max | integer | integer | agg
pg_catalog | max | interval | interval | agg
pg_catalog | max | money | money | agg
pg_catalog | max | numeric | numeric | agg
pg_catalog | max | oid | oid | agg
pg_catalog | max | real | real | agg
pg_catalog | max | smallint | smallint | agg
pg_catalog | max | text | text | agg
pg_catalog | max | tid | tid | agg
pg_catalog | max | timestamp without time zone | timestamp without time zone | agg
pg_catalog | max | timestamp with time zone | timestamp with time zone | agg
pg_catalog | max | time without time zone | time without time zone | agg
pg_catalog | max | time with time zone | time with time zone | agg
pg_catalog | md5 | text | bytea | normal
pg_catalog | md5 | text | text | normal
pg_catalog | mic_to_ascii | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_big5 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_euc_cn | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_euc_jp | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_euc_kr | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_euc_tw | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_iso | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_koi8r | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_latin1 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_latin2 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_latin3 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_latin4 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_sjis | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_win1250 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_win1251 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | mic_to_win866 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | min | abstime | abstime | agg
pg_catalog | min | anyarray | anyarray | agg
pg_catalog | min | bigint | bigint | agg
pg_catalog | min | character | character | agg
pg_catalog | min | date | date | agg
pg_catalog | min | double precision | double precision | agg
pg_catalog | min | gpxlogloc | gpxlogloc | agg
pg_catalog | min | integer | integer | agg
pg_catalog | min | interval | interval | agg
pg_catalog | min | money | money | agg
pg_catalog | min | numeric | numeric | agg
pg_catalog | min | oid | oid | agg
pg_catalog | min | real | real | agg
pg_catalog | min | smallint | smallint | agg
pg_catalog | min | text | text | agg
pg_catalog | min | tid | tid | agg
pg_catalog | min | timestamp without time zone | timestamp without time zone | agg
pg_catalog | min | timestamp with time zone | timestamp with time zone | agg
pg_catalog | min | time without time zone | time without time zone | agg
pg_catalog | min | time with time zone | time with time zone | agg
pg_catalog | mktinterval | tinterval | abstime, abstime | normal
pg_catalog | mod | bigint | bigint, bigint | normal
pg_catalog | mod | integer | integer, integer | normal
pg_catalog | mod | integer | integer, smallint | normal
pg_catalog | mod | numeric | numeric, numeric | normal
pg_catalog | mod | integer | smallint, integer | normal
pg_catalog | mod | smallint | smallint, smallint | normal
pg_catalog | mregr_coef | double precision[] | double precision, double precision[] | agg
pg_catalog | mregr_pvalues | double precision[] | double precision, double precision[] | agg
pg_catalog | mregr_r2 | double precision | double precision, double precision[] | agg
pg_catalog | mregr_tstats | double precision[] | double precision, double precision[] | agg
pg_catalog | mul_d_interval | interval | double precision, interval | normal
pg_catalog | name | name | character | normal
pg_catalog | name | name | character varying | normal
pg_catalog | name | name | text | normal
pg_catalog | name_pattern_eq | boolean | name, name | normal
pg_catalog | name_pattern_ge | boolean | name, name | normal
pg_catalog | name_pattern_gt | boolean | name, name | normal
pg_catalog | name_pattern_le | boolean | name, name | normal
pg_catalog | name_pattern_lt | boolean | name, name | normal
pg_catalog | name_pattern_ne | boolean | name, name | normal
pg_catalog | nameeq | boolean | name, name | normal
pg_catalog | namege | boolean | name, name | normal
pg_catalog | namegt | boolean | name, name | normal
pg_catalog | nameiclike | boolean | name, text | normal
pg_catalog | nameicnlike | boolean | name, text | normal
pg_catalog | nameicregexeq | boolean | name, text | normal
pg_catalog | nameicregexne | boolean | name, text | normal
pg_catalog | namein | name | cstring | normal
pg_catalog | namele | boolean | name, name | normal
pg_catalog | namelike | boolean | name, text | normal
pg_catalog | namelt | boolean | name, name | normal
pg_catalog | namene | boolean | name, name | normal
pg_catalog | namenlike | boolean | name, text | normal
pg_catalog | nameout | cstring | name | normal
pg_catalog | namerecv | name | internal | normal
pg_catalog | nameregexeq | boolean | name, text | normal
pg_catalog | nameregexne | boolean | name, text | normal
pg_catalog | namesend | bytea | name | normal
pg_catalog | nb_classify | text | text[], bigint, bigint[], bigint[] | agg
pg_catalog | nb_classify_accum | nb_classification | nb_classification, text[], bigint, bigint[], bigint[] | normal
pg_catalog | nb_classify_combine | nb_classification | nb_classification, nb_classification | normal
pg_catalog | nb_classify_final | text | nb_classification | normal
pg_catalog | nb_classify_probabilities | double precision[] | nb_classification | normal
pg_catalog | nb_probabilities | double precision[] | text[], bigint, bigint[], bigint[] | agg
pg_catalog | neqjoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | neqsel | double precision | internal, oid, internal, integer | normal
pg_catalog | netmask | inet | inet | normal
pg_catalog | network | cidr | inet | normal
pg_catalog | network_cmp | integer | inet, inet | normal
pg_catalog | network_eq | boolean | inet, inet | normal
pg_catalog | network_ge | boolean | inet, inet | normal
pg_catalog | network_gt | boolean | inet, inet | normal
pg_catalog | network_le | boolean | inet, inet | normal
pg_catalog | network_lt | boolean | inet, inet | normal
pg_catalog | network_ne | boolean | inet, inet | normal
pg_catalog | network_sub | boolean | inet, inet | normal
pg_catalog | network_subeq | boolean | inet, inet | normal
pg_catalog | network_sup | boolean | inet, inet | normal
pg_catalog | network_supeq | boolean | inet, inet | normal
pg_catalog | nextval | bigint | regclass | normal
pg_catalog | nlikejoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | nlikesel | double precision | internal, oid, internal, integer | normal
pg_catalog | nonnullvalue | boolean | "any" | normal
pg_catalog | notlike | boolean | bytea, bytea | normal
pg_catalog | notlike | boolean | name, text | normal
pg_catalog | notlike | boolean | text, text | normal
pg_catalog | now | timestamp with time zone | | normal
pg_catalog | npoints | integer | path | normal
pg_catalog | npoints | integer | polygon | normal
pg_catalog | ntile | bigint | bigint | normal
pg_catalog | ntile | bigint | integer | normal
pg_catalog | ntile | bigint | numeric | normal
pg_catalog | ntile_final | bigint | bigint[], bigint | normal
pg_catalog | ntile_prelim_bigint | bigint[] | internal, bigint | normal
pg_catalog | ntile_prelim_int | bigint[] | internal, integer | normal
pg_catalog | ntile_prelim_numeric | bigint[] | internal, numeric | normal
pg_catalog | nullvalue | boolean | "any" | normal
pg_catalog | numeric | numeric | bigint | normal
pg_catalog | numeric | numeric | double precision | normal
pg_catalog | numeric | numeric | integer | normal
pg_catalog | numeric | numeric | numeric, integer | normal
pg_catalog | numeric | numeric | real | normal
pg_catalog | numeric | numeric | smallint | normal
pg_catalog | numeric | numeric | text | normal
pg_catalog | numeric_abs | numeric | numeric | normal
pg_catalog | numeric_accum | numeric[] | numeric[], numeric | normal
pg_catalog | numeric_add | numeric | numeric, numeric | normal
pg_catalog | numeric_amalg | numeric[] | numeric[], numeric[] | normal
pg_catalog | numeric_avg | numeric | bytea | normal
pg_catalog | numeric_avg_accum | bytea | bytea, numeric | normal
pg_catalog | numeric_avg_amalg | bytea | bytea, bytea | normal
pg_catalog | numeric_avg_decum | bytea | bytea, numeric | normal
pg_catalog | numeric_avg_demalg | bytea | bytea, bytea | normal
pg_catalog | numeric_cmp | integer | numeric, numeric | normal
pg_catalog | numeric_dec | numeric | numeric | normal
pg_catalog | numeric_decum | numeric[] | numeric[], numeric | normal
pg_catalog | numeric_demalg | numeric[] | numeric[], numeric[] | normal
pg_catalog | numeric_div | numeric | numeric, numeric | normal
pg_catalog | numeric_eq | boolean | numeric, numeric | normal
pg_catalog | numeric_exp | numeric | numeric | normal
pg_catalog | numeric_fac | numeric | bigint | normal
pg_catalog | numeric_ge | boolean | numeric, numeric | normal
pg_catalog | numeric_gt | boolean | numeric, numeric | normal
pg_catalog | numeric_in | numeric | cstring, oid, integer | normal
pg_catalog | numeric_inc | numeric | numeric | normal
pg_catalog | numeric_larger | numeric | numeric, numeric | normal
pg_catalog | numeric_le | boolean | numeric, numeric | normal
pg_catalog | numeric_ln | numeric | numeric | normal
pg_catalog | numeric_log | numeric | numeric, numeric | normal
pg_catalog | numeric_lt | boolean | numeric, numeric | normal
pg_catalog | numeric_mod | numeric | numeric, numeric | normal
pg_catalog | numeric_mul | numeric | numeric, numeric | normal
pg_catalog | numeric_ne | boolean | numeric, numeric | normal
pg_catalog | numeric_out | cstring | numeric | normal
pg_catalog | numeric_power | numeric | numeric, numeric | normal
pg_catalog | numeric_recv | numeric | internal, oid, integer | normal
pg_catalog | numeric_send | bytea | numeric | normal
pg_catalog | numeric_smaller | numeric | numeric, numeric | normal
pg_catalog | numeric_sqrt | numeric | numeric | normal
pg_catalog | numeric_stddev_pop | numeric | numeric[] | normal
pg_catalog | numeric_stddev_samp | numeric | numeric[] | normal
pg_catalog | numeric_sub | numeric | numeric, numeric | normal
pg_catalog | numeric_uminus | numeric | numeric | normal
pg_catalog | numeric_uplus | numeric | numeric | normal
pg_catalog | numeric_var_pop | numeric | numeric[] | normal
pg_catalog | numeric_var_samp | numeric | numeric[] | normal
pg_catalog | obj_description | text | oid | normal
pg_catalog | obj_description | text | oid, name | normal
pg_catalog | octet_length | integer | bit | normal
pg_catalog | octet_length | integer | bytea | normal
pg_catalog | octet_length | integer | character | normal
pg_catalog | octet_length | integer | text | normal
pg_catalog | oid | oid | bigint | normal
pg_catalog | oid | oid | text | normal
pg_catalog | oideq | boolean | oid, oid | normal
pg_catalog | oidge | boolean | oid, oid | normal
pg_catalog | oidgt | boolean | oid, oid | normal
pg_catalog | oidin | oid | cstring | normal
pg_catalog | oidlarger | oid | oid, oid | normal
pg_catalog | oidle | boolean | oid, oid | normal
pg_catalog | oidlt | boolean | oid, oid | normal
pg_catalog | oidne | boolean | oid, oid | normal
pg_catalog | oidnotin | boolean | oid, text | normal
pg_catalog | oidout | cstring | oid | normal
pg_catalog | oidrecv | oid | internal | normal
pg_catalog | oidsend | bytea | oid | normal
pg_catalog | oidsmaller | oid | oid, oid | normal
pg_catalog | oidvectoreq | boolean | oidvector, oidvector | normal
pg_catalog | oidvectorge | boolean | oidvector, oidvector | normal
pg_catalog | oidvectorgt | boolean | oidvector, oidvector | normal
pg_catalog | oidvectorin | oidvector | cstring | normal
pg_catalog | oidvectorle | boolean | oidvector, oidvector | normal
pg_catalog | oidvectorlt | boolean | oidvector, oidvector | normal
pg_catalog | oidvectorne | boolean | oidvector, oidvector | normal
pg_catalog | oidvectorout | cstring | oidvector | normal
pg_catalog | oidvectorrecv | oidvector | internal | normal
pg_catalog | oidvectorsend | bytea | oidvector | normal
pg_catalog | oidvectortypes | text | oidvector | normal
pg_catalog | on_pb | boolean | point, box | normal
pg_catalog | on_pl | boolean | point, line | normal
pg_catalog | on_ppath | boolean | point, path | normal
pg_catalog | on_ps | boolean | point, lseg | normal
pg_catalog | on_sb | boolean | lseg, box | normal
pg_catalog | on_sl | boolean | lseg, line | normal
pg_catalog | opaque_in | opaque | cstring | normal
pg_catalog | opaque_out | cstring | opaque | normal
pg_catalog | overlaps | boolean | timestamp without time zone, interval, timestamp without time zone, interval | normal
pg_catalog | overlaps | boolean | timestamp without time zone, interval, timestamp without time zone, timestamp without time zone | normal
pg_catalog | overlaps | boolean | timestamp without time zone, timestamp without time zone, timestamp without time zone, interval | normal
pg_catalog | overlaps | boolean | timestamp without time zone, timestamp without time zone, timestamp without time zone, timestamp without time zone | normal
pg_catalog | overlaps | boolean | timestamp with time zone, interval, timestamp with time zone, interval | normal
pg_catalog | overlaps | boolean | timestamp with time zone, interval, timestamp with time zone, timestamp with time zone | normal
pg_catalog | overlaps | boolean | timestamp with time zone, timestamp with time zone, timestamp with time zone, interval | normal
pg_catalog | overlaps | boolean | timestamp with time zone, timestamp with time zone, timestamp with time zone, timestamp with time zone | normal
pg_catalog | overlaps | boolean | time without time zone, interval, time without time zone, interval | normal
pg_catalog | overlaps | boolean | time without time zone, interval, time without time zone, time without time zone | normal
pg_catalog | overlaps | boolean | time without time zone, time without time zone, time without time zone, interval | normal
pg_catalog | overlaps | boolean | time without time zone, time without time zone, time without time zone, time without time zone | normal
pg_catalog | overlaps | boolean | time with time zone, time with time zone, time with time zone, time with time zone | normal
pg_catalog | overlay | text | text, text, integer | normal
pg_catalog | overlay | text | text, text, integer, integer | normal
pg_catalog | path | path | polygon | normal
pg_catalog | path_add | path | path, path | normal
pg_catalog | path_add_pt | path | path, point | normal
pg_catalog | path_center | point | path | normal
pg_catalog | path_contain_pt | boolean | path, point | normal
pg_catalog | path_distance | double precision | path, path | normal
pg_catalog | path_div_pt | path | path, point | normal
pg_catalog | path_in | path | cstring | normal
pg_catalog | path_inter | boolean | path, path | normal
pg_catalog | path_length | double precision | path | normal
pg_catalog | path_mul_pt | path | path, point | normal
pg_catalog | path_n_eq | boolean | path, path | normal
pg_catalog | path_n_ge | boolean | path, path | normal
pg_catalog | path_n_gt | boolean | path, path | normal
pg_catalog | path_n_le | boolean | path, path | normal
pg_catalog | path_n_lt | boolean | path, path | normal
pg_catalog | path_npoints | integer | path | normal
pg_catalog | path_out | cstring | path | normal
pg_catalog | path_recv | path | internal | normal
pg_catalog | path_send | bytea | path | normal
pg_catalog | path_sub_pt | path | path, point | normal
pg_catalog | pclose | path | path | normal
pg_catalog | percent_rank | double precision | | normal
pg_catalog | percent_rank_final | double precision | bigint, bigint | normal
pg_catalog | pg_advisory_lock | void | bigint | normal
pg_catalog | pg_advisory_lock | void | integer, integer | normal
pg_catalog | pg_advisory_lock_shared | void | bigint | normal
pg_catalog | pg_advisory_lock_shared | void | integer, integer | normal
pg_catalog | pg_advisory_unlock | boolean | bigint | normal
pg_catalog | pg_advisory_unlock | boolean | integer, integer | normal
pg_catalog | pg_advisory_unlock_all | void | | normal
pg_catalog | pg_advisory_unlock_shared | boolean | bigint | normal
pg_catalog | pg_advisory_unlock_shared | boolean | integer, integer | normal
pg_catalog | pg_backend_pid | integer | | normal
pg_catalog | pg_cancel_backend | boolean | integer | normal
pg_catalog | pg_char_to_encoding | integer | name | normal
pg_catalog | pg_client_encoding | name | | normal
pg_catalog | pg_column_size | integer | "any" | normal
pg_catalog | pg_conversion_is_visible | boolean | oid | normal
pg_catalog | pg_current_xlog_insert_location | text | | normal
pg_catalog | pg_current_xlog_location | text | | normal
pg_catalog | pg_cursor | SETOF record | | normal
pg_catalog | pg_database_size | bigint | name | normal
pg_catalog | pg_database_size | bigint | oid | normal
pg_catalog | pg_encoding_to_char | name | integer | normal
pg_catalog | pg_file_length | bigint | text | normal
pg_catalog | pg_file_read | text | text, bigint, bigint | normal
pg_catalog | pg_file_rename | boolean | text, text, text | normal
pg_catalog | pg_file_unlink | boolean | text | normal
pg_catalog | pg_file_write | bigint | text, text, boolean | normal
pg_catalog | pg_function_is_visible | boolean | oid | normal
pg_catalog | pg_get_constraintdef | text | oid | normal
pg_catalog | pg_get_constraintdef | text | oid, boolean | normal
pg_catalog | pg_get_expr | text | text, oid | normal
pg_catalog | pg_get_expr | text | text, oid, boolean | normal
pg_catalog | pg_get_indexdef | text | oid | normal
pg_catalog | pg_get_indexdef | text | oid, integer, boolean | normal
pg_catalog | pg_get_keywords | SETOF record | OUT word text, OUT catcode "char", OUT catdesc text | normal
pg_catalog | pg_get_partition_def | text | oid | normal
pg_catalog | pg_get_partition_def | text | oid, boolean | normal
pg_catalog | pg_get_partition_def | text | oid, boolean, boolean | normal
pg_catalog | pg_get_partition_rule_def | text | oid | normal
pg_catalog | pg_get_partition_rule_def | text | oid, boolean | normal
pg_catalog | pg_get_partition_template_def | text | oid, boolean, boolean | normal
pg_catalog | pg_get_ruledef | text | oid | normal
pg_catalog | pg_get_ruledef | text | oid, boolean | normal
pg_catalog | pg_get_serial_sequence | text | text, text | normal
pg_catalog | pg_get_triggerdef | text | oid | normal
pg_catalog | pg_get_userbyid | name | oid | normal
pg_catalog | pg_get_viewdef | text | oid | normal
pg_catalog | pg_get_viewdef | text | oid, boolean | normal
pg_catalog | pg_get_viewdef | text | text | normal
pg_catalog | pg_get_viewdef | text | text, boolean | normal
pg_catalog | pg_has_role | boolean | name, name, text | normal
pg_catalog | pg_has_role | boolean | name, oid, text | normal
pg_catalog | pg_has_role | boolean | name, text | normal
pg_catalog | pg_has_role | boolean | oid, name, text | normal
pg_catalog | pg_has_role | boolean | oid, oid, text | normal
pg_catalog | pg_has_role | boolean | oid, text | normal
pg_catalog | pg_highest_oid | oid | | normal
pg_catalog | pg_is_other_temp_schema | boolean | oid | normal
pg_catalog | pg_lock_status | SETOF record | | normal
pg_catalog | pg_logdir_ls | SETOF record | | normal
pg_catalog | pg_logfile_rotate | boolean | | normal
pg_catalog | pg_ls_dir | SETOF text | text | normal
pg_catalog | pg_my_temp_schema | oid | | normal
pg_catalog | pg_objname_to_oid | oid | text | normal
pg_catalog | pg_opclass_is_visible | boolean | oid | normal
pg_catalog | pg_operator_is_visible | boolean | oid | normal
pg_catalog | pg_options_to_table | SETOF record | options_array text[], OUT option_name text, OUT option_value text | normal
pg_catalog | pg_partition_oid | oid[] | oid, record | agg
pg_catalog | pg_partition_oid_finalfn | oid[] | internal | normal
pg_catalog | pg_partition_oid_transfn | internal | internal, oid, record | normal
pg_catalog | pg_postmaster_start_time | timestamp with time zone | | normal
pg_catalog | pg_prepared_statement | SETOF record | | normal
pg_catalog | pg_prepared_xact | SETOF record | | normal
pg_catalog | pg_read_file | text | text, bigint, bigint | normal
pg_catalog | pg_relation_size | bigint | oid | normal
pg_catalog | pg_relation_size | bigint | text | normal
pg_catalog | pg_reload_conf | boolean | | normal
pg_catalog | pg_renice_session | integer | integer, integer | normal
pg_catalog | pg_resqueue_status | SETOF record | | normal
pg_catalog | pg_resqueue_status_kv | SETOF record | | normal
pg_catalog | pg_rotate_logfile | boolean | | normal
pg_catalog | pg_show_all_settings | SETOF record | | normal
pg_catalog | pg_size_pretty | text | bigint | normal
pg_catalog | pg_sleep | void | double precision | normal
pg_catalog | pg_start_backup | text | text | normal
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 | normal
pg_catalog | pg_stat_get_activity | SETOF record | pid integer, OUT datid oid, OUT procpid integer, OUT usesysid oid, OUT application_name text, OUT current_query text, OUT waiting boolean, OUT xact_start timestamp with time zone, OUT query_start timestamp with time zone, OUT backend_start timestamp with time zone, OUT client_addr inet, OUT client_port integer, OUT sess_id integer | normal
pg_catalog | pg_stat_get_backend_activity | text | integer | normal
pg_catalog | pg_stat_get_backend_activity_start | timestamp with time zone | integer | normal
pg_catalog | pg_stat_get_backend_client_addr | inet | integer | normal
pg_catalog | pg_stat_get_backend_client_port | integer | integer | normal
pg_catalog | pg_stat_get_backend_dbid | oid | integer | normal
pg_catalog | pg_stat_get_backend_idset | SETOF integer | | normal
pg_catalog | pg_stat_get_backend_pid | integer | integer | normal
pg_catalog | pg_stat_get_backend_session_id | integer | integer | normal
pg_catalog | pg_stat_get_backend_start | timestamp with time zone | integer | normal
pg_catalog | pg_stat_get_backend_userid | oid | integer | normal
pg_catalog | pg_stat_get_backend_waiting | boolean | integer | normal
pg_catalog | pg_stat_get_blocks_fetched | bigint | oid | normal
pg_catalog | pg_stat_get_blocks_hit | bigint | oid | normal
pg_catalog | pg_stat_get_db_blocks_fetched | bigint | oid | normal
pg_catalog | pg_stat_get_db_blocks_hit | bigint | oid | normal
pg_catalog | pg_stat_get_db_numbackends | integer | oid | normal
pg_catalog | pg_stat_get_db_xact_commit | bigint | oid | normal
pg_catalog | pg_stat_get_db_xact_rollback | bigint | oid | normal
pg_catalog | pg_stat_get_last_analyze_time | timestamp with time zone | oid | normal
pg_catalog | pg_stat_get_last_autoanalyze_time | timestamp with time zone | oid | normal
pg_catalog | pg_stat_get_last_autovacuum_time | timestamp with time zone | oid | normal
pg_catalog | pg_stat_get_last_vacuum_time | timestamp with time zone | oid | normal
pg_catalog | pg_stat_get_numscans | bigint | oid | normal
pg_catalog | pg_stat_get_queue_elapsed_exec | bigint | oid | normal
pg_catalog | pg_stat_get_queue_elapsed_wait | bigint | oid | normal
pg_catalog | pg_stat_get_queue_num_exec | bigint | oid | normal
pg_catalog | pg_stat_get_queue_num_wait | bigint | oid | normal
pg_catalog | pg_stat_get_tuples_deleted | bigint | oid | normal
pg_catalog | pg_stat_get_tuples_fetched | bigint | oid | normal
pg_catalog | pg_stat_get_tuples_inserted | bigint | oid | normal
pg_catalog | pg_stat_get_tuples_returned | bigint | oid | normal
pg_catalog | pg_stat_get_tuples_updated | bigint | oid | normal
pg_catalog | pg_stat_reset | boolean | | normal
pg_catalog | pg_stop_backup | text | | normal
pg_catalog | pg_switch_xlog | text | | normal
pg_catalog | pg_table_is_visible | boolean | oid | normal
pg_catalog | pg_tablespace_databases | SETOF oid | oid | normal
pg_catalog | pg_tablespace_size | bigint | name | normal
pg_catalog | pg_tablespace_size | bigint | oid | normal
pg_catalog | pg_terminate_backend | boolean | integer | normal
pg_catalog | pg_timezone_abbrevs | SETOF record | OUT abbrev text, OUT utc_offset interval, OUT is_dst boolean | normal
pg_catalog | pg_timezone_names | SETOF record | OUT name text, OUT abbrev text, OUT utc_offset interval, OUT is_dst boolean | normal
pg_catalog | pg_total_relation_size | bigint | oid | normal
pg_catalog | pg_total_relation_size | bigint | text | normal
pg_catalog | pg_try_advisory_lock | boolean | bigint | normal
pg_catalog | pg_try_advisory_lock | boolean | integer, integer | normal
pg_catalog | pg_try_advisory_lock_shared | boolean | bigint | normal
pg_catalog | pg_try_advisory_lock_shared | boolean | integer, integer | normal
pg_catalog | pg_type_is_visible | boolean | oid | normal
pg_catalog | pg_typeof | regtype | "any" | normal
pg_catalog | pg_xlogfile_name | text | text | normal
pg_catalog | pg_xlogfile_name_offset | record | wal_location text, OUT file_name text, OUT file_offset integer | normal
pg_catalog | pi | double precision | | normal
pg_catalog | pinv | double precision[] | double precision[] | normal
pg_catalog | pivot_sum | bigint[] | text[], text, bigint | agg
pg_catalog | pivot_sum | double precision[] | text[], text, double precision | agg
pg_catalog | pivot_sum | integer[] | text[], text, integer | agg
pg_catalog | plpgsql_call_handler | language_handler | | normal
pg_catalog | plpgsql_validator | void | oid | normal
pg_catalog | point | point | box | normal
pg_catalog | point | point | circle | normal
pg_catalog | point | point | double precision, double precision | normal
pg_catalog | point | point | lseg | normal
pg_catalog | point | point | path | normal
pg_catalog | point | point | polygon | normal
pg_catalog | point_above | boolean | point, point | normal
pg_catalog | point_add | point | point, point | normal
pg_catalog | point_below | boolean | point, point | normal
pg_catalog | point_distance | double precision | point, point | normal
pg_catalog | point_div | point | point, point | normal
pg_catalog | point_eq | boolean | point, point | normal
pg_catalog | point_horiz | boolean | point, point | normal
pg_catalog | point_in | point | cstring | normal
pg_catalog | point_left | boolean | point, point | normal
pg_catalog | point_mul | point | point, point | normal
pg_catalog | point_ne | boolean | point, point | normal
pg_catalog | point_out | cstring | point | normal
pg_catalog | point_recv | point | internal | normal
pg_catalog | point_right | boolean | point, point | normal
pg_catalog | point_send | bytea | point | normal
pg_catalog | point_sub | point | point, point | normal
pg_catalog | point_vert | boolean | point, point | normal
pg_catalog | poly_above | boolean | polygon, polygon | normal
pg_catalog | poly_below | boolean | polygon, polygon | normal
pg_catalog | poly_center | point | polygon | normal
pg_catalog | poly_contain | boolean | polygon, polygon | normal
pg_catalog | poly_contain_pt | boolean | polygon, point | normal
pg_catalog | poly_contained | boolean | polygon, polygon | normal
pg_catalog | poly_distance | double precision | polygon, polygon | normal
pg_catalog | poly_in | polygon | cstring | normal
pg_catalog | poly_left | boolean | polygon, polygon | normal
pg_catalog | poly_npoints | integer | polygon | normal
pg_catalog | poly_out | cstring | polygon | normal
pg_catalog | poly_overabove | boolean | polygon, polygon | normal
pg_catalog | poly_overbelow | boolean | polygon, polygon | normal
pg_catalog | poly_overlap | boolean | polygon, polygon | normal
pg_catalog | poly_overleft | boolean | polygon, polygon | normal
pg_catalog | poly_overright | boolean | polygon, polygon | normal
pg_catalog | poly_recv | polygon | internal | normal
pg_catalog | poly_right | boolean | polygon, polygon | normal
pg_catalog | poly_same | boolean | polygon, polygon | normal
pg_catalog | poly_send | bytea | polygon | normal
pg_catalog | polygon | polygon | box | normal
pg_catalog | polygon | polygon | circle | normal
pg_catalog | polygon | polygon | integer, circle | normal
pg_catalog | polygon | polygon | path | normal
pg_catalog | popen | path | path | normal
pg_catalog | position | integer | bit, bit | normal
pg_catalog | position | integer | bytea, bytea | normal
pg_catalog | position | integer | text, text | normal
pg_catalog | positionjoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | positionsel | double precision | internal, oid, internal, integer | normal
pg_catalog | pow | double precision | double precision, double precision | normal
pg_catalog | pow | numeric | numeric, numeric | normal
pg_catalog | power | double precision | double precision, double precision | normal
pg_catalog | power | numeric | numeric, numeric | normal
pg_catalog | pt_contained_circle | boolean | point, circle | normal
pg_catalog | pt_contained_poly | boolean | point, polygon | normal
pg_catalog | quote_ident | text | text | normal
pg_catalog | quote_literal | text | text | normal
pg_catalog | radians | double precision | double precision | normal
pg_catalog | radius | double precision | circle | normal
pg_catalog | random | double precision | | normal
pg_catalog | rank | bigint | | normal
pg_catalog | rank_immed | bigint | internal | normal
pg_catalog | record_in | record | cstring, oid, integer | normal
pg_catalog | record_out | cstring | record | normal
pg_catalog | record_recv | record | internal, oid, integer | normal
pg_catalog | record_send | bytea | record | normal
pg_catalog | regclass | regclass | text | normal
pg_catalog | regclassin | regclass | cstring | normal
pg_catalog | regclassout | cstring | regclass | normal
pg_catalog | regclassrecv | regclass | internal | normal
pg_catalog | regclasssend | bytea | regclass | normal
pg_catalog | regexeqjoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | regexeqsel | double precision | internal, oid, internal, integer | normal
pg_catalog | regexnejoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | regexnesel | double precision | internal, oid, internal, integer | normal
pg_catalog | regexp_matches | SETOF text[] | text, text | normal
pg_catalog | regexp_matches | SETOF text[] | text, text, text | normal
pg_catalog | regexp_replace | text | text, text, text | normal
pg_catalog | regexp_replace | text | text, text, text, text | normal
pg_catalog | regexp_split_to_array | text[] | text, text | normal
pg_catalog | regexp_split_to_array | text[] | text, text, text | normal
pg_catalog | regexp_split_to_table | SETOF text | text, text | normal
pg_catalog | regexp_split_to_table | SETOF text | text, text, text | normal
pg_catalog | regoperatorin | regoperator | cstring | normal
pg_catalog | regoperatorout | cstring | regoperator | normal
pg_catalog | regoperatorrecv | regoperator | internal | normal
pg_catalog | regoperatorsend | bytea | regoperator | normal
pg_catalog | regoperin | regoper | cstring | normal
pg_catalog | regoperout | cstring | regoper | normal
pg_catalog | regoperrecv | regoper | internal | normal
pg_catalog | regopersend | bytea | regoper | normal
pg_catalog | regprocedurein | regprocedure | cstring | normal
pg_catalog | regprocedureout | cstring | regprocedure | normal
pg_catalog | regprocedurerecv | regprocedure | internal | normal
pg_catalog | regproceduresend | bytea | regprocedure | normal
pg_catalog | regprocin | regproc | cstring | normal
pg_catalog | regprocout | cstring | regproc | normal
pg_catalog | regprocrecv | regproc | internal | normal
pg_catalog | regprocsend | bytea | regproc | normal
pg_catalog | regr_avgx | double precision | double precision, double precision | agg
pg_catalog | regr_avgy | double precision | double precision, double precision | agg
pg_catalog | regr_count | bigint | double precision, double precision | agg
pg_catalog | regr_intercept | double precision | double precision, double precision | agg
pg_catalog | regr_r2 | double precision | double precision, double precision | agg
pg_catalog | regr_slope | double precision | double precision, double precision | agg
pg_catalog | regr_sxx | double precision | double precision, double precision | agg
pg_catalog | regr_sxy | double precision | double precision, double precision | agg
pg_catalog | regr_syy | double precision | double precision, double precision | agg
pg_catalog | regtypein | regtype | cstring | normal
pg_catalog | regtypeout | cstring | regtype | normal
pg_catalog | regtyperecv | regtype | internal | normal
pg_catalog | regtypesend | bytea | regtype | normal
pg_catalog | reltime | reltime | interval | normal
pg_catalog | reltimeeq | boolean | reltime, reltime | normal
pg_catalog | reltimege | boolean | reltime, reltime | normal
pg_catalog | reltimegt | boolean | reltime, reltime | normal
pg_catalog | reltimein | reltime | cstring | normal
pg_catalog | reltimele | boolean | reltime, reltime | normal
pg_catalog | reltimelt | boolean | reltime, reltime | normal
pg_catalog | reltimene | boolean | reltime, reltime | normal
pg_catalog | reltimeout | cstring | reltime | normal
pg_catalog | reltimerecv | reltime | internal | normal
pg_catalog | reltimesend | bytea | reltime | normal
pg_catalog | repeat | text | text, integer | normal
pg_catalog | replace | text | text, text, text | normal
pg_catalog | round | double precision | double precision | normal
pg_catalog | round | numeric | numeric | normal
pg_catalog | round | numeric | numeric, integer | normal
pg_catalog | row_number | bigint | | normal
pg_catalog | row_number_immed | bigint | internal | normal
pg_catalog | rpad | text | text, integer | normal
pg_catalog | rpad | text | text, integer, text | normal
pg_catalog | rtrim | text | text | normal
pg_catalog | rtrim | text | text, text | normal
pg_catalog | scalargtjoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | scalargtsel | double precision | internal, oid, internal, integer | normal
pg_catalog | scalarltjoinsel | double precision | internal, oid, internal, smallint | normal
pg_catalog | scalarltsel | double precision | internal, oid, internal, integer | normal
pg_catalog | session_user | name | | normal
pg_catalog | set_bit | bytea | bytea, integer, integer | normal
pg_catalog | set_byte | bytea | bytea, integer, integer | normal
pg_catalog | set_config | text | text, text, boolean | normal
pg_catalog | set_masklen | cidr | cidr, integer | normal
pg_catalog | set_masklen | inet | inet, integer | normal
pg_catalog | setseed | integer | double precision | normal
pg_catalog | setval | bigint | regclass, bigint | normal
pg_catalog | setval | bigint | regclass, bigint, boolean | normal
pg_catalog | shell_in | opaque | cstring | normal
pg_catalog | shell_out | cstring | opaque | normal
pg_catalog | shift_jis_2004_to_euc_jis_2004 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | shift_jis_2004_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | shobj_description | text | oid, name | normal
pg_catalog | sign | double precision | double precision | normal
pg_catalog | sign | numeric | numeric | normal
pg_catalog | similar_escape | text | text, text | normal
pg_catalog | sin | double precision | double precision | normal
pg_catalog | sinh | double precision | double precision | normal
pg_catalog | sjis_to_euc_jp | void | integer, integer, cstring, internal, integer | normal
pg_catalog | sjis_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | sjis_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | slope | double precision | point, point | normal
pg_catalog | smgreq | boolean | smgr, smgr | normal
pg_catalog | smgrin | smgr | cstring | normal
pg_catalog | smgrne | boolean | smgr, smgr | normal
pg_catalog | smgrout | cstring | smgr | normal
pg_catalog | split_part | text | text, text, integer | normal
pg_catalog | sqrt | double precision | double precision | normal
pg_catalog | sqrt | numeric | numeric | normal
pg_catalog | statement_timestamp | timestamp with time zone | | normal
pg_catalog | stddev | numeric | bigint | agg
pg_catalog | stddev | double precision | double precision | agg
pg_catalog | stddev | numeric | integer | agg
pg_catalog | stddev | numeric | numeric | agg
pg_catalog | stddev | double precision | real | agg
pg_catalog | stddev | numeric | smallint | agg
pg_catalog | stddev_pop | numeric | bigint | agg
pg_catalog | stddev_pop | double precision | double precision | agg
pg_catalog | stddev_pop | numeric | integer | agg
pg_catalog | stddev_pop | numeric | numeric | agg
pg_catalog | stddev_pop | double precision | real | agg
pg_catalog | stddev_pop | numeric | smallint | agg
pg_catalog | stddev_samp | numeric | bigint | agg
pg_catalog | stddev_samp | double precision | double precision | agg
pg_catalog | stddev_samp | numeric | integer | agg
pg_catalog | stddev_samp | numeric | numeric | agg
pg_catalog | stddev_samp | double precision | real | agg
pg_catalog | stddev_samp | numeric | smallint | agg
pg_catalog | string_agg | text | text | agg
pg_catalog | string_agg | text | text, text | agg
pg_catalog | string_agg_delim_transfn | internal | internal, text, text | normal
pg_catalog | string_agg_finalfn | text | internal | normal
pg_catalog | string_agg_transfn | internal | internal, text | normal
pg_catalog | string_to_array | text[] | text, text | normal
pg_catalog | strpos | integer | text, text | normal
pg_catalog | substr | bytea | bytea, integer | normal
pg_catalog | substr | bytea | bytea, integer, integer | normal
pg_catalog | substr | text | text, integer | normal
pg_catalog | substr | text | text, integer, integer | normal
pg_catalog | substring | bit | bit, integer | normal
pg_catalog | substring | bit | bit, integer, integer | normal
pg_catalog | substring | bytea | bytea, integer | normal
pg_catalog | substring | bytea | bytea, integer, integer | normal
pg_catalog | substring | text | text, integer | normal
pg_catalog | substring | text | text, integer, integer | normal
pg_catalog | substring | text | text, text | normal
pg_catalog | substring | text | text, text, text | normal
pg_catalog | sum | numeric | bigint | agg
pg_catalog | sum | bigint[] | bigint[] | agg
pg_catalog | sum | double precision | double precision | agg
pg_catalog | sum | double precision[] | double precision[] | agg
pg_catalog | sum | bigint | integer | agg
pg_catalog | sum | bigint[] | integer[] | agg
pg_catalog | sum | interval | interval | agg
pg_catalog | sum | money | money | agg
pg_catalog | sum | numeric | numeric | agg
pg_catalog | sum | real | real | agg
pg_catalog | sum | bigint | smallint | agg
pg_catalog | sum | bigint[] | smallint[] | agg
pg_catalog | tan | double precision | double precision | normal
pg_catalog | tanh | double precision | double precision | normal
pg_catalog | text | text | bigint | normal
pg_catalog | text | text | boolean | normal
pg_catalog | text | text | "char" | normal
pg_catalog | text | text | character | normal
pg_catalog | text | text | date | normal
pg_catalog | text | text | double precision | normal
pg_catalog | text | text | inet | normal
pg_catalog | text | text | integer | normal
pg_catalog | text | text | interval | normal
pg_catalog | text | text | macaddr | normal
pg_catalog | text | text | name | normal
pg_catalog | text | text | numeric | normal
pg_catalog | text | text | oid | normal
pg_catalog | text | text | real | normal
pg_catalog | text | text | smallint | normal
pg_catalog | text | text | timestamp without time zone | normal
pg_catalog | text | text | timestamp with time zone | normal
pg_catalog | text | text | time without time zone | normal
pg_catalog | text | text | time with time zone | normal
pg_catalog | text | text | xml | normal
pg_catalog | text_ge | boolean | text, text | normal
pg_catalog | text_gt | boolean | text, text | normal
pg_catalog | text_larger | text | text, text | normal
pg_catalog | text_le | boolean | text, text | normal
pg_catalog | text_lt | boolean | text, text | normal
pg_catalog | text_pattern_eq | boolean | text, text | normal
pg_catalog | text_pattern_ge | boolean | text, text | normal
pg_catalog | text_pattern_gt | boolean | text, text | normal
pg_catalog | text_pattern_le | boolean | text, text | normal
pg_catalog | text_pattern_lt | boolean | text, text | normal
pg_catalog | text_pattern_ne | boolean | text, text | normal
pg_catalog | text_smaller | text | text, text | normal
pg_catalog | textcat | text | text, text | normal
pg_catalog | texteq | boolean | text, text | normal
pg_catalog | texticlike | boolean | text, text | normal
pg_catalog | texticnlike | boolean | text, text | normal
pg_catalog | texticregexeq | boolean | text, text | normal
pg_catalog | texticregexne | boolean | text, text | normal
pg_catalog | textin | text | cstring | normal
pg_catalog | textlen | integer | text | normal
pg_catalog | textlike | boolean | text, text | normal
pg_catalog | textne | boolean | text, text | normal
pg_catalog | textnlike | boolean | text, text | normal
pg_catalog | textout | cstring | text | normal
pg_catalog | textrecv | text | internal | normal
pg_catalog | textregexeq | boolean | text, text | normal
pg_catalog | textregexne | boolean | text, text | normal
pg_catalog | textsend | bytea | text | normal
pg_catalog | tideq | boolean | tid, tid | normal
pg_catalog | tidge | boolean | tid, tid | normal
pg_catalog | tidgt | boolean | tid, tid | normal
pg_catalog | tidin | tid | cstring | normal
pg_catalog | tidlarger | tid | tid, tid | normal
pg_catalog | tidle | boolean | tid, tid | normal
pg_catalog | tidlt | boolean | tid, tid | normal
pg_catalog | tidne | boolean | tid, tid | normal
pg_catalog | tidout | cstring | tid | normal
pg_catalog | tidrecv | tid | internal | normal
pg_catalog | tidsend | bytea | tid | normal
pg_catalog | tidsmaller | tid | tid, tid | normal
pg_catalog | time | time without time zone | abstime | normal
pg_catalog | time | time without time zone | interval | normal
pg_catalog | time | time without time zone | text | normal
pg_catalog | time | time without time zone | timestamp without time zone | normal
pg_catalog | time | time without time zone | timestamp with time zone | normal
pg_catalog | time | time without time zone | time without time zone, integer | normal
pg_catalog | time | time without time zone | time with time zone | normal
pg_catalog | time_cmp | integer | time without time zone, time without time zone | normal
pg_catalog | time_eq | boolean | time without time zone, time without time zone | normal
pg_catalog | time_ge | boolean | time without time zone, time without time zone | normal
pg_catalog | time_gt | boolean | time without time zone, time without time zone | normal
pg_catalog | time_in | time without time zone | cstring, oid, integer | normal
pg_catalog | time_larger | time without time zone | time without time zone, time without time zone | normal
pg_catalog | time_le | boolean | time without time zone, time without time zone | normal
pg_catalog | time_lt | boolean | time without time zone, time without time zone | normal
pg_catalog | time_mi_interval | time without time zone | time without time zone, interval | normal
pg_catalog | time_mi_time | interval | time without time zone, time without time zone | normal
pg_catalog | time_ne | boolean | time without time zone, time without time zone | normal
pg_catalog | time_out | cstring | time without time zone | normal
pg_catalog | time_pl_interval | time without time zone | time without time zone, interval | normal
pg_catalog | time_recv | time without time zone | internal, oid, integer | normal
pg_catalog | time_send | bytea | time without time zone | normal
pg_catalog | time_smaller | time without time zone | time without time zone, time without time zone | normal
pg_catalog | timedate_pl | timestamp without time zone | time without time zone, date | normal
pg_catalog | timemi | abstime | abstime, reltime | normal
pg_catalog | timenow | abstime | | normal
pg_catalog | timeofday | text | | normal
pg_catalog | timepl | abstime | abstime, reltime | normal
pg_catalog | timestamp | timestamp without time zone | abstime | normal
pg_catalog | timestamp | timestamp without time zone | date | normal
pg_catalog | timestamp | timestamp without time zone | date, time without time zone | normal
pg_catalog | timestamp | timestamp without time zone | text | normal
pg_catalog | timestamp | timestamp without time zone | timestamp without time zone, integer | normal
pg_catalog | timestamp | timestamp without time zone | timestamp with time zone | normal
pg_catalog | timestamp_cmp | integer | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamp_cmp_date | integer | timestamp without time zone, date | normal
pg_catalog | timestamp_cmp_timestamptz | integer | timestamp without time zone, timestamp with time zone | normal
pg_catalog | timestamp_eq | boolean | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamp_eq_date | boolean | timestamp without time zone, date | normal
pg_catalog | timestamp_eq_timestamptz | boolean | timestamp without time zone, timestamp with time zone | normal
pg_catalog | timestamp_ge | boolean | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamp_ge_date | boolean | timestamp without time zone, date | normal
pg_catalog | timestamp_ge_timestamptz | boolean | timestamp without time zone, timestamp with time zone | normal
pg_catalog | timestamp_gt | boolean | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamp_gt_date | boolean | timestamp without time zone, date | normal
pg_catalog | timestamp_gt_timestamptz | boolean | timestamp without time zone, timestamp with time zone | normal
pg_catalog | timestamp_in | timestamp without time zone | cstring, oid, integer | normal
pg_catalog | timestamp_larger | timestamp without time zone | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamp_le | boolean | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamp_le_date | boolean | timestamp without time zone, date | normal
pg_catalog | timestamp_le_timestamptz | boolean | timestamp without time zone, timestamp with time zone | normal
pg_catalog | timestamp_lt | boolean | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamp_lt_date | boolean | timestamp without time zone, date | normal
pg_catalog | timestamp_lt_timestamptz | boolean | timestamp without time zone, timestamp with time zone | normal
pg_catalog | timestamp_mi | interval | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamp_mi_interval | timestamp without time zone | timestamp without time zone, interval | normal
pg_catalog | timestamp_ne | boolean | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamp_ne_date | boolean | timestamp without time zone, date | normal
pg_catalog | timestamp_ne_timestamptz | boolean | timestamp without time zone, timestamp with time zone | normal
pg_catalog | timestamp_out | cstring | timestamp without time zone | normal
pg_catalog | timestamp_pl_interval | timestamp without time zone | timestamp without time zone, interval | normal
pg_catalog | timestamp_recv | timestamp without time zone | internal, oid, integer | normal
pg_catalog | timestamp_send | bytea | timestamp without time zone | normal
pg_catalog | timestamp_smaller | timestamp without time zone | timestamp without time zone, timestamp without time zone | normal
pg_catalog | timestamptz | timestamp with time zone | abstime | normal
pg_catalog | timestamptz | timestamp with time zone | date | normal
pg_catalog | timestamptz | timestamp with time zone | date, time without time zone | normal
pg_catalog | timestamptz | timestamp with time zone | date, time with time zone | normal
pg_catalog | timestamptz | timestamp with time zone | text | normal
pg_catalog | timestamptz | timestamp with time zone | timestamp without time zone | normal
pg_catalog | timestamptz | timestamp with time zone | timestamp with time zone, integer | normal
pg_catalog | timestamptz_cmp | integer | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timestamptz_cmp_date | integer | timestamp with time zone, date | normal
pg_catalog | timestamptz_cmp_timestamp | integer | timestamp with time zone, timestamp without time zone | normal
pg_catalog | timestamptz_eq | boolean | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timestamptz_eq_date | boolean | timestamp with time zone, date | normal
pg_catalog | timestamptz_eq_timestamp | boolean | timestamp with time zone, timestamp without time zone | normal
pg_catalog | timestamptz_ge | boolean | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timestamptz_ge_date | boolean | timestamp with time zone, date | normal
pg_catalog | timestamptz_ge_timestamp | boolean | timestamp with time zone, timestamp without time zone | normal
pg_catalog | timestamptz_gt | boolean | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timestamptz_gt_date | boolean | timestamp with time zone, date | normal
pg_catalog | timestamptz_gt_timestamp | boolean | timestamp with time zone, timestamp without time zone | normal
pg_catalog | timestamptz_in | timestamp with time zone | cstring, oid, integer | normal
pg_catalog | timestamptz_larger | timestamp with time zone | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timestamptz_le | boolean | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timestamptz_le_date | boolean | timestamp with time zone, date | normal
pg_catalog | timestamptz_le_timestamp | boolean | timestamp with time zone, timestamp without time zone | normal
pg_catalog | timestamptz_lt | boolean | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timestamptz_lt_date | boolean | timestamp with time zone, date | normal
pg_catalog | timestamptz_lt_timestamp | boolean | timestamp with time zone, timestamp without time zone | normal
pg_catalog | timestamptz_mi | interval | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timestamptz_mi_interval | timestamp with time zone | timestamp with time zone, interval | normal
pg_catalog | timestamptz_ne | boolean | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timestamptz_ne_date | boolean | timestamp with time zone, date | normal
pg_catalog | timestamptz_ne_timestamp | boolean | timestamp with time zone, timestamp without time zone | normal
pg_catalog | timestamptz_out | cstring | timestamp with time zone | normal
pg_catalog | timestamptz_pl_interval | timestamp with time zone | timestamp with time zone, interval | normal
pg_catalog | timestamptz_recv | timestamp with time zone | internal, oid, integer | normal
pg_catalog | timestamptz_send | bytea | timestamp with time zone | normal
pg_catalog | timestamptz_smaller | timestamp with time zone | timestamp with time zone, timestamp with time zone | normal
pg_catalog | timetz | time with time zone | text | normal
pg_catalog | timetz | time with time zone | timestamp with time zone | normal
pg_catalog | timetz | time with time zone | time without time zone | normal
pg_catalog | timetz | time with time zone | time with time zone, integer | normal
pg_catalog | timetz_cmp | integer | time with time zone, time with time zone | normal
pg_catalog | timetz_eq | boolean | time with time zone, time with time zone | normal
pg_catalog | timetz_ge | boolean | time with time zone, time with time zone | normal
pg_catalog | timetz_gt | boolean | time with time zone, time with time zone | normal
pg_catalog | timetz_hash | integer | time with time zone | normal
pg_catalog | timetz_in | time with time zone | cstring, oid, integer | normal
pg_catalog | timetz_larger | time with time zone | time with time zone, time with time zone | normal
pg_catalog | timetz_le | boolean | time with time zone, time with time zone | normal
pg_catalog | timetz_lt | boolean | time with time zone, time with time zone | normal
pg_catalog | timetz_mi_interval | time with time zone | time with time zone, interval | normal
pg_catalog | timetz_ne | boolean | time with time zone, time with time zone | normal
pg_catalog | timetz_out | cstring | time with time zone | normal
pg_catalog | timetz_pl_interval | time with time zone | time with time zone, interval | normal
pg_catalog | timetz_recv | time with time zone | internal, oid, integer | normal
pg_catalog | timetz_send | bytea | time with time zone | normal
pg_catalog | timetz_smaller | time with time zone | time with time zone, time with time zone | normal
pg_catalog | timetzdate_pl | timestamp with time zone | time with time zone, date | normal
pg_catalog | timezone | timestamp with time zone | interval, timestamp without time zone | normal
pg_catalog | timezone | timestamp without time zone | interval, timestamp with time zone | normal
pg_catalog | timezone | time with time zone | interval, time with time zone | normal
pg_catalog | timezone | timestamp with time zone | text, timestamp without time zone | normal
pg_catalog | timezone | timestamp without time zone | text, timestamp with time zone | normal
pg_catalog | timezone | time with time zone | text, time with time zone | normal
pg_catalog | tinterval | tinterval | abstime, abstime | normal
pg_catalog | tintervalct | boolean | tinterval, tinterval | normal
pg_catalog | tintervalend | abstime | tinterval | normal
pg_catalog | tintervaleq | boolean | tinterval, tinterval | normal
pg_catalog | tintervalge | boolean | tinterval, tinterval | normal
pg_catalog | tintervalgt | boolean | tinterval, tinterval | normal
pg_catalog | tintervalin | tinterval | cstring | normal
pg_catalog | tintervalle | boolean | tinterval, tinterval | normal
pg_catalog | tintervalleneq | boolean | tinterval, reltime | normal
pg_catalog | tintervallenge | boolean | tinterval, reltime | normal
pg_catalog | tintervallengt | boolean | tinterval, reltime | normal
pg_catalog | tintervallenle | boolean | tinterval, reltime | normal
pg_catalog | tintervallenlt | boolean | tinterval, reltime | normal
pg_catalog | tintervallenne | boolean | tinterval, reltime | normal
pg_catalog | tintervallt | boolean | tinterval, tinterval | normal
pg_catalog | tintervalne | boolean | tinterval, tinterval | normal
pg_catalog | tintervalout | cstring | tinterval | normal
pg_catalog | tintervalov | boolean | tinterval, tinterval | normal
pg_catalog | tintervalrecv | tinterval | internal | normal
pg_catalog | tintervalrel | reltime | tinterval | normal
pg_catalog | tintervalsame | boolean | tinterval, tinterval | normal
pg_catalog | tintervalsend | bytea | tinterval | normal
pg_catalog | tintervalstart | abstime | tinterval | normal
pg_catalog | to_ascii | text | text | normal
pg_catalog | to_ascii | text | text, integer | normal
pg_catalog | to_ascii | text | text, name | normal
pg_catalog | to_char | text | bigint, text | normal
pg_catalog | to_char | text | double precision, text | normal
pg_catalog | to_char | text | integer, text | normal
pg_catalog | to_char | text | interval, text | normal
pg_catalog | to_char | text | numeric, text | normal
pg_catalog | to_char | text | real, text | normal
pg_catalog | to_char | text | timestamp without time zone, text | normal
pg_catalog | to_char | text | timestamp with time zone, text | normal
pg_catalog | to_date | date | text, text | normal
pg_catalog | to_hex | text | bigint | normal
pg_catalog | to_hex | text | integer | normal
pg_catalog | to_number | numeric | text, text | normal
pg_catalog | to_timestamp | timestamp with time zone | double precision | normal
pg_catalog | to_timestamp | timestamp with time zone | text, text | normal
pg_catalog | transaction_timestamp | timestamp with time zone | | normal
pg_catalog | translate | text | text, text, text | normal
pg_catalog | trigger_in | trigger | cstring | trigger
pg_catalog | trigger_out | cstring | trigger | normal
pg_catalog | trunc | double precision | double precision | normal
pg_catalog | trunc | macaddr | macaddr | normal
pg_catalog | trunc | numeric | numeric | normal
pg_catalog | trunc | numeric | numeric, integer | normal
pg_catalog | uhc_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | unknownin | unknown | cstring | normal
pg_catalog | unknownout | cstring | unknown | normal
pg_catalog | unknownrecv | unknown | internal | normal
pg_catalog | unknownsend | bytea | unknown | normal
pg_catalog | unnest | SETOF anyelement | anyarray | normal
pg_catalog | upper | text | text | normal
pg_catalog | utf8_to_ascii | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_big5 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_euc_cn | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_euc_jis_2004 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_euc_jp | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_euc_kr | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_euc_tw | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_gb18030 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_gbk | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_iso8859 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_iso8859_1 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_johab | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_koi8r | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_koi8u | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_shift_jis_2004 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_sjis | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_uhc | void | integer, integer, cstring, internal, integer | normal
pg_catalog | utf8_to_win | void | integer, integer, cstring, internal, integer | normal
pg_catalog | var_pop | numeric | bigint | agg
pg_catalog | var_pop | double precision | double precision | agg
pg_catalog | var_pop | numeric | integer | agg
pg_catalog | var_pop | numeric | numeric | agg
pg_catalog | var_pop | double precision | real | agg
pg_catalog | var_pop | numeric | smallint | agg
pg_catalog | var_samp | numeric | bigint | agg
pg_catalog | var_samp | double precision | double precision | agg
pg_catalog | var_samp | numeric | integer | agg
pg_catalog | var_samp | numeric | numeric | agg
pg_catalog | var_samp | double precision | real | agg
pg_catalog | var_samp | numeric | smallint | agg
pg_catalog | varbit | bit varying | bit varying, integer, boolean | normal
pg_catalog | varbit_in | bit varying | cstring, oid, integer | normal
pg_catalog | varbit_out | cstring | bit varying | normal
pg_catalog | varbit_recv | bit varying | internal, oid, integer | normal
pg_catalog | varbit_send | bytea | bit varying | normal
pg_catalog | varbitcmp | integer | bit varying, bit varying | normal
pg_catalog | varbiteq | boolean | bit varying, bit varying | normal
pg_catalog | varbitge | boolean | bit varying, bit varying | normal
pg_catalog | varbitgt | boolean | bit varying, bit varying | normal
pg_catalog | varbitle | boolean | bit varying, bit varying | normal
pg_catalog | varbitlt | boolean | bit varying, bit varying | normal
pg_catalog | varbitne | boolean | bit varying, bit varying | normal
pg_catalog | varchar | character varying | character varying, integer, boolean | normal
pg_catalog | varchar | character varying | name | normal
pg_catalog | varcharin | character varying | cstring, oid, integer | normal
pg_catalog | varcharout | cstring | character varying | normal
pg_catalog | varcharrecv | character varying | internal, oid, integer | normal
pg_catalog | varcharsend | bytea | character varying | normal
pg_catalog | variance | numeric | bigint | agg
pg_catalog | variance | double precision | double precision | agg
pg_catalog | variance | numeric | integer | agg
pg_catalog | variance | numeric | numeric | agg
pg_catalog | variance | double precision | real | agg
pg_catalog | variance | numeric | smallint | agg
pg_catalog | version | text | | normal
pg_catalog | void_in | void | cstring | normal
pg_catalog | void_out | cstring | void | normal
pg_catalog | width | double precision | box | normal
pg_catalog | width_bucket | integer | numeric, numeric, numeric, integer | normal
pg_catalog | win1250_to_latin2 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win1250_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win1251_to_iso | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win1251_to_koi8r | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win1251_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win1251_to_win866 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win866_to_iso | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win866_to_koi8r | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win866_to_mic | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win866_to_win1251 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | win_to_utf8 | void | integer, integer, cstring, internal, integer | normal
pg_catalog | xideq | boolean | xid, xid | normal
pg_catalog | xideqint4 | boolean | xid, integer | normal
pg_catalog | xidin | xid | cstring | normal
pg_catalog | xidout | cstring | xid | normal
pg_catalog | xidrecv | xid | internal | normal
pg_catalog | xidsend | bytea | xid | normal
pg_catalog | xml | xml | text | normal
pg_catalog | xml_in | xml | cstring | normal
pg_catalog | xml_is_well_formed | boolean | text | normal
pg_catalog | xml_is_well_formed_content | boolean | text | normal
pg_catalog | xml_is_well_formed_document | boolean | text | normal
pg_catalog | xml_out | cstring | xml | normal
pg_catalog | xml_recv | xml | internal | normal
pg_catalog | xml_send | bytea | xml | normal
pg_catalog | xmlagg | xml | xml | agg
pg_catalog | xmlcomment | xml | text | normal
pg_catalog | xmlconcat2 | xml | xml, xml | normal
pg_catalog | xmlexists | boolean | text, xml | normal
pg_catalog | xmlvalidate | boolean | xml, text | normal
pg_catalog | xpath | xml[] | text, xml | normal
pg_catalog | xpath | xml[] | text, xml, text[] | normal
pg_catalog | xpath_exists | boolean | text, xml | normal
pg_catalog | xpath_exists | boolean | text, xml, text[] | normal
(2791 rows)

gp_transaction_log

posted Jan 19, 2014, 6:35 PM by Sachchida Ojha

gpadmin=# \d gp_transaction_log
View "pg_catalog.gp_transaction_log"
Column | Type | Modifiers
-------------+----------+-----------
segment_id | smallint |
dbid | smallint |
transaction | xid |
status | text |
View definition:
SELECT l.segment_id, l.dbid, l.transaction, l.status
FROM gp_transaction_log() l(segment_id smallint, dbid smallint, transaction xid, status text);


The gp_transaction_log view contains status information about transactions local to a particular segment. This view allows you to see the status of local transactions.

gp_pgdatabase

posted Jan 19, 2014, 6:33 PM by Sachchida Ojha

gpadmin=# \d gp_pgdatabase
View "pg_catalog.gp_pgdatabase"
Column | Type | Modifiers
----------------+----------+-----------
dbid | smallint |
isprimary | boolean |
content | smallint |
valid | boolean |
definedprimary | boolean |
View definition:
SELECT l.dbid, l.isprimary, l.content, l.valid, l.definedprimary
FROM gp_pgdatabase() l(dbid smallint, isprimary boolean, content smallint, valid boolean, definedprimary boolean);

The gp_pgdatabase view shows status information about the Greenplum segment instances and whether they are acting as the mirror or the primary. This view is used internally by the Greenplum fault detection and recovery utilities to determine failed segments.

gp_distributed_xacts

posted Jan 19, 2014, 6:30 PM by Sachchida Ojha

gpadmin=# \d gp_distributed_xacts
View "pg_catalog.gp_distributed_xacts"
Column | Type | Modifiers
---------------------------+---------+-----------
distributed_xid | xid |
distributed_id | text |
state | text |
gp_session_id | integer |
xmin_distributed_snapshot | xid |
View definition:
SELECT l.distributed_xid, l.distributed_id, l.state, l.gp_session_id, l.xmin_distributed_snapshot
FROM gp_distributed_xacts() l(distributed_xid xid, distributed_id text, state text, gp_session_id integer, xmin_distributed_snapshot xid);

The gp_distributed_xacts view contains information about Greenplum Database distributed transactions. A distributed transaction is a transaction that involves modifying data on the segment instances. Greenplum’s distributed transaction manager ensures that the segments stay in synch. This view allows you to see the currently active sessions and their associated distributed transactions.

gp_distributed_log

posted Jan 19, 2014, 6:29 PM by Sachchida Ojha

gpadmin=# \d gp_distributed_log
View "pg_catalog.gp_distributed_log"
Column | Type | Modifiers
-------------------+----------+-----------
segment_id | smallint |
dbid | smallint |
distributed_xid | xid |
distributed_id | text |
status | text |
local_transaction | xid |
View definition:
SELECT l.segment_id, l.dbid, l.distributed_xid, l.distributed_id, l.status, l.local_transaction
FROM gp_distributed_log() l(segment_id smallint, dbid smallint, distributed_xid xid, distributed_id text, status text, local_transaction xid);

The gp_distributed_log view contains status information about distributed transactions and their associated local transactions. A distributed transaction is a transaction that involves modifying data on the segment instances. Greenplum’s distributed transaction manager ensures that the segments stay in synch. This view allows you to see the status of distributed transactions.

gp_version_at_initdb

posted Jan 19, 2014, 6:23 PM by Sachchida Ojha

gpadmin=# \d gp_version_at_initdb
Table "pg_catalog.gp_version_at_initdb"
Column | Type | Modifiers
----------------+----------+-----------
schemaversion | smallint | not null
productversion | text |


Tablespace: "pg_global"


gp_verification_history

posted Jan 19, 2014, 6:20 PM by Sachchida Ojha

gpadmin=# \d gp_verification_history
Table "pg_catalog.gp_verification_history"
Column | Type | Modifiers
--------------+--------------------------+-----------
vertoken | name | not null
vertype | smallint | not null
vercontent | smallint | not null
verstarttime | timestamp with time zone | not null
verstate | smallint | not null
verdone | boolean | not null
verendtime | timestamp with time zone | not null
vermismatch | boolean | not null
Indexes:
"gp_verification_history_vertoken_index" UNIQUE, btree (vertoken), tablespace "pg_global"


Tablespace: "pg_global"

gp_segment_configuration

posted Jan 19, 2014, 6:17 PM by Sachchida Ojha

gpadmin=# \d gp_segment_configuration
Table "pg_catalog.gp_segment_configuration"
Column | Type | Modifiers
------------------+------------+-----------
dbid | smallint | not null
content | smallint | not null
role | "char" | not null
preferred_role | "char" | not null
mode | "char" | not null
status | "char" | not null
port | integer | not null
hostname | text |
address | text |
replication_port | integer |
san_mounts | int2vector |
Indexes:
"gp_segment_config_content_preferred_role_index" UNIQUE, btree (content, preferred_role), tablespace "pg_global"
"gp_segment_config_dbid_index" UNIQUE, btree (dbid), tablespace "pg_global"

Tablespace: "pg_global"

The gp_segment_configuration table contains information about mirroring and segment configuration.

gp_san_configuration

posted Jan 19, 2014, 6:14 PM by Sachchida Ojha

gpadmin=# \d gp_san_configuration

Table "pg_catalog.gp_san_configuration"
Column | Type | Modifiers 
--------------------+----------+-----------
mountid | smallint | not null
active_host | "char" | not null
san_type | "char" | not null
primary_host | text | 
primary_mountpoint | text | 
primary_device | text | 
mirror_host | text | 
mirror_mountpoint | text | 
mirror_device | text | 

Indexes:
"gp_san_config_mountid_index" UNIQUE, btree (mountid), tablespace "pg_global"

Tablespace: "pg_global"

The gp_san_configuration table contains mount-point information for SAN failover.

gp_persistent_tablespace_node

posted Jan 19, 2014, 6:10 PM by Sachchida Ojha

gpadmin=# \d gp_persistent_tablespace_node

Table "pg_catalog.gp_persistent_tablespace_node"
Column | Type | Modifiers 
----------------------------------------------+----------+-----------
filespace_oid | oid | not null
tablespace_oid | oid | not null
persistent_state | smallint | not null
create_mirror_data_loss_tracking_session_num | bigint | not null
mirror_existence_state | smallint | not null
reserved | integer | not null
parent_xid | integer | not null
persistent_serial_num | bigint | not null
previous_free_tid | tid | not null

Tablespace: "pg_global"

The gp_persistent_tablespace_node table keeps track of the status of file system objects in relation to the transaction status of tablespace objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. This information is used by the primary to mirror file replication process

gp_persistent_relation_node

posted Jan 19, 2014, 6:08 PM by Sachchida Ojha

gpadmin=# \d gp_persistent_relation_node

Table "pg_catalog.gp_persistent_relation_node"
Column | Type | Modifiers 
---------------------------------------------------+-----------+-----------
tablespace_oid | oid | not null
database_oid | oid | not null
relfilenode_oid | oid | not null
segment_file_num | integer | not null
relation_storage_manager | smallint | not null
persistent_state | smallint | not null
create_mirror_data_loss_tracking_session_num | bigint | not null
mirror_existence_state | smallint | not null
mirror_data_synchronization_state | smallint | not null
mirror_bufpool_marked_for_scan_incremental_resync | boolean | not null
mirror_bufpool_resync_changed_page_count | bigint | not null
mirror_bufpool_resync_ckpt_loc | gpxlogloc | not null
mirror_bufpool_resync_ckpt_block_num | integer | not null
mirror_append_only_loss_eof | bigint | not null
mirror_append_only_new_eof | bigint | not null
relation_bufpool_kind | integer | not null
parent_xid | integer | not null
persistent_serial_num | bigint | not null
previous_free_tid | tid | not null

Tablespace: "pg_global"

The gp_persistent_relation_node table table keeps track of the status of file system objects in relation to the transaction status of relation objects (tables, view, indexes, and so on). This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. This information is used by the primary to mirror file replication process.

1-10 of 22