Pg_tables
List All Schemas in Your PostgreSQL Database
Apr 13, 2026 / · 3 min read · postgresql administration database information_schema pg_namespace pg_tables ·How to List All Schemas in a PostgreSQL Database A PostgreSQL database can contain multiple schemas. Schemas act as namespaces that group tables, views, functions, and other objects. In a fresh database you will find public and a set of system schemas. In a larger application database you may find dozens of application …
Read More