RE: what is the equivalent of oracle's DESCRIBE table? - Mailing list pgsql-general

From chris markiewicz
Subject RE: what is the equivalent of oracle's DESCRIBE table?
Date
Msg-id 00ab01c01f1e$40d673d0$dbb846c6@cmarkiewicz
Whole thread Raw
In response to what is the equivalent of oracle's DESCRIBE table?  ("chris markiewicz" <cmarkiew@commnav.com>)
Responses RE: what is the equivalent of oracle's DESCRIBE table?  (Andrew Perrin - Demography <aperrin@demog.berkeley.edu>)
List pgsql-general
\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
>
>


pgsql-general by date:

Previous
From: "chris markiewicz"
Date:
Subject: what is the equivalent of oracle's DESCRIBE table?
Next
From: "Bryan White"
Date:
Subject: Re: Corrupt Table