Retrieving a list of tables

From: "David C(dot) Brown" <dbrown(at)centennialwines(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: Retrieving a list of tables
Date: 2001-10-16 20:09:13
Message-ID: 3BCC93E9.E3B2F503@centennialwines.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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 <SELECT> statment with the tables in the db.

In Mysql I just used the sql query "SHOW TABLES;" postgresql doesn't
support that sql statment, and pg-php doesn't like me sending a "\d" as
a
query.

Anyone have any help, or ideas how I may be able to work around this?
or is there a query for pg-sql that I don't know about?

Any and all help would be great... Thanx

Dave

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Ben.Westgarth 2001-10-16 23:01:59 Re: Encrypt given Data
Previous Message Adam Lang 2001-10-16 16:46:51 Re: Encrypt given Data