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 1BF1B3A3C7F for ; Tue, 2 Nov 2004 14:17:17 +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 56792-06 for ; Tue, 2 Nov 2004 14:17:08 +0000 (GMT) Received: from screen.dri.edu (screen.dri.edu [134.197.100.251]) by svr1.postgresql.org (Postfix) with ESMTP id 285623A3B01 for ; Tue, 2 Nov 2004 14:17:10 +0000 (GMT) Received: (from fw_mx@localhost) by screen.dri.edu (8.9.1b+Sun/8.9.1) id GAA12805; Tue, 2 Nov 2004 06:17:06 -0800 (PST) Received: from derringer.dri.edu( 10.10.9.111) by screen.dri.edu via smap (V2.1.dri) id xma012794; Tue, 2 Nov 04 06:16:23 -0800 Received: from dri.edu (ppp17.dri.edu [10.10.8.217]) by derringer.dri.edu (8.9.3+Sun/8.9.1) with ESMTP id GAA01942; Tue, 2 Nov 2004 06:16:21 -0800 (PST) Message-ID: <41879882.6000506@dri.edu> Date: Tue, 02 Nov 2004 06:24:02 -0800 From: lorid User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7a) Gecko/20040219 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Erik Wasser Cc: pgsql-sql@postgresql.org Subject: Re: 'show databases' in psql way? References: <200411011313.10872.erik.wasser@iquer.net> In-Reply-To: <200411011313.10872.erik.wasser@iquer.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/15 X-Sequence-Number: 19334 \z will list the tables in the dbase \d tablename will list the columns in the table --------------------- Erik Wasser wrote: >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? > > >