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:


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.


Share this blog post on Twitter, Facebook, and LinkedIn