Re: List tables for a specific schema

2019-06-20 Thread Tom Lane
David Gauthier 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

Re: List tables for a specific schema

2019-06-20 Thread Adrian Klaver
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

List tables for a specific schema

2019-06-20 Thread David Gauthier
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