pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gnanavel S <s.gnanavel@gmail.com>
To: Sivakumar K <sivakumark@aztec.soft.net>
Cc: postgre <pgsql-admin@postgresql.org>
Subject: Re: Reg:sql command
Date: Wed, 24 Aug 2005 17:22:00 +0530
Message-ID: <eec3b03c050824045242d25a64@mail.gmail.com> (raw)
In-Reply-To: <584DE893B0E08F4B9748E295029F1E9702EA51A5@maya.aztec.soft.net>
References: <584DE893B0E08F4B9748E295029F1E9702EA51A5@maya.aztec.soft.net>

On 8/24/05, Sivakumar K <sivakumark@aztec.soft.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@lfix.co.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@lfix.co.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.

view thread (7+ messages)  latest in thread

Message-ID: <eec3b03c050824045242d25a64@mail.gmail.com>
Permalink:  ../eec3b03c050824045242d25a64@mail.gmail.com/
Also on:    postgresql.org/message-id/eec3b03c050824045242d25a64@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: s.gnanavel@gmail.com, sivakumark@aztec.soft.net
  Subject: Re: Reg:sql command
  In-Reply-To: <eec3b03c050824045242d25a64@mail.gmail.com>
  References: <584DE893B0E08F4B9748E295029F1E9702EA51A5@maya.aztec.soft.net> <eec3b03c050824045242d25a64@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox