mirror of
https://github.com/jbranchaud/til
synced 2026-01-02 22:58:01 +00:00
11 lines
391 B
Markdown
11 lines
391 B
Markdown
# List Available Schemas
|
|
|
|
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.
|
|
|
|
You can use `\dnS` to also list system schemas.
|
|
|
|
[source](http://www.postgresql.org/docs/current/static/app-psql.html)
|