How to list all available schemas in PostgreSQL?

1. Using SQL Query

You can get the list of all schemas using SQL with the ANSI standard of INFORMATION_SCHEMA:

SELECT schema_name FROM information_schema.schemata


SELECT nspname FROM pg_catalog.pg_namespace;

Basically, information schema is a set of views of pg_catalog.

2. Using psql

While using psql, simply use command \dn.

3. With TablePlus

In TablePlus, you can either use the query editor and execute the statements above, or quickly navigate to the schema dropdown list at the bottom of the left sidebar.

Except the system schemas that you usually do not interact with, all the available schemas will be listed here, including the empty ones. To also see the system schemas, select the dropdown next to the + button > Settings > Show System Schemas.


Need a good GUI tool for PostgreSQL? Check out TablePlus. It’s native, beautiful, and available for free.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS

TablePlus GUI Tool PostgreSQL