Thanks for the responses. Heres a summary:
>>- how do I see details of the various constraints (e.g foreign keys) in
>>psql client? Am I looking at a system-table query?
>>
> Yes, all the data is in system tables.
> The developers manual has info on the contents of the system tables:
> http://www.postgresql.org/idocs/index.php?catalogs.html
> You can also try using psql -E to see what queries the
> \*-commands (eg. \dv) generate.
Probably the most useful source on this is the link I found on the
Non-FAQ technical docs for postgres:
http://techdocs.postgresql.org/redir.php?link=/techdocs/hackingreferentialintegrity.php
This points out that foreign keys are just specialised constraints and
gives a few useful queries and views for inspecting and altering them.
>>- Er, what can I use as a comment character in a sql file? Multiple
>>hashmarks seem to cause parse errors
>>
>
> You can have two kinds of comments:
> -- single line comments
> /* and
> multiline comments */
>
> - Einar Karttunen
Thanks again.
colm