X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1EB64D1E913 for ; Mon, 1 Mar 2004 22:44:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 29573-06 for ; Mon, 1 Mar 2004 18:44:54 -0400 (AST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id CBEB7D1E14C for ; Mon, 1 Mar 2004 18:44:51 -0400 (AST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i21MhLsw008750; Mon, 1 Mar 2004 15:43:21 -0700 (MST) Date: Mon, 1 Mar 2004 15:31:17 -0700 (MST) From: "scott.marlowe" To: Chris Smith Cc: "'Chris Boget'" , "'Majolee InfoTech'" , "'Wim Paulussen'" , Subject: Re: get list of databases and tables in Postgres In-Reply-To: <000701c3ffdc$dfb169e0$0d00a8c0@chris> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-IHS-MailScanner-Envelope-Sender: scott.marlowe@ihs.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/9 X-Sequence-Number: 2608 If you're running 7.4, look into the iformation_schema for such things. That likely won't change. On Tue, 2 Mar 2004, Chris Smith wrote: > He wants to do it through PHP - so I don't think this will work. > > You could always > > psql -E -l > > BUT - that query *could* change depending on the version of postgresql > you're running. > > Chris. > > -----Original Message----- > From: pgsql-php-owner@postgresql.org > [mailto:pgsql-php-owner@postgresql.org] On Behalf Of Chris Boget > Sent: Tuesday, March 02, 2004 1:29 AM > To: Majolee InfoTech; Wim Paulussen > Cc: pgsql-php@postgresql.org > Subject: Re: [PHP] get list of databases and tables in Postgres > > > > select datname from pg_database; > > Or simply: > > \d > > unless I'm missing something... > > Chris > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >