GP functions in pg_catalog schema

posted Apr 28, 2017, 10:39 AM by Sachchida Ojha
sachi=# \df pg_catalog.gp_* List of functions
Schema | Name | Result data type | Argument data types | Type 
------------+-----------------------------------------------+-----------------------------------+----------------------------------------------------------------------
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
(77 rows)


sachi=#
Comments