Overview of System Tables and Views

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

Overview of System Tables and Views

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

System Views

Greenplum Database provides the following system views not available in PostgreSQL.

For more information about the standard system views supported in PostgreSQL and Greenplum Database, see the following sections of the PostgreSQL documentation: