Re: Describe structure.

On Tue, 25 Jul 2000, anuj wrote:

> My table name is tblpg.
> I want to see the table structure.
> Like oracle have Describe <table name>.
> What PG have ? or any command.
> Thank in advance.
> Anuj
>
> pg=> \d
> Database    = pg
>  +------------------+----------------------------------+----------+
>  |  Owner           |             Relation             |   Type   |
>  +------------------+----------------------------------+----------+
>  | postgres         | tblpg                            | table    |
>  +------------------+----------------------------------+----------+

It's all in the online help.  The command you want is \d <table>.

Brett W. McCoy
                                         http://www.chapelperilous.net/~bmccoy/
-------------------------------------------------------------------------------
Yow!  Is my fallout shelter termite proof?