Further to postgres on Rails in Fedora 18 but OT

[Max Pyziur]

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 at brama.com