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@xxxxxxxxx -- users mailing list users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
