SCHEMATA

Provides information about schemas in the database.

Column Name	Data Type	Description
`SCHEMA_ID`	INTEGER	Unique numeric ID assigned by the Vertica catalog, which identifies the specific schema.
`SCHEMA_NAME`	VARCHAR	Schema name for which information is listed.
`SCHEMA_NAMESPACE_NAME`	VARCHAR	For Eon Mode databases, name of the namespace to which the schema belongs.
`SCHEMA_OWNER_ID`	INTEGER	Unique numeric ID assigned by the Vertica catalog, which identifies the owner who created the schema.
`SCHEMA_OWNER`	VARCHAR	Name of the owner who created the schema.
`SYSTEM_SCHEMA_CREATOR`	VARCHAR	Creator information for system schema or `NULL` for non-system schema
`CREATE_TIME`	TIMESTAMPTZ	Time when the schema was created.
`IS_SYSTEM_SCHEMA`	BOOLEAN	Indicates whether the schema was created for system use, where t is true and f is false.

Privileges

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.