Re: Reg:sql command

On 8/24/05, Sivakumar K <sivakumark(at)aztec(dot)soft(dot)net> wrote:
>
> 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)

add the missing quotes
psql -E -U siva -d template1 -c "\d test"

Am I missing anything here?
> Regards,
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--
with regards,
S.Gnanavel
Satyam Computer Services Ltd.