select * from pg_tables where tablename not like 'pg_%' -----Original Message----- From: David C. Brown [mailto:dbrown@xxxxxxxxxxxxxxxxxxx] Sent: Tuesday, October 16, 2001 10:09 PM To: pgsql-php@xxxxxxxxxxxxxx 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
