System Tables

This topic lists the system tables included in HAWQ.

• gp_configuration (Deprecated. See gp_segment_configuration.)
• gp_configuration_history
• gp_distribution_policy
• gp_global_sequence
• gp_master_mirroring
• gp_persistent_database_node
• gp_persistent_filespace_node
• gp_persistent_relation_node
• gp_persistent_tablespace_node
• gp_relation_node (Deprecated. See gp_relfile_node.)
• gp_segment_configuration
• gp_version_at_initdb
• pg_aggregate
• pg_am
• pg_amop
• pg_amproc
• pg_appendonly
• pg_attrdef
• pg_attribute
• pg_auth_members
• pg_authid
• pg_autovacuum (not supported)
• 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 supported)
• pg_foreign_server (not supported)
• pg_foreign_table (not supported)
• 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_resqueue
• pg_rewrite
• pg_shdepend
• pg_shdescription
• pg_stat_last_operation
• pg_stat_last_shoperation
• pg_statistic
• pg_stats
• pg_tablespace
• pg_trigger
• pg_type
• pg_user_mapping (not supported)
• pg_window