| From: | Chris Smith <csmith(at)squiz(dot)net> |
|---|---|
| To: | "Chris Boget" <chris(at)wild(dot)net>, <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Describe a table |
| Date: | 2002-11-13 22:31:02 |
| Message-ID: | 5.1.0.14.0.20021114093005.0265fec0@cooee.squiz.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi,
>I've looked in a bunch of places (include the describe.c as suggested
>in the FAQ; I'm just really rusty on my C and as such got nothing from
>the code) on how to 'describe' a table. In MySQL, I could simply use
>the command:
>
>desc tablename;
Try \d tablename
If you want to see the query this actually runs, connect to postgres with
the -E option:
psql -E database
HTH,
Chris Smith
>> 92 Jarrett St Leichhardt, Sydney, NSW 2040 ...>
T: + 61 2 9568 6866
F: + 61 2 9568 6733
W: http://www.squiz.net/
.....>> Open Source - Own it - Squiz.net ...../>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | YC Nyon | 2002-11-14 03:05:50 | Re: SQL statement to copy a result set to create another table |
| Previous Message | Chris Smith | 2002-11-13 21:35:39 | Re: Can't add records |