select * from pg_tables where tablename not like 'pg_%'
-----Original Message-----
From: David C. Brown [mailto:dbrown@centennialwines.com]
Sent: Tuesday, October 16, 2001 10:09 PM
To: pgsql-php@postgresql.org
Subject: [PHP] Retrieving a list of tables
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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster