SHOW TABLES with PostgreSQL and PHP

bubblenut

How can I list the tables in a database using PostgreSQL, through PHP. I know about the \dt command but this doesn't seem to work through PHP. I've tried the following where $sql is equal to "dt" "\dt" "\dt" "show tables" "pretty pretty pretty please show me the tables".

$res=pg_select($sql);

Thanks
Bubblenut

tsinka

Hi,

read the user contributed notes in the manual, especially the ones posted by
74012 dot 2773 at compuserve dot com
and
abondi at ijk dot it

Thomas

bubblenut

WOOOT!! 😃
Cheers tsinka, I should have really got that one myself but I always forget about those handy little comments at the bottom. :p