On 05.12.01 13:00 +0000(+0000), Colm McCartan wrote:
> Hello all,
>
> I don't see either of these in the faq or docs... Very basic:
>
> - 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.
> - 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