The SHOW SCHEMAS statement lists all schemas in a database.

Required privileges

No privileges are required to list the schemas in a database.

Synopsis

SHOW SCHEMAS FROM name

Parameters

Parameter Description
name The name of the database for which to show schemas. When omitted, the schemas in the current database are listed.

Example

copy
icon/buttons/copy
> SET DATABASE = bank;
copy
icon/buttons/copy
> SHOW SCHEMAS;
+--------------------+
|    schema_name     |
+--------------------+
| crdb_internal      |
| information_schema |
| pg_catalog         |
| public             |
+--------------------+
(4 rows)

See also



Yes No