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 9E3813A4550 for ; Mon, 1 Nov 2004 12:13:27 +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 99643-08 for ; Mon, 1 Nov 2004 12:13:15 +0000 (GMT) Received: from sv0.iquer.net (sv0.iquer.net [195.234.230.122]) by svr1.postgresql.org (Postfix) with SMTP id 4B8BA3A4548 for ; Mon, 1 Nov 2004 12:13:13 +0000 (GMT) Received: (qmail 19539 invoked by uid 108); 1 Nov 2004 12:13:11 -0000 Received: from unknown (HELO fuzz.int.iquer.net) (10.0.17.20) by sv0.iquer.net with SMTP; 1 Nov 2004 12:13:11 -0000 From: Erik Wasser To: pgsql-sql@postgresql.org Subject: 'show databases' in psql way? Date: Mon, 1 Nov 2004 13:13:10 +0100 User-Agent: KMail/1.7 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200411011313.10872.erik.wasser@iquer.net> 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/3 X-Sequence-Number: 19322 Hi list, 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. Ideas? Solutions? -- So long... Fuzz