While we're on the topic, can someone tell me where '\d *' went, and what to use instead?
That particular command seems to have disappeared in PG7.
Thanks for any light-shedding...
-cw-
> -----Original Message-----
> From: Poul L. Christiansen [mailto:plc@faroenet.fo]
> Sent: Tuesday, July 25, 2000 4:43 AM
> To: anuj
> Cc: pgsql-general@hub.org
> Subject: Re: [GENERAL] 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"
>