System Catalog Reference

This reference describes the HAWQ system catalog tables and views.

System tables prefixed with ’gp_’ relate to the parallel features of HAWQ. Tables prefixed with ’pg_’ are either standard PostgreSQL system catalog tables supported in HAWQ, or are related to features HAWQ that provides to enhance PostgreSQL for data warehousing workloads. Note that the global system catalog for HAWQ resides on the master instance.

• System Tables

  This topic lists the system tables included in HAWQ.

• System Views

  HAWQ provides the following system views not available in PostgreSQL.

• System Catalogs Definitions

  System catalog table and view definitions in alphabetical order.