| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | David Gauthier <davegauthierpg(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: List tables for a specific schema |
| Date: | 2019-06-20 21:50:08 |
| Message-ID: | 3a3909eb-616f-c6d4-5486-76abc219c253@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 6/20/19 2:43 PM, David Gauthier wrote:
> 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 ?
Looks like a search_path issue.
In psql:
1) show search_path
To see what your search path is.
2) Then take a look at:
https://stream.boxwatch.ru/docs/11/ddl-schemas.html#DDL-SCHEMAS-PATH
to see how to change it.
>
> Thanks !
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2019-06-20 21:59:45 | Re: Need create table statements from metadata |
| Previous Message | David Gauthier | 2019-06-20 21:43:38 | List tables for a specific schema |