From sandhyar@amiindia.co.in Wed Aug 24 08:41:00 2005 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 A25E2D6D8A for ; Wed, 24 Aug 2005 05:41: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 73167-07 for ; Wed, 24 Aug 2005 08:40:57 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id B5D70D6D7C for ; Wed, 24 Aug 2005 05:40:55 -0300 (ADT) Received: from amiindia.co.in (unknown [203.199.198.234]) by svr4.postgresql.org (Postfix) with ESMTP id E60B25AF9C9 for ; Wed, 24 Aug 2005 06:16:56 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by amiindia.co.in (8.12.10/8.12.11) with SMTP id j7O5nork004464; Wed, 24 Aug 2005 11:19:53 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTPid 63BE14FC066; Wed, 24 Aug 2005 11:19:33 +0530 (IST) Message-ID: <024c01c5a873$ec6da040$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" , "Sivakumar K" Subject: Reg:sql command Date: Wed, 24 Aug 2005 11:50:24 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0247_01C5A8A2.0363D610" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:83.01667 C:22 M:1 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[AWL=-0.001, FORGED_RCVD_HELO=0.05, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200508/291 X-Sequence-Number: 18610 This is a multi-part message in MIME format. ------=_NextPart_000_0247_01C5A8A2.0363D610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Is there any equivalent command for '\d tablename'. Inorder to get the table structure is there any SQL query in postgres? Thank you, Regards, sandhya ------=_NextPart_000_0247_01C5A8A2.0363D610 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
Is there any equivalent command for '\d = tablename'.
Inorder to get the table structure is = there any SQL=20 query in postgres?
 
Thank you,
Regards,
sandhya
------=_NextPart_000_0247_01C5A8A2.0363D610-- From s.gnanavel@gmail.com Wed Aug 24 09:13:33 2005 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 DE2E1D6D8A for ; Wed, 24 Aug 2005 06:13:33 -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 50705-04 for ; Wed, 24 Aug 2005 09:13:29 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.206]) by svr1.postgresql.org (Postfix) with ESMTP id 4B732D6DFC for ; Wed, 24 Aug 2005 06:13:28 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z6so36342nzd for ; Wed, 24 Aug 2005 02:13:31 -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=qu6E0YBcbiP78fjVES6jcILc0uCaEwMQsMdM/sPOwvOk3VsIszDuYSjZsFhZP1y4B70RyxhGTKCXmyOE83gF9pT2nRbR9+2kfhqtH7MFo5Tn+cOCCMvKXXP7UBM/AVRoe8GLVfME+5AMAqyXJ3EgDCWc8Bxt6KhLpBWDDckSlfU= Received: by 10.37.13.7 with SMTP id q7mr468829nzi; Wed, 24 Aug 2005 02:13:31 -0700 (PDT) Received: by 10.36.119.19 with HTTP; Wed, 24 Aug 2005 02:13:31 -0700 (PDT) Message-ID: Date: Wed, 24 Aug 2005 14:43:31 +0530 From: Gnanavel S To: sandhya Subject: Re: Reg:sql command Cc: postgre , Sivakumar K In-Reply-To: <024c01c5a873$ec6da040$cd00000a@amiindiahjwbgh> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2202_14919958.1124874811436" References: <024c01c5a873$ec6da040$cd00000a@amiindiahjwbgh> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 required=5 tests=[AWL=0.228, HTML_60_70=0.027, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/292 X-Sequence-Number: 18611 ------=_Part_2202_14919958.1124874811436 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline run the psql command with -E option and do=20 \d tablename. On 8/24/05, sandhya wrote: >=20 > Hi, > Is there any equivalent command for '\d tablename'. > Inorder to get the table structure is there any SQL query in postgres? > Thank you, > Regards, > sandhya >=20 --=20 with regards, S.Gnanavel Satyam Computer Services Ltd. ------=_Part_2202_14919958.1124874811436 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline run the psql command with -E option and do
\d tablename.

On 8/24/05, sandhya <sandhyar@amiindia.co.in> wrote:
Hi,
Is there any equivalent command for '\= d=20 tablename'.
Inorder to get the table structure is = there any SQL=20 query in postgres?
 
Thank you,
Regards,
sandhya



