Oliver, How should I use this? I tried this way but of no use. psql -E -U siva -d template1 -c \d test (test is a table in template1) Am I missing anything here? Regards, Siva Kumar.K -----Original Message----- From: Oliver Elphick [mailto:olly@xxxxxxxxxx] Sent: Wednesday, August 24, 2005 2:47 PM To: sandhya Cc: postgre; Sivakumar K Subject: Re: [ADMIN] Reg:sql command On Wed, 2005-08-24 at 11:50 +0530, sandhya wrote: > Hi, > Is there any equivalent command for '\d tablename'. > Inorder to get the table structure is there any SQL query in postgres? > use psql -E to see the SQL commands that are used to implement \d and other such commands. -- Oliver Elphick olly@xxxxxxxxxx Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== Do you want to know God? http://www.lfix.co.uk/knowing_god.html