| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Gnanavel S <s(dot)gnanavel(at)gmail(dot)com> |
| Cc: | sandhya <sandhyar(at)amiindia(dot)co(dot)in>, postgre <pgsql-admin(at)postgresql(dot)org>, Sivakumar K <sivakumark(at)aztec(dot)soft(dot)net> |
| Subject: | Re: Reg:sql command |
| Date: | 2005-08-24 18:19:23 |
| Message-ID: | 20050824181923.GS96732@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
You should also take a look at
http://pgfoundry.org/projects/newsysviews/; it makes getting this kind
of info out of the database much easier.
On Wed, Aug 24, 2005 at 02:43:31PM +0530, Gnanavel S wrote:
> run the psql command with -E option and do
> \d tablename.
>
> On 8/24/05, sandhya <sandhyar(at)amiindia(dot)co(dot)in> wrote:
> >
> > Hi,
> > Is there any equivalent command for '\d tablename'.
> > Inorder to get the table structure is there any SQL query in postgres?
> > Thank you,
> > Regards,
> > sandhya
> >
>
>
>
> --
> with regards,
> S.Gnanavel
> Satyam Computer Services Ltd.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-24 19:44:23 | Re: help me to explain database behaviour after vacuum. |
| Previous Message | Jim C. Nasby | 2005-08-24 18:17:40 | Re: Fwd: Indexes (Disk space) |