Re: Describe a table - Mailing list pgsql-novice

From Chris Smith
Subject Re: Describe a table
Date
Msg-id 5.1.0.14.0.20021114093005.0265fec0@cooee.squiz.net
Whole thread Raw
In response to Describe a table  ("Chris Boget" <chris@wild.net>)
List 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 ...../>


pgsql-novice by date:

Previous
From: Chris Smith
Date:
Subject: Re: Can't add records
Next
From: "Zeller, Raymond"
Date:
Subject: ...