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