Table is still in TODO…
| Name | Type | Explanation | Returns | Tags |
|---|---|---|---|---|
| pg_advisory_lock | procedure | Obtain (create) exclusive advisory lock | void | lock |
| pg_advisory_lock_shared | procedure | Obtain (create) shared advisory lock | void | lock |
| pg_advisory_unlock | procedure | Releases exclusive advisory lock | True = success | lock |
| pg_advisory_unlock_all | procedure | Releases all advisory locks held by the current session | True = success | lock |
| pg_advisory_unlock_shared | procedure | Releases shared advisory lock | True = success | lock |
| pg_advisory_xact_lock | procedure | |||
| pg_advisory_xact_lock_shared | procedure | |||
| pg_aggregate | table | information about aggregate functions – sum, avg, max, min, var* etc. | aggregate functions | |
| pg_am | table | Existing index access methods | index | |
| pg_amop | table | Interconnect access method, operator family and operators for every access method | index | |
| pg_amproc | table | procedures associated with access method operator family | index | |
| pg_attrdef | table | default values for columns | table, column | |
| pg_attribute | table | information about table columns | table, column | |
| pg_auth_members | table | relationships between roles across the whole server | role/user, privileges | |
| pg_authid | table | existing users/ roles | role/user, privileges | |
| pg_available_extension_versions | procedure | |||
| pg_available_extension_versions | table | |||
| pg_available_extension_versions | view | |||
| pg_available_extensions | procedure | |||
| pg_available_extensions | table | |||
| pg_available_extensions | view | |||
| pg_backend_pid | procedure | ID of current session / connection | ||
| pg_backup_start_time | procedure | |||
| pg_cancel_backend | procedure | |||
| pg_cast | table | existing data typ conversions | ||
| pg_char_to_encoding | procedure | |||
| pg_class | table | Table of tables, indexes, sequences, views, composite types, toast tables | ||
| pg_client_encoding | procedure | |||
| pg_collation | table | |||
| pg_collation_for | procedure | |||
| pg_collation_is_visible | procedure | |||
| pg_column_is_updatable | procedure | |||
| pg_column_size | procedure | |||
| pg_conf_load_time | procedure | |||
| pg_constraint | table | Stores check, primary key, unique and foreign key constraints on tables | ||
| pg_conversion | table | |||
| pg_conversion_is_visible | procedure | |||
| pg_create_restore_point | procedure | |||
| pg_current_xlog_insert_location | procedure | |||
| pg_current_xlog_location | procedure | |||
| pg_cursor | procedure | |||
| pg_cursors | table | |||
| pg_cursors | view | |||
| pg_database | table | Stores info about available databases | ||
| pg_database_size | procedure | |||
| pg_database_size | procedure | |||
| pg_db_role_setting | table | |||
| pg_default_acl | table | |||
| pg_depend | table | Records dependency relationships between database objects | ||
| pg_describe_object | procedure | |||
| pg_description | table | Comments for all objects | ||
| pg_encoding_max_length | procedure | |||
| pg_encoding_to_char | procedure | |||
| pg_enum | table | Contains entries of enum types | ||
| pg_event_trigger | table | contains all event triggers in database | ||
| pg_event_trigger_dropped_objects | procedure | returns details about dropped objects - for event trigger | ||
| pg_export_snapshot | procedure | |||
| pg_extension | table | |||
| pg_extension_config_dump | procedure | |||
| pg_extension_update_paths | procedure | |||
| pg_foreign_data_wrapper | table | Stores foreign data wrapper definitions | ||
| pg_foreign_server | table | Stores foreign server definitions | ||
| pg_foreign_table | table | |||
| pg_function_is_visible | procedure | |||
| pg_get_constraintdef | procedure | |||
| pg_get_constraintdef | procedure | |||
| pg_get_expr | procedure | |||
| pg_get_expr | procedure | |||
| pg_get_function_arguments | procedure | |||
| pg_get_function_identity_arguments | procedure | |||
| pg_get_function_result | procedure | |||
| pg_get_functiondef | procedure | |||
| pg_get_indexdef | procedure | |||
| pg_get_indexdef | procedure | |||
| pg_get_keywords | procedure | |||
| pg_get_multixact_members | procedure | |||
| pg_get_ruledef | procedure | |||
| pg_get_ruledef | procedure | |||
| pg_get_serial_sequence | procedure | |||
| pg_get_triggerdef | procedure | |||
| pg_get_triggerdef | procedure | |||
| pg_get_userbyid | procedure | |||
| pg_get_viewdef | procedure | |||
| pg_get_viewdef | procedure | |||
| pg_get_viewdef | procedure | |||
| pg_get_viewdef | procedure | |||
| pg_get_viewdef | procedure | |||
| pg_group | table | |||
| pg_group | view | |||
| pg_has_role | procedure | |||
| pg_has_role | procedure | |||
| pg_has_role | procedure | |||
| pg_has_role | procedure | |||
| pg_has_role | procedure | |||
| pg_has_role | procedure | |||
| pg_identify_object | procedure | |||
| pg_index | table | Contains part of info about indexes | ||
| pg_indexes | table | |||
| pg_indexes | view | |||
| pg_indexes_size | procedure | |||
| pg_inherits | table | Shows table inheritance hierarchy | ||
| pg_is_in_backup | procedure | |||
| pg_is_in_recovery | procedure | |||
| pg_is_other_temp_schema | procedure | |||
| pg_is_xlog_replay_paused | procedure | |||
| pg_language | table | Registers languages which can be used for functions | ||
| pg_largeobject | table | Contains actual data of large objects broken into rows | ||
| pg_largeobject_metadata | table | |||
| pg_last_xact_replay_timestamp | procedure | |||
| pg_last_xlog_receive_location | procedure | |||
| pg_last_xlog_replay_location | procedure | |||
| pg_listening_channels | procedure | |||
| pg_lock_status | procedure | Returns information about transactions as record – the same data as in pg_locks | record | lock |
| pg_locks | table | Shows all locks on server | lock | |
| pg_locks | view | Shows all locks on server | lock | |
| pg_ls_dir | procedure | Lists content of directory | filesystem | |
| pg_matviews | table | |||
| pg_matviews | view | |||
| pg_my_temp_schema | procedure | |||
| pg_namespace | table | Stores schemas (namespaces) | ||
| pg_node_tree_in | procedure | |||
| pg_node_tree_out | procedure | |||
| pg_node_tree_recv | procedure | |||
| pg_node_tree_send | procedure | |||
| pg_notify | procedure | |||
| pg_opclass | table | Defines index access method operator classes | ||
| pg_opclass_is_visible | procedure | |||
| pg_operator | table | Stores info about operators | ||
| pg_operator_is_visible | procedure | |||
| pg_opfamily | table | Defines operator families | ||
| pg_opfamily_is_visible | procedure | |||
| pg_options_to_table | procedure | |||
| pg_pltemplate | table | Stores “template” information for procedural languages – allows to create language without specific implementation details | ||
| pg_postmaster_start_time | procedure | |||
| pg_prepared_statement | procedure | |||
| pg_prepared_statements | table | |||
| pg_prepared_statements | view | |||
| pg_prepared_xact | procedure | |||
| pg_prepared_xacts | table | |||
| pg_prepared_xacts | view | |||
| pg_proc | table | Stores info about functions - including source code | ||
| pg_range | table | |||
| pg_read_binary_file | procedure | |||
| pg_read_binary_file | procedure | |||
| pg_read_file | procedure | |||
| pg_read_file | procedure | |||
| pg_relation_filenode | procedure | |||
| pg_relation_filepath | procedure | |||
| pg_relation_is_updatable | procedure | |||
| pg_relation_size | procedure | |||
| pg_relation_size | procedure | |||
| pg_reload_conf | procedure | |||
| pg_rewrite | table | |||
| pg_roles | table | |||
| pg_roles | view | |||
| pg_rotate_logfile | procedure | |||
| pg_rules | table | |||
| pg_rules | view | |||
| pg_seclabel | table | |||
| pg_seclabels | table | |||
| pg_seclabels | view | |||
| pg_sequence_parameters | procedure | |||
| pg_settings | table | |||
| pg_settings | view | |||
| pg_shadow | table | |||
| pg_shadow | view | |||
| pg_shdepend | table | |||
| pg_shdescription | table | |||
| pg_show_all_settings | procedure | |||
| pg_shseclabel | table | |||
| pg_size_pretty | procedure | |||
| pg_size_pretty | procedure | |||
| pg_sleep | procedure | |||
| pg_start_backup | procedure | |||
| pg_stat_activity | table | |||
| pg_stat_activity | view | |||
| pg_stat_all_indexes | table | |||
| pg_stat_all_indexes | view | |||
| pg_stat_all_tables | table | |||
| pg_stat_all_tables | view | |||
| pg_stat_bgwriter | table | |||
| pg_stat_bgwriter | view | |||
| pg_stat_clear_snapshot | procedure | |||
| pg_stat_database | table | |||
| pg_stat_database | view | |||
| pg_stat_database_conflicts | table | |||
| pg_stat_database_conflicts | view | |||
| pg_stat_file | procedure | |||
| pg_stat_get_activity | procedure | |||
| pg_stat_get_analyze_count | procedure | |||
| pg_stat_get_autoanalyze_count | procedure | |||
| pg_stat_get_autovacuum_count | procedure | |||
| pg_stat_get_backend_activity | procedure | |||
| pg_stat_get_backend_activity_start | procedure | |||
| pg_stat_get_backend_client_addr | procedure | |||
| pg_stat_get_backend_client_port | procedure | |||
| pg_stat_get_backend_dbid | procedure | |||
| pg_stat_get_backend_idset | procedure | |||
| pg_stat_get_backend_pid | procedure | |||
| pg_stat_get_backend_start | procedure | |||
| pg_stat_get_backend_userid | procedure | |||
| pg_stat_get_backend_waiting | procedure | |||
| pg_stat_get_backend_xact_start | procedure | |||
| pg_stat_get_bgwriter_buf_written_checkpoints | procedure | |||
| pg_stat_get_bgwriter_buf_written_clean | procedure | |||
| pg_stat_get_bgwriter_maxwritten_clean | procedure | |||
| pg_stat_get_bgwriter_requested_checkpoints | procedure | |||
| pg_stat_get_bgwriter_stat_reset_time | procedure | |||
| pg_stat_get_bgwriter_timed_checkpoints | procedure | |||
| pg_stat_get_blocks_fetched | procedure | |||
| pg_stat_get_blocks_hit | procedure | |||
| pg_stat_get_buf_alloc | procedure | |||
| pg_stat_get_buf_fsync_backend | procedure | |||
| pg_stat_get_buf_written_backend | procedure | |||
| pg_stat_get_checkpoint_sync_time | procedure | |||
| pg_stat_get_checkpoint_write_time | procedure | |||
| pg_stat_get_db_blk_read_time | procedure | |||
| pg_stat_get_db_blk_write_time | procedure | |||
| pg_stat_get_db_blocks_fetched | procedure | |||
| pg_stat_get_db_blocks_hit | procedure | |||
| pg_stat_get_db_conflict_all | procedure | |||
| pg_stat_get_db_conflict_bufferpin | procedure | |||
| pg_stat_get_db_conflict_lock | procedure | |||
| pg_stat_get_db_conflict_snapshot | procedure | |||
| pg_stat_get_db_conflict_startup_deadlock | procedure | |||
| pg_stat_get_db_conflict_tablespace | procedure | |||
| pg_stat_get_db_deadlocks | procedure | |||
| pg_stat_get_db_numbackends | procedure | |||
| pg_stat_get_db_stat_reset_time | procedure | |||
| pg_stat_get_db_temp_bytes | procedure | |||
| pg_stat_get_db_temp_files | procedure | |||
| pg_stat_get_db_tuples_deleted | procedure | |||
| pg_stat_get_db_tuples_fetched | procedure | |||
| pg_stat_get_db_tuples_inserted | procedure | |||
| pg_stat_get_db_tuples_returned | procedure | |||
| pg_stat_get_db_tuples_updated | procedure | |||
| pg_stat_get_db_xact_commit | procedure | |||
| pg_stat_get_db_xact_rollback | procedure | |||
| pg_stat_get_dead_tuples | procedure | |||
| pg_stat_get_function_calls | procedure | |||
| pg_stat_get_function_self_time | procedure | |||
| pg_stat_get_function_total_time | procedure | |||
| pg_stat_get_last_analyze_time | procedure | |||
| pg_stat_get_last_autoanalyze_time | procedure | |||
| pg_stat_get_last_autovacuum_time | procedure | |||
| pg_stat_get_last_vacuum_time | procedure | |||
| pg_stat_get_live_tuples | procedure | |||
| pg_stat_get_numscans | procedure | |||
| pg_stat_get_tuples_deleted | procedure | |||
| pg_stat_get_tuples_fetched | procedure | |||
| pg_stat_get_tuples_hot_updated | procedure | |||
| pg_stat_get_tuples_inserted | procedure | |||
| pg_stat_get_tuples_returned | procedure | |||
| pg_stat_get_tuples_updated | procedure | |||
| pg_stat_get_vacuum_count | procedure | |||
| pg_stat_get_wal_senders | procedure | |||
| pg_stat_get_xact_blocks_fetched | procedure | |||
| pg_stat_get_xact_blocks_hit | procedure | |||
| pg_stat_get_xact_function_calls | procedure | |||
| pg_stat_get_xact_function_self_time | procedure | |||
| pg_stat_get_xact_function_total_time | procedure | |||
| pg_stat_get_xact_numscans | procedure | |||
| pg_stat_get_xact_tuples_deleted | procedure | |||
| pg_stat_get_xact_tuples_fetched | procedure | |||
| pg_stat_get_xact_tuples_hot_updated | procedure | |||
| pg_stat_get_xact_tuples_inserted | procedure | |||
| pg_stat_get_xact_tuples_returned | procedure | |||
| pg_stat_get_xact_tuples_updated | procedure | |||
| pg_stat_replication | table | |||
| pg_stat_replication | view | |||
| pg_stat_reset | procedure | |||
| pg_stat_reset_shared | procedure | |||
| pg_stat_reset_single_function_counters | procedure | |||
| pg_stat_reset_single_table_counters | procedure | |||
| pg_stat_sys_indexes | table | |||
| pg_stat_sys_indexes | view | |||
| pg_stat_sys_tables | table | |||
| pg_stat_sys_tables | view | |||
| pg_stat_user_functions | table | |||
| pg_stat_user_functions | view | |||
| pg_stat_user_indexes | table | |||
| pg_stat_user_indexes | view | |||
| pg_stat_user_tables | table | |||
| pg_stat_user_tables | view | |||
| pg_stat_xact_all_tables | table | |||
| pg_stat_xact_all_tables | view | |||
| pg_stat_xact_sys_tables | table | |||
| pg_stat_xact_sys_tables | view | |||
| pg_stat_xact_user_functions | table | |||
| pg_stat_xact_user_functions | view | |||
| pg_stat_xact_user_tables | table | |||
| pg_stat_xact_user_tables | view | |||
| pg_statio_all_indexes | table | |||
| pg_statio_all_indexes | view | |||
| pg_statio_all_sequences | table | |||
| pg_statio_all_sequences | view | |||
| pg_statio_all_tables | table | |||
| pg_statio_all_tables | view | |||
| pg_statio_sys_indexes | table | |||
| pg_statio_sys_indexes | view | |||
| pg_statio_sys_sequences | table | |||
| pg_statio_sys_sequences | view | |||
| pg_statio_sys_tables | table | |||
| pg_statio_sys_tables | view | |||
| pg_statio_user_indexes | table | |||
| pg_statio_user_indexes | view | |||
| pg_statio_user_sequences | table | |||
| pg_statio_user_sequences | view | |||
| pg_statio_user_tables | table | |||
| pg_statio_user_tables | view | |||
| pg_statistic | table | |||
| pg_stats | table | |||
| pg_stats | view | |||
| pg_stop_backup | procedure | |||
| pg_switch_xlog | procedure | |||
| pg_table_is_visible | procedure | |||
| pg_table_size | procedure | |||
| pg_tables | table | |||
| pg_tables | view | |||
| pg_tablespace | table | |||
| pg_tablespace_databases | procedure | |||
| pg_tablespace_location | procedure | |||
| pg_tablespace_size | procedure | |||
| pg_tablespace_size | procedure | |||
| pg_terminate_backend | procedure | |||
| pg_timezone_abbrevs | procedure | |||
| pg_timezone_abbrevs | table | |||
| pg_timezone_abbrevs | view | |||
| pg_timezone_names | procedure | |||
| pg_timezone_names | table | |||
| pg_timezone_names | view | |||
| pg_total_relation_size | procedure | |||
| pg_trigger | table | |||
| pg_trigger_depth | procedure | |||
| pg_try_advisory_lock | procedure | |||
| pg_try_advisory_lock | procedure | |||
| pg_try_advisory_lock_shared | procedure | |||
| pg_try_advisory_lock_shared | procedure | |||
| pg_try_advisory_xact_lock | procedure | |||
| pg_try_advisory_xact_lock | procedure | |||
| pg_try_advisory_xact_lock_shared | procedure | |||
| pg_try_advisory_xact_lock_shared | procedure | |||
| pg_ts_config | table | |||
| pg_ts_config_is_visible | procedure | |||
| pg_ts_config_map | table | |||
| pg_ts_dict | table | |||
| pg_ts_dict_is_visible | procedure | |||
| pg_ts_parser | table | |||
| pg_ts_parser_is_visible | procedure | |||
| pg_ts_template | table | |||
| pg_ts_template_is_visible | procedure | |||
| pg_type | table | |||
| pg_type_is_visible | procedure | |||
| pg_typeof | procedure | |||
| pg_user | table | |||
| pg_user | view | |||
| pg_user_mapping | table | |||
| pg_user_mappings | table | |||
| pg_user_mappings | view | |||
| pg_views | table | |||
| pg_views | view | |||
| pg_xlog_location_diff | procedure | |||
| pg_xlog_replay_pause | procedure | |||
| pg_xlog_replay_resume | procedure | |||
| pg_xlogfile_name | procedure | |||
| pg_xlogfile_name_offset | procedure |