Select Code to Download

select schema_name
from information_schema.schemata
where schema_name <> 'information_schema' -- exclude 'system' schemata
  and schema_name !~ E'^pg_'              -- exclude more 'system' (pg
+-specific)

echo '\dn' | psql