Search Postgresql Archives

Looking for a command to list schemas

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

 



Hello,

We are presently experimenting with Postgresql schemas... We used basic
commands like \d  to list info from all tables/sequence/owner in a
db... The schema info was always "public" since we never created one...

In version 7.3.4 and with a test db where schemas were created, the
same \d does not show the schema of each table... the \dp  doesn't help
width the privileges...

It seems that once we created the schema and created a table with this
schema, if we forget about it, the is no way to list the schema or to
have the tables/sequence with it's associated schema...

Can someone tell us how we can get this important info?
Thanks!
--
Mark


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[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