How to View Schema in PostgreSQL

Galaxy Glossary

How do I view a schema in PostgreSQL?

Shows all schemas, tables, and columns using psql meta-commands or catalog views.

Welcome to Galaxy!
You'll be receiving a confirmation email.

In the meantime, follow us on Twitter

Oops! Something went wrong while submitting the form.

Description

Example H2

Example H3

How to View Schema in PostgreSQL

Need to inspect a database structure fast? PostgreSQL offers psql meta-commands and catalog queries to list schemas, tables, and columns with precision.

What commands show existing schemas?

In psql, run \dn to list every non-system schema. Add \dn+ for owner, ACL, and description details.

How can I list tables inside a schema?

Use \dt schema_name.* to display tables for the chosen schema.Swap \dt with \dm, \ds, or \dv for other object types.

Which SQL query reveals schema metadata?

Query information_schema.tables or pg_catalog.pg_namespace when scripting or using a GUI that lacks meta-commands.

Example: fetch all user schemas

SELECT nspname AS schema FROM pg_catalog.pg_namespace WHERE nspname NOT LIKE 'pg_%' AND nspname <> 'information_schema' ORDER BY 1;

How do I describe table columns within a schema?

Run \d schema_name.table_name in psql or query information_schema.columns filtering by table_schema and table_name.

Best practices for browsing schemas

Filter system schemas, script frequent catalog queries, and combine meta-commands with SQL for automation.

Common mistakes to avoid

Missing the dot: Typing \dt schema_name* fails.Always add .* after the schema.

Lacking privileges: Without the USAGE right on a schema, its objects stay hidden. Request grants or switch roles.

Need a GUI?

Editors like Galaxy, TablePlus, or pgAdmin visualize schemas instantly, reducing manual catalog queries.

Why How to View Schema in PostgreSQL is important

How to View Schema in PostgreSQL Example Usage


-- Show tables in the analytics schema
\dt analytics.*

-- SQL alternative
SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'analytics'
ORDER BY 1;

How to View Schema in PostgreSQL Syntax


-- psql meta-commands
\dn[+]                         -- list schemas
\dt schema.*                   -- list tables in schema
\d schema.table                -- describe table columns

-- SQL catalog queries
SELECT *
FROM information_schema.tables
WHERE table_schema = 'public';

SELECT nspname
FROM pg_namespace;

Common Mistakes

Forgetting the dot after schema name in meta-commands. Use \dt schema.* instead of \dt schema* to avoid syntax errors.
Running catalog queries without USAGE privilege on the schema, which hides objects. Grant USAGE or switch to a role that has it.