in this video i explain three methods to list all schemas in a postgresql database
postgreSQL 15
pgAdmin 4
SQL Query
SQL Shell(psql)
psql command
1. SELECT schema_name FROM information_schema.schemata
2. SELECT nspname FROM pg_catalog.pg_namespace;
3. \dn
information_schema
pg_catalog
pg_toast