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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com 512-569-9461
