pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (7+ messages)

Message-ID: <20050824181923.GS96732@pervasive.com>
Permalink:  ../20050824181923.GS96732@pervasive.com/
Also on:    postgresql.org/message-id/20050824181923.GS96732@pervasive.com

 · 

reply

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