Schemas
The following table describes the schemas of openGauss.
Table 1 Schemas supported by openGauss
Schema | Description |
---|
blockchain | Stores the user history table that is automatically created when a tamper-proof table is created in the ledger database. |
cstore | Stores auxiliary tables related to column-store tables, such as CUDesc and Delta tables. |
db4ai | Manages data of different versions in AI training. |
dbe_perf | Diagnoses performance issues and is also the data source of WDR snapshots. After a database is installed, only the initial user and monitoring administrator have permission to view views and functions in this schema by default. |
dbe_pldebugger | Debugs PL/pgSQL functions and stored procedures. |
snapshot | Manages data related to WDR snapshots. By default, the initial user or monitoring administrator can access the data. |
sqladvisor | Is used for distribution column recommendation and is unavailable in openGauss . |
pg_catalog | Maintains system catalog information, including system catalogs and all built-in data types, functions, and operators. |
pg_toast | Stores large objects (for internal use). |
public | Public schema. By default, created tables (and other objects) are automatically put into this schema. |
pkg_service | Manages information about the package service. |
openGauss 2024-10-11 00:55:40