Received: from bush.rutgersinsurance.com (rutgersinsurance.com [38.138.71.194]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA1GdKl73431 for ; Wed, 1 Nov 2000 11:39:20 -0500 (EST) (envelope-from aalang@rutgersinsurance.com) Received: from 6014cwpza006 ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id LAA04831 for ; Wed, 1 Nov 2000 11:44:24 -0500 Message-ID: <018701c04422$9df91ee0$330a0a0a@6014cwpza006> From: "Adam Lang" Cc: References: Subject: Re: listing databases Date: Wed, 1 Nov 2000 11:41:43 -0500 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 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200011/10 X-Sequence-Number: 18 How would you use that with PHP though? Can you get the info back as something you can parse or interpret? Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Tod McQuillin" To: "magnus" Cc: Sent: Wednesday, November 01, 2000 11:05 AM Subject: Re: [PHP] listing databases > On Wed, 1 Nov 2000, magnus wrote: > > > Hello, > > Can anyone tell me how to list (1.) databases and (2.) tables in a > > database using php? > > To list databases, run > > psql -l > > from your unix shell prompt. > > Once connected, enter \dt to list the tables. > -- > Tod McQuillin >