List of system-level schemas in Greenplum

posted Apr 28, 2017, 4:09 PM by Sachchida Ojha
The following system-level schemas also exist in every database:

1. pg_catalog is the schema that has the system catalog tables, built-in data types, functions, and operators. It is always part of the schema search path, even if it is not explicitly named in the search path. For information on the system catalog tables in the pg_catalog schema.

2. information_schema consists of a standardized set of views that contain information about the objects in the database. These views are used to get system information from the system catalog tables in a standardized way.

3.pg_toast is a system schema where large objects are stored (records that exceed the page size). This schema is used internally by the Greenplum Database system and is not typically accessed by database administrators or users. 

4.pg_bitmapindex is the system schema where bitmap index objects are stored (list of values, etc.). This schema is used internally by the Greenplum Database system and is not typically accessed by database administrators or users.

5.pg_aoseg is the system schema where append-only table objects are stored. This schema is used internally by the Greenplum Database system and is not typically accessed by database administrators or users.

6. gp_toolkit is an administrative schema that you can use to view and query the system log files and other system metrics. The gp_toolkit schema contains a 
number of external tables, views and functions that you can access by using SQL commands. gp_toolkit is accessible by all database users. 
Comments