From sandhyar@amiindia.co.in Thu Sep 22 09:40:41 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 33810D84AD for ; Thu, 22 Sep 2005 06:40:41 -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 02751-10 for ; Thu, 22 Sep 2005 09:40:34 +0000 (GMT) Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr1.postgresql.org (Postfix) with ESMTP id D1F45D8C88 for ; Thu, 22 Sep 2005 06:40:30 -0300 (ADT) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.10/8.12.11) with ESMTP id j8M9bsfT010413; Thu, 22 Sep 2005 15:07:57 +0530 Message-ID: <012401c5bf5a$b06b48b0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" Subject: Reg: sql commands Date: Thu, 22 Sep 2005 15:17:44 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0121_01C5BF88.C85F3F70" 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-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.061 required=5 tests=[AWL=-0.017, FORGED_RCVD_HELO=0.05, HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/225 X-Sequence-Number: 18962 This is a multi-part message in MIME format. ------=_NextPart_000_0121_01C5BF88.C85F3F70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi... Is there any equivalent sql commands/queries for=20 ' \l ' (which list out all the databases) and=20 ' \dt ' ( Which lists all the Tables of the current database) If anybody knows Please tell me.Or If there is any way to get the info = of databases and tables pls..Explain me This is very much required for me to proceed further.. Thank you very much....... -Sandhya ------=_NextPart_000_0121_01C5BF88.C85F3F70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi...
    Is there any = equivalent sql=20 commands/queries for
' \l '   = (which list out=20 all the databases) and
' \dt ' ( Which = lists all the=20 Tables of the current database)
If anybody knows Please tell me.Or If = there is any=20 way to get the info of databases and tables pls..Explain me
This is very much required for me to = proceed=20 further..
 
Thank you very much.......
 
-Sandhya
 
------=_NextPart_000_0121_01C5BF88.C85F3F70-- From svb@ucs.co.za Thu Sep 22 10:09:02 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 8D1C7D9054 for ; Thu, 22 Sep 2005 07:09:02 -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 07272-10 for ; Thu, 22 Sep 2005 10:08:56 +0000 (GMT) Received: from ucsns.ucs.co.za (ucsns.ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id C9B7ED9033 for ; Thu, 22 Sep 2005 07:08:57 -0300 (ADT) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 5E2842BD43; Thu, 22 Sep 2005 12:08:57 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 6B0A5D9F62; Thu, 22 Sep 2005 12:08:55 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with ESMTP id 3FF47977C6; Thu, 22 Sep 2005 12:08:53 +0200 (SAST) Date: Thu, 22 Sep 2005 12:08:52 +0200 From: Stef To: "sandhya" Cc: "postgre" , "sandhya" Subject: Re: Reg: sql commands Message-ID: <20050922120852.543390ca@svb.ucs.co.za> In-Reply-To: <012401c5bf5a$b06b48b0$cd00000a@amiindiahjwbgh> References: <012401c5bf5a$b06b48b0$cd00000a@amiindiahjwbgh> X-Mailer: Sylpheed-Claws 1.9.6cvs1 (GTK+ 2.6.9; i486-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YEWH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@ X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 required=5 tests=[AWL=0.178] X-Spam-Level: X-Archive-Number: 200509/226 X-Sequence-Number: 18963 psql -E To see what that does : man psql sandhya mentioned : => Hi... => Is there any equivalent sql commands/queries for => ' \l ' (which list out all the databases) and => ' \dt ' ( Which lists all the Tables of the current database) => If anybody knows Please tell me.Or If there is any way to get the info of databases and tables pls..Explain me => This is very much required for me to proceed further.. => => Thank you very much....... => => -Sandhya From light@theendofthetunnel.de Thu Sep 22 10:30: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 31421D9273 for ; Thu, 22 Sep 2005 07:30: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 11624-08 for ; Thu, 22 Sep 2005 10:30:00 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 16EBDD900C for ; Thu, 22 Sep 2005 07:30:01 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j8MATwrc018572 for ; Thu, 22 Sep 2005 10:29:58 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j8MAItJV015772 for pgsql-admin@postgresql.org; Thu, 22 Sep 2005 10:18:55 GMT (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: Reg: sql commands Date: Thu, 22 Sep 2005 12:18:55 +0200 Organization: Hub.Org Networking Services Lines: 4 Message-ID: References: <012401c5bf5a$b06b48b0$cd00000a@amiindiahjwbgh> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <012401c5bf5a$b06b48b0$cd00000a@amiindiahjwbgh> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.486 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.334] X-Spam-Level: X-Archive-Number: 200509/228 X-Sequence-Number: 18965 Start psql with -E option to see the statements used internally. On 22.09.2005 11:47, sandhya wrote: > Is there any equivalent sql commands/queries for From sandhyar@amiindia.co.in Thu Sep 22 10:26:54 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 B24B0D914E for ; Thu, 22 Sep 2005 07:26:54 -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 12925-08 for ; Thu, 22 Sep 2005 10:26:49 +0000 (GMT) Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr1.postgresql.org (Postfix) with ESMTP id 1C192D90DE for ; Thu, 22 Sep 2005 07:26:48 -0300 (ADT) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.10/8.12.11) with ESMTP id j8MAOEfT012648; Thu, 22 Sep 2005 15:54:21 +0530 Message-ID: <014101c5bf61$2bb37000$cd00000a@amiindiahjwbgh> From: "sandhya" To: "Stef" Cc: "postgre" References: <012401c5bf5a$b06b48b0$cd00000a@amiindiahjwbgh> <20050922120852.543390ca@svb.ucs.co.za> Subject: Re: Reg: sql commands Date: Thu, 22 Sep 2005 16:04:04 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.048 required=5 tests=[AWL=-0.002, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/227 X-Sequence-Number: 18964 No...What i need is... I want to know the equivalent sql queries for \l and \dt commands in order to list the databases and tables. I want to do it through programming Thanks Sandhya ----- Original Message ----- From: "Stef" To: "sandhya" Cc: "postgre" ; "sandhya" Sent: Thursday, September 22, 2005 3:38 PM Subject: Re: [ADMIN] Reg: sql commands > psql -E > > To see what that does : > man psql > > sandhya mentioned : > => Hi... > => Is there any equivalent sql commands/queries for > => ' \l ' (which list out all the databases) and > => ' \dt ' ( Which lists all the Tables of the current database) > => If anybody knows Please tell me.Or If there is any way to get the info of databases and tables pls..Explain me > => This is very much required for me to proceed further.. > => > => Thank you very much....... > => > => -Sandhya > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly From sandhyar@amiindia.co.in Thu Sep 22 10:43:58 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 03682DA4FB for ; Thu, 22 Sep 2005 07:43:58 -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 17908-10 for ; Thu, 22 Sep 2005 10:43:52 +0000 (GMT) Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr1.postgresql.org (Postfix) with ESMTP id 7B75BD9944 for ; Thu, 22 Sep 2005 07:43:42 -0300 (ADT) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.10/8.12.11) with ESMTP id j8MAfDfT013331; Thu, 22 Sep 2005 16:11:14 +0530 Message-ID: <016001c5bf63$87fa4300$cd00000a@amiindiahjwbgh> From: "sandhya" To: "Hannes Dorbath" , References: <012401c5bf5a$b06b48b0$cd00000a@amiindiahjwbgh> Subject: Re: Reg: sql commands Date: Thu, 22 Sep 2005 16:21:03 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.047 required=5 tests=[AWL=-0.003, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/229 X-Sequence-Number: 18966 Thank you......Hannes ----- Original Message ----- From: "Hannes Dorbath" To: Sent: Thursday, September 22, 2005 3:48 PM Subject: Re: [ADMIN] Reg: sql commands > Start psql with -E option to see the statements used internally. > > On 22.09.2005 11:47, sandhya wrote: > > Is there any equivalent sql commands/queries for > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly From svb@ucs.co.za Thu Sep 22 10:54:31 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 9CEF2DA548 for ; Thu, 22 Sep 2005 07:54:31 -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 25300-01 for ; Thu, 22 Sep 2005 10:54:25 +0000 (GMT) Received: from ucsns.ucs.co.za (ucsns.ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id 27A02D83D0 for ; Thu, 22 Sep 2005 07:54:25 -0300 (ADT) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 9D6992BD44; Thu, 22 Sep 2005 12:54:27 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 82D02D9F62; Thu, 22 Sep 2005 12:54:27 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with ESMTP id 88C41977C4; Thu, 22 Sep 2005 12:54:27 +0200 (SAST) Date: Thu, 22 Sep 2005 12:54:27 +0200 From: Stef To: "sandhya" Cc: "postgre" Subject: Re: Reg: sql commands Message-ID: <20050922125427.1e60e1df@svb.ucs.co.za> In-Reply-To: <014101c5bf61$2bb37000$cd00000a@amiindiahjwbgh> References: <012401c5bf5a$b06b48b0$cd00000a@amiindiahjwbgh> <20050922120852.543390ca@svb.ucs.co.za> <014101c5bf61$2bb37000$cd00000a@amiindiahjwbgh> X-Mailer: Sylpheed-Claws 1.9.6cvs1 (GTK+ 2.6.9; i486-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YEWH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@ X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.168 required=5 tests=[AWL=0.168] X-Spam-Level: X-Archive-Number: 200509/230 X-Sequence-Number: 18967 sandhya mentioned : =3D> No...What i need is... =3D> I want to know the equivalent sql queries for \l and \dt commands in o= rder =3D> to list the databases and tables. =3D> I want to do it through programming =46rom the psql man-page : -E --echo-hidden Echoes the actual queries generated by \d and other backslash commands. You can use this if you wish to include similar func- tionality into your own programs. This is equivalent to setting the variable ECHO_HIDDEN from within psql. If this is not _exactly_ what you need, then you're not exactly=20 explaining what you're trying to do :)