Search Postgresql Archives

List tables for a specific schema

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 !

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux