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

How about \d <table name>

I think that is the type of info oracle spits out for describe (sorry...
been 6 months since I touched oracle and it was for only about 4 months that
I did. :) )

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "chris markiewicz" <cmarkiew@commnav.com>
To: "'Len Morgan'" <len-morgan@crcom.net>
Cc: "'PostgreSQL General' (E-mail)" <pgsql-general@postgresql.org>
Sent: Friday, September 15, 2000 10:07 AM
Subject: RE: [GENERAL] 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
> >
> >