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(at)commnav(dot)com>
To: "'Len Morgan'" <len-morgan(at)crcom(dot)net>
Cc: "'PostgreSQL General' (E-mail)" <pgsql-general(at)postgresql(dot)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(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
> >
> >