X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C913DD7248 for ; Wed, 24 Aug 2005 08:52:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39977-07 for ; Wed, 24 Aug 2005 11:51:57 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203]) by svr1.postgresql.org (Postfix) with ESMTP id 44F40D7166 for ; Wed, 24 Aug 2005 08:51:56 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z6so48342nzd for ; Wed, 24 Aug 2005 04:52:00 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=hgAXd0IpYu92oxYTTYoOGlI7BrMcTWTVzF0UjCIYD6axGwZbI2G8nHGhksagXXxwEwc0udM0Qtosm4x2389esIt8oSlUwl4apVmwnTlhJKhrzjTfPOzwi9dOY4hiFIHtzGYrUHUn6cWjqL39gspfhRB6XSuhWR5fu4trLBpsctA= Received: by 10.36.47.16 with SMTP id u16mr6055834nzu; Wed, 24 Aug 2005 04:52:00 -0700 (PDT) Received: by 10.36.119.19 with HTTP; Wed, 24 Aug 2005 04:52:00 -0700 (PDT) Message-ID: Date: Wed, 24 Aug 2005 17:22:00 +0530 From: Gnanavel S To: Sivakumar K Subject: Re: Reg:sql command Cc: postgre In-Reply-To: <584DE893B0E08F4B9748E295029F1E9702EA51A5@maya.aztec.soft.net> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2966_6478115.1124884320498" References: <584DE893B0E08F4B9748E295029F1E9702EA51A5@maya.aztec.soft.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.307 required=5 tests=[AWL=0.187, HTML_50_60=0.095, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/296 X-Sequence-Number: 18615 ------=_Part_2966_6478115.1124884320498 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 8/24/05, Sivakumar K wrote: >=20 > 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=20 psql -E -U siva -d template1 -c "\d test" Am I missing anything here? > Regards, > Siva Kumar.K >=20 > -----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 >=20 > 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. >=20 > -- > 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 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Do you want to know God? http://www.lfix.co.uk/knowing_god.html >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? >=20 > http://www.postgresql.org/docs/faq >=20 --=20 with regards, S.Gnanavel Satyam Computer Services Ltd. ------=_Part_2966_6478115.1124884320498 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

On 8/24/05, Sivakumar K <si= vakumark@aztec.soft.net> wrote:
Oliver,
How should I use this?
I tried this way but of no use.
psq= l -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@lf= ix.co.uk]
Sent: Wednesday, August 24, 2005 2:47 PM
To: sandhyaCc: postgre; Sivakumar K
Subject: Re: [ADMIN] Reg:sql command

On Wed, 2005-08-24 at 11:50 +0530, sandhya wrote:
> Hi,
> Is th= ere any equivalent command for '\d tablename'.
> Inorder to get the t= able structure is there any SQL query in postgres?
>
use psql -E t= o see the SQL commands that are used to implement \d and
other such commands.

--
Oliver Elphick           &n= bsp;            = ;            &n= bsp;     olly@l= fix.co.uk
Isle of Wight           &nbs= p;            &= nbsp;     http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39= E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
   =             &nb= sp; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
   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?

           &= nbsp;   http://www= .postgresql.org/docs/faq


--
with regards,
S.Gnanavel
Satyam Computer Services Ltd. ------=_Part_2966_6478115.1124884320498--