Skip site navigation (1) Skip section navigation (2)

Re: Reg:sql command

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 (view raw or flat)
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

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2005-08-24 19:44:23
Subject: Re: help me to explain database behaviour after vacuum.
Previous:From: Jim C. NasbyDate: 2005-08-24 18:17:40
Subject: Re: Fwd: Indexes (Disk space)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group