System tables

 

SYSTEM schema

Table Description

DATABASE_DATASTORE

A listing of all datastores in the database. The IS_TABLE field is set to TRUE for datastores that are accessible as tables and can therefor be queried with SQL.

DATABASE_DATASTORE_FIELD

A listing of all fields in every datastore in the database.

DATABASE_INDEX

A listing of all indexes in the database.

DATABASE_SCHEMA

A listing of all schemas in the database.

DATABASE_SEQUENCE

A listing of all sequences in the database.

DATABASE_SYNONYM

A listing of all synonyms in the database.

DATABASE_USER

A listing of all users in the database.

 

PG_CATALOG schema

The PG_CATALOG schema holds tables typically found in a PostgreSQL database. This schema and the tables in it are used by clients that assume a PostgreSQL database is provided.

 

Key-value tables

Every schema has a KEY_VALUE and KEY_VALUE_TEMP table. These tables make up the key-value stores available in each schema.