Re: Describe structure.

pg=>\d tblpg will describe the structure.

pg=>\? will give a list of commands, including how to use \d

anuj wrote:

> Hi,
> 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    |
>  +------------------+----------------------------------+----------+
>
> pg=> describe tblpg;
> ERROR:  parser: parse error at or near "describe"