System Catalog Reference

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

System Catalog Reference

This reference describes the Greenplum Database system catalog 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 Greenplum that provides to enhance PostgreSQL for data warehousing workloads. Note that the global system catalog for Greenplum Database resides on the master instance.

System Tables

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: