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,
> Satyam Computer Services Ltd.
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com 512-569-9461
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-08-24 19:44:23|
|Subject: Re: help me to explain database behaviour after vacuum. |
|Previous:||From: Jim C. Nasby||Date: 2005-08-24 18:17:40|
|Subject: Re: Fwd: Indexes (Disk space)|