Use the \dn command within a psql session to list the available schemas. This will only included user created schemas. This means that schemas like public will be listed whereas schemas like information_schema and pg_catalog will not.
\dn
psql
public
information_schema
pg_catalog
You can use \dnS to also list system schemas.
\dnS
sourcearrow-up-right
Last updated 4 years ago