Product Documentationsys.schema
A system view that returns information about the schemas in the database.
| Column Name | Data Type | Description |
|---|---|---|
| schema_id | bigint | Unique ID of the schema. User-defined schemas have IDs greater than 16000. |
| database_id | bigint | Unique ID of the database where the schema belongs. |
| name | varchar(256) | Name of the schema. |
| owner_id | bigint | Unique ID of the user who owns the schema. Join to sys.user to get the name of the user. |
| creation_time | timestamptz | When the schema was created. |
For example:
premdb=# select * from sys.schema where schema_id >16000;
schema_id | database_id | owner_id | name | creation_time
-----------+-------------+----------+--------+-------------------------------
25031 | 16397 | 10 | newone | 2019-12-11 17:15:53.39047-08
25032 | 16397 | 10 | dev | 2019-12-11 17:17:05.62417-08
25033 | 16397 | 10 | prod | 2019-12-11 17:17:13.260892-08
(3 rows)Parent topic:System Views