Re: Reg:sql command

Oops sorry for that post.
Actually we need to do like this.
Psql -E -U siva -d template1
Template1=>\d test;
It gives the queries.

Thanks
Siva Kumar.K

-----Original Message-----
From: Oliver Elphick [mailto:olly(at)lfix(dot)co(dot)uk]
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(at)lfix(dot)co(dot)uk
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