3 ways to List All Schemas from PostgreSQL



1.Using SQL Syntax

There are two ways in which you can use the SQL Synthax to list all schemas from PostgreSQL.

Using the (ANSI) standard INFORMATION_SCHEMA:

SELECT schema.name
FROM information_schema.schemata;

Another option is

SELECT nspname
FROM pg_catalog.pg_namespace;

2.Using psql

In psql all schemas can be listed by executing the next command:

/dn

You can find a cheat sheet of the important commands in psql here

3.Using DbSchema

In DbSchema, you can view all the schemas available in you PostgreSQL database on the left menu. From there, you can drag & drop the tables to the layout and edit them.

list-schemas-dbschema