List tables for a specific schema

Поиск
Список
Период
Сортировка
От David Gauthier
Тема List tables for a specific schema
Дата
Msg-id CAMBRECDLdvwuh7DaFwHeJqzCocpxugom8MKeBOKLy50RiRG--A@mail.gmail.com
обсуждение исходный текст
Ответы Re: List tables for a specific schema  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: List tables for a specific schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 !

В списке pgsql-general по дате отправления:

Предыдущее
От: David Gauthier
Дата:
Сообщение: Need create table statements from metadata
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: List tables for a specific schema