Today I Learned

hashrocket A Hashrocket project

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.


See More #sql TILs
Looking for help? Hashrocket developers believe that data quality is as important as code quality. We enjoy all the challenges of relational databases, from finding the fastest index, to structuring data to fit the needs of an application. We're eager to share our experiences; check out PG Casts, our series of free PostgreSQL screencasts.