How to list relations in postgres schema

Question

I need help with a pretty basic Postgres command, but I cannot find a reference anywhere. My cluster is set up like this:

database_1
   \- schema_1
   \- schema_2
        \- relation_1
        \- relation_2
        \- ...
   \- relation_3
   \- relation_4
   \- ...

I know how to list databases (\l), and I know how to list relations in the "default" schema (\dt). Heck, I can even list schemas (\dn), but I cannot, for the life of me, list the relations within a schema.

To pre-clarify, what I'm looking for is this:

> \c database_1
You are now connected to database_1
> \somecommand
relation_1
relation_2
>

Szymon Lipiński · Accepted Answer · 2010-11-05 19:58:40Z

41

Try this one:

\dt schema_2.

answered Nov 5, 2010 at 19:58

Szymon Lipiński

28.8k17 gold badges81 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Joe Mastey Over a year ago

perfect, thanks :) At the same time I also discovered that asterisk will work with this as well (\dt schema_2.* or \dt schema_. etc etc)

CervEd Over a year ago

this answer appears out of date

Community · Accepted Answer · 2017-05-23 11:54:07Z

26

I'll clarify since this is the first result of a google search.

\dt schema_2 will not list all the relations for schema_2.

The correct answer is in the comments of the answer.

\dt schema_2.*

A more thorough answer can be found here, List tables in a PostgreSQL schema

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Mar 21, 2017 at 20:22

Mitch

7021 gold badge9 silver badges14 bronze badges

1 Comment

Gerhard Over a year ago

This lists tables. Relations also include views and materialized views, which aren't listed with this command.

eadsjr · Accepted Answer · 2019-05-16 16:20:23Z

4

As of PostgresQL version 11.2 I find that this performs as expected. It lists views and sequences as well, not just tables.

\d schema_2.

If you replace schema_2 with your schema name and leave the dot it appears to work fine.

Some further command instructions are available in a psql connection via \?

answered May 16, 2019 at 16:20

eadsjr

7516 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to list relations in postgres schema

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related