From: | Einar Karttunen <ekarttun(at)cs(dot)helsinki(dot)fi> |
---|---|
To: | Colm McCartan <colmm(at)owl(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Two very basic questions.. |
Date: | 2001-12-05 13:40:23 |
Message-ID: | 20011205154023.A12678@shellak.helsinki.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Antonio Fiol Bonnín | 2001-12-05 13:43:07 | Re: Selecting across Multiple Tables |
Previous Message | Colm McCartan | 2001-12-05 13:00:38 | Two very basic questions.. |