System catalog tables and views

System Catalog Reference : This is a reference of the system catalog tables and views of Greenplum Database. All system tables related to the parallel features of Greenplum Database are prefixed with gp_. Tables prefixed with pg_ are either standard PostgreSQL system catalog tables (which are also used in Greenplum Database), or are related to features Greenplum has added to enhance PostgreSQL for data warehousing workloads. Note that the global system catalog for Greenplum Database resides on the master instance.

System Tables - Greenplum •gp_configuration (no longer used, see gp_segment_configuration) •gp_configuration_history •gp_db_interfaces •gp_distribution_policy •gp_fastsequence •gp_fault_strategy •gp_global_sequence •gp_id •gp_interfaces •gp_master_mirroring •gp_persistent_database_node •gp_persistent_filespace_node •gp_persistent_relation_node •gp_persistent_tablespace_node •gp_relation_node •gp_san_configuration •gp_segment_configuration •gp_version_at_initdb •gpexpand.status •gpexpand.status_detail System Views - Greenplum •gp_distributed_log •gp_distributed_xacts •gp_pgdatabase •gp_resqueue_status •gp_transaction_log •gpexpand.expansion_progress System Views Greenplum Database also contains the following system views currently not available in PostgreSQL. •pg_max_external_files (shows number of external table files allowed per segment host when using the file protocol) •pg_partition_columns •pg_partition_templates •pg_partitions •pg_resqueue_attributes •pg_resqueue_status deprecated (use gp_toolkit.gp_resqueue_status) •pg_stat_resqueues •pg_user_mappings (not implemented in 4.1 - for a future release)

System Tables •pg_aggregate •pg_am •pg_amop •pg_amproc •pg_appendonly •pg_appendonly_alter_column (not implemented in 4.1 - for a future release) •pg_attrdef •pg_attribute •pg_auth_members •pg_authid •pg_autovacuum •pg_cast •pg_class •pg_constraint •pg_conversion •pg_database •pg_depend •pg_description •pg_exttable •pg_filespace •pg_filespace_entry •pg_foreign_data_wrapper (not implemented in 4.1 - for a future release) •pg_foreign_server (not implemented in 4.1 - for a future release) •pg_foreign_table (not implemented in 4.1 - for a future release) •pg_index •pg_inherits •pg_language •pg_largeobject •pg_listener •pg_namespace •pg_opclass •pg_operator •pg_partition •pg_partition_rule •pg_pltemplate •pg_proc •pg_resourcetype •pg_resqueue •pg_resqueuecapability •pg_rewrite •pg_shdepend •pg_shdescription •pg_stat_last_operation •pg_stat_last_shoperation •pg_statistic •pg_tablespace •pg_trigger •pg_type •pg_user_mapping (not implemented in 4.1 - for a future release) •pg_window pg_tables