--
with regards,S.Gnanavel
Satyam Computer Services Ltd. ------=_Part_2202_14919958.1124874811436-- From olly@lfix.co.uk Wed Aug 24 09:17:23 2005 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 52880D6EA6 for ; Wed, 24 Aug 2005 06:17:23 -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 58252-05 for ; Wed, 24 Aug 2005 09:17:21 +0000 (GMT) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by svr1.postgresql.org (Postfix) with ESMTP id 77438D6DCA for ; Wed, 24 Aug 2005 06:17:19 -0300 (ADT) Received: from lfix.demon.co.uk ([80.177.205.209] helo=cerberus.lfix.co.uk) by anchor-post-32.mail.demon.net with esmtp (Exim 4.42) id 1E7rNi-00023z-81; Wed, 24 Aug 2005 09:17:14 +0000 Received: from linda.lfix.co.uk ([192.168.1.1]) by cerberus.lfix.co.uk with esmtp (Exim 4.50) id 1E7rNT-0001Hf-6i; Wed, 24 Aug 2005 10:16:59 +0100 Subject: Re: Reg:sql command From: Oliver Elphick Reply-To: olly@lfix.co.uk To: sandhya Cc: postgre , Sivakumar K In-Reply-To: <024c01c5a873$ec6da040$cd00000a@amiindiahjwbgh> References: <024c01c5a873$ec6da040$cd00000a@amiindiahjwbgh> Content-Type: text/plain Organization: LFIX Limited Date: Wed, 24 Aug 2005 10:16:59 +0100 Message-Id: <1124875019.3560.173.camel@linda> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 Content-Transfer-Encoding: 7bit X-LFIX-MailScanner: Found to be clean X-LFIX-MailScanner-SpamCheck: not spam, SpamAssassin (score=-5.899, required 5, autolearn=not spam, ALL_TRUSTED -3.30, BAYES_00 -2.60) X-LFIX-MailScanner-From: olly@lfix.co.uk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/293 X-Sequence-Number: 18612 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 From sivakumark@aztec.soft.net Wed Aug 24 09:48:05 2005 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 CDAAED6F6D for ; Wed, 24 Aug 2005 06:48:05 -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 28425-01 for ; Wed, 24 Aug 2005 09:47:57 +0000 (GMT) Received: from param.aztec.soft.net (param.aztec.soft.net [164.164.151.8]) by svr1.postgresql.org (Postfix) with ESMTP id E3473D6F0F for ; Wed, 24 Aug 2005 06:47:55 -0300 (ADT) Received: from param.aztec.soft.net (localhost.localdomain [127.0.0.1]) by param.aztec.soft.net (8.12.8/8.11.2) with ESMTP id j7O9ka6t010849 for ; Wed, 24 Aug 2005 15:16:37 +0530 Received: from maya.aztec.soft.net (maya.aztec.soft.net [164.164.151.5])by param.aztec.soft.net (8.12.8/) with ESMTP id j7O9kZJM010814; Wed, 24 Aug 2005 15:16:35 +0530 Received: by maya.aztec.soft.net with Internet Mail Service (5.5.2657.72)id ; Wed, 24 Aug 2005 15:21:46 +0530 Message-ID: <584DE893B0E08F4B9748E295029F1E9702EA51A5@maya.aztec.soft.net> From: Sivakumar K To: olly@lfix.co.uk, sandhya Cc: postgre Subject: Re: Reg:sql command Date: Wed, 24 Aug 2005 15:21:44 +0530 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain X-imss-version: 2.030 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.328 required=5 tests=[AWL=-0.046, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200508/294 X-Sequence-Number: 18613 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@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 From sivakumark@aztec.soft.net Wed Aug 24 09:51:14 2005 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 B6040D70A0 for ; Wed, 24 Aug 2005 06:51:14 -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 28433-04 for ; Wed, 24 Aug 2005 09:51:12 +0000 (GMT) Received: from param.aztec.soft.net (param.aztec.soft.net [164.164.151.8]) by svr1.postgresql.org (Postfix) with ESMTP id 30637D7048 for ; Wed, 24 Aug 2005 06:51:10 -0300 (ADT) Received: from param.aztec.soft.net (localhost.localdomain [127.0.0.1]) by param.aztec.soft.net (8.12.8/8.11.2) with ESMTP id j7O9nq6t011948 for ; Wed, 24 Aug 2005 15:19:52 +0530 Received: from maya.aztec.soft.net (maya.aztec.soft.net [164.164.151.5])by param.aztec.soft.net (8.12.8/) with ESMTP id j7O9nqJM011918; Wed, 24 Aug 2005 15:19:52 +0530 Received: by maya.aztec.soft.net with Internet Mail Service (5.5.2657.72)id ; Wed, 24 Aug 2005 15:25:03 +0530 Message-ID: <584DE893B0E08F4B9748E295029F1E9702EA51D2@maya.aztec.soft.net> From: Sivakumar K To: olly@lfix.co.uk, sandhya Cc: postgre Subject: Re: Reg:sql command Date: Wed, 24 Aug 2005 15:25:03 +0530 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain X-imss-version: 2.030 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.333 required=5 tests=[AWL=-0.041, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200508/295 X-Sequence-Number: 18614 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@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 From s.gnanavel@gmail.com Wed Aug 24 11:52:00 2005 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-- From jnasby@pervasive.com Wed Aug 24 18:19:33 2005 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 1DFFAD793D for ; Wed, 24 Aug 2005 15:19:33 -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 34005-03 for ; Wed, 24 Aug 2005 18:19:31 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 78885D7952 for ; Wed, 24 Aug 2005 15:19:27 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id E1D661525A; Wed, 24 Aug 2005 13:19:23 -0500 (CDT) Date: Wed, 24 Aug 2005 13:19:23 -0500 From: "Jim C. Nasby" To: Gnanavel S Cc: sandhya , postgre , Sivakumar K Subject: Re: Reg:sql command Message-ID: <20050824181923.GS96732@pervasive.com> References: <024c01c5a873$ec6da040$cd00000a@amiindiahjwbgh> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.01 required=5 tests=[AWL=0.010] X-Spam-Level: X-Archive-Number: 200508/305 X-Sequence-Number: 18624 You should also take a look at http://pgfoundry.org/projects/newsysviews/; it makes getting this kind of info out of the database much easier. On Wed, Aug 24, 2005 at 02:43:31PM +0530, Gnanavel S wrote: > run the psql command with -E option and do > \d tablename. > > On 8/24/05, sandhya wrote: > > > > Hi, > > Is there any equivalent command for '\d tablename'. > > Inorder to get the table structure is there any SQL query in postgres? > > Thank you, > > Regards, > > sandhya > > > > > > -- > with regards, > S.Gnanavel > Satyam Computer Services Ltd. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com 512-569-9461