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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
