\d tablename
should do the trick.
take care,
-tuna
On Wed, 2002-11-13 at 11:55, Chris Boget wrote:
> 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;
>
> What is the command in pgsql?
> I apologize for the stupid question but I've spent the last several hours
> looking for the stupid answer. :P
>
> thnx,
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org