RE: what is the equivalent of oracle's DESCRIBE table?

\dt  only seems to list Owner, Relation, and Type.

i am looking for something that returns the same info that is found in a
CREATE TABLE statement...column names, data types, etc.  i haven't seen
anything like this in the documentation...

thanks
chris

-----Original Message-----
From: Len Morgan [mailto:len-morgan@crcom.net]
Sent: Friday, September 15, 2000 9:48 AM
To: cmarkiew@commnav.com
Subject: Re: [GENERAL] what is the equivalent of oracle's DESCRIBE
table?


in psql: \dt 

-----Original Message-----
From: chris markiewicz 
To: 'PostgreSQL General' 
Date: Friday, September 15, 2000 8:51 AM
Subject: [GENERAL] what is the equivalent of oracle's DESCRIBE table?


>hello.
>
>what is the postgres equivalent of oracle's command-line DESCRIBE 
>command?  does there exist a sql92 command for this?
>
>thank you
>chris
>
>