task_005_managing_schemas

Managing Schemas

• Managing Schemas
  • List all Schemas

List all Schemas

To list all the schemas you can use

SELECT schema_name FROM information_schema.schemata;

Output

postgres=# SELECT schema_name FROM information_schema.schemata;
    schema_name     
--------------------
 public
 information_schema
 pg_catalog
 pg_toast
(4 rows)

You can also use

SELECT nspname FROM pg_catalog.pg_namespace;

Output

postgres=# SELECT nspname FROM pg_catalog.pg_namespace;
      nspname       
--------------------
 pg_toast
 pg_catalog
 public
 information_schema
(4 rows)

You can also use

\dn

postgres=> \dn
    List of schemas
  Name  |     Owner
--------+---------------
 public | adminuser
(1 row)