On Thu, 30 May 2013, Roger wrote:
Apologies for top post
Thanks this is most helpful
One thing that I forgot to mention is tables that are in other schemas
besides the public schema.
Personally, I don't build a database with tables in other schemas; but it
does add a way of keeping tables organized hierarchically.
In the monitor, you can type
\dn
to get a list of schemas
Then to query a table in a particular schema
SELECT * FROM <schemaname>.<tablename>
Alternatively, to find a lot of information in the monitor, you can type:
\d *.*
And you'll get system tables, etc.
Roger
fyi,
Max Pyziur
pyz(a)brama.com