From: Jim C. Nasby <jnasby@pervasive.com>
To: Gnanavel S <s.gnanavel@gmail.com>
Cc: sandhya <sandhyar@amiindia.co.in>
Cc: postgre <pgsql-admin@postgresql.org>
Cc: Sivakumar K <sivakumark@aztec.soft.net>
Subject: Re: Reg:sql command
Date: Wed, 24 Aug 2005 13:19:23 -0500
Message-ID: <20050824181923.GS96732@pervasive.com> (raw)
In-Reply-To: <eec3b03c0508240213847ccb0@mail.gmail.com>
References: <024c01c5a873$ec6da040$cd00000a@amiindiahjwbgh>
<eec3b03c0508240213847ccb0@mail.gmail.com>
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@amiindia.co.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@pervasive.com
Pervasive Software http://pervasive.com 512-569-9461
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jnasby@pervasive.com, s.gnanavel@gmail.com, sandhyar@amiindia.co.in, sivakumark@aztec.soft.net
Subject: Re: Reg:sql command
In-Reply-To: <20050824181923.GS96732@pervasive.com>
References: <024c01c5a873$ec6da040$cd00000a@amiindiahjwbgh> <eec3b03c0508240213847ccb0@mail.gmail.com> <20050824181923.GS96732@pervasive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox