List tables for a specific schema

From: David Gauthier <davegauthierpg(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: List tables for a specific schema
Date: 2019-06-20 21:43:38
Message-ID: CAMBRECDLdvwuh7DaFwHeJqzCocpxugom8MKeBOKLy50RiRG--A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

psql (9.6.7, server 9.5.2)

I created a schema in my DB called "dvm". Then I created a table a-la...
create table dvm.foo (col1 tedxt); . I see the schema with \dnS+. But I
can't see my table using \d. I can see the dable with \d dvm.foo, so it's
in there. The first column of the \d output is "Schema", so I would have
expected to see it there. But no luck.

What I would like is to see a list of all the tables in the dvm schema and
nothing else. "\d dvm.*" works, but it also spills the details of every
table. I just want the list of tables in the schema.

Is there a way to get what I want ?

Thanks !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-06-20 21:50:08 Re: List tables for a specific schema
Previous Message David Gauthier 2019-06-20 21:32:56 Need create table statements from metadata