X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E1743A4558 for ; Mon, 1 Nov 2004 12:25:35 +0000 (GMT) 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 04364-05 for ; Mon, 1 Nov 2004 12:25:23 +0000 (GMT) Received: from tomts36-srv.bellnexxia.net (tomts36-srv.bellnexxia.net [209.226.175.93]) by svr1.postgresql.org (Postfix) with ESMTP id AF0453A4516 for ; Mon, 1 Nov 2004 12:25:22 +0000 (GMT) Received: from acer.sympatico.ca ([65.95.133.169]) by tomts36-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with ESMTP id <20041101122522.WAA7954.tomts36-srv.bellnexxia.net@acer.sympatico.ca> for ; Mon, 1 Nov 2004 07:25:22 -0500 Message-Id: <5.2.1.1.0.20041101072247.03e4c3c0@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Mon, 01 Nov 2004 07:23:54 -0500 To: pgsql-sql@postgresql.org From: Frank Bax Subject: Re: 'show databases' in psql way? In-Reply-To: <200411011313.10872.erik.wasser@iquer.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/4 X-Sequence-Number: 19323 At 07:13 AM 11/1/04, Erik Wasser wrote: >how can I list the databases in a postgresish way? I know about the '-l' >switch of 'psql' but is there a DBI/SQL-query way? I don't want to call >an external program only to list the databases. I've googled about this >problem but I only found the '-l'-way to this this. The -e switch of psql will display queries behind commands. So use this option, the use 'l' as a command instead of a switch. Frank