Received: from hapcibeno.freestart.hu (hapcibeno.freestart.hu [213.197.64.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9IAiPP08013 for ; Thu, 18 Oct 2001 06:44:25 -0400 (EDT) (envelope-from pgerzson@freestart.hu) Received: from erinyes.freestart.hu ([213.197.64.251] helo=jaguar) by freestart.hu with smtp (Freestart relay 2 (FS-Lin)) id 15uAuP-0000OE-00; Thu, 18 Oct 2001 13:00:17 +0200 Message-ID: <001401c157c2$0898fb40$01fdfea9@jaguar> From: "Papp Gyozo" To: "David C. Brown" Cc: References: Subject: Re: Retrieving a list of tables Date: Thu, 18 Oct 2001 12:43:54 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Scanner: exiscan by Freestart X-Archive-Number: 200110/76 X-Sequence-Number: 629 If you runs psql with -E option, then psql reveals the SQL equivalent of its magical metacommands starting with a backslash ie.: \dv \d and so on. Use those queries ! -E, --echo-hidden Echoes the actual queries generated by \d and other backslash commands. You can use this if you wish to include similar functionality into your own programs. This is equivalent to setting the variable ECHO_HIDDEN from within psql. ----- Original Message ----- From: To: "David C. Brown" Cc: Sent: Wednesday, October 17, 2001 10:59 PM Subject: Re: [PHP] Retrieving a list of tables > On Tue, 16 Oct 2001, David C. Brown wrote: > > > Heyas, > > > > I need to be able to get a list of the tables from a postgresql from > > php. I'm > > porting a php-mysql website over to postgresql. I have a form that > > populates > > a