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@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 <table name>

-----Original Message-----
From: chris markiewicz <cmarkiew@commnav.com>
To: 'PostgreSQL General' <pgsql-general@postgresql.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
>
>