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"
>
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 |