Thread: List tables for a specific schema
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 !
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://www.postgresql.org/docs/11/ddl-schemas.html#DDL-SCHEMAS-PATH to see how to change it. > > Thanks ! -- Adrian Klaver adrian.klaver@aklaver.com
David Gauthier <davegauthierpg@gmail.com> writes: > 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. Try "\dt dvm.*". regards, tom lane