System Catalogs

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.

Warning: Changes to Greenplum Database system catalog tables or views are not supported. If a catalog table or view is changed, the cluster must be reinitialized and restored.

Parent topic: Greenplum Database Reference Guide

Need help? Visit the Greenplum Database Community