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

\dt <table name> 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(at)crcom(dot)net]
Sent: Friday, September 15, 2000 9:48 AM
To: cmarkiew(at)commnav(dot)com
Subject: Re: [GENERAL] what is the equivalent of oracle's DESCRIBE
table?

in psql: \dt <table name>

-----Original Message-----
From: chris markiewicz <cmarkiew(at)commnav(dot)com>
To: 'PostgreSQL General' <pgsql-general(at)postgresql(dot)org>
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 <table>
>command? does there exist a sql92 command for this?
>
>thank you
>chris
>
>