Re: Reg:sql command

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