RE: Describe structure.

From: Wilkinson Charlie E <Charlie(dot)E(dot)Wilkinson(at)irs(dot)gov>
To: "Poul L(dot) Christiansen" <plc(at)faroenet(dot)fo>, anuj <Anuj(at)in-control(dot)de>
Cc: pgsql-general(at)hub(dot)org
Subject: RE: Describe structure.
Date: 2000-07-25 14:42:06
Message-ID: C9077ABBC4CED311A69F0004AC3699EB02FBF393@nct0010mb03.nc.no.irs.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)faroenet(dot)fo]
> Sent: Tuesday, July 25, 2000 4:43 AM
> To: anuj
> Cc: pgsql-general(at)hub(dot)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"
>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fetter, David M 2000-07-25 15:03:13 RE: Problems upgrading from v6.4.2 to v7.0.2
Previous Message Guillaume Perréal 2000-07-25 14:06:45 Re: Statistical Analysis