PHP SQL - what is postgres equivalent to mysql SHOW

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

what is postgres equivalent to mysql SHOW

Denzity

2004-08-18, 3:57 pm

I have a query that shows the tables in a MySQL database--------
STblquery= "SHOW tables like '%lkp%'";
result = pg_exec(STblquery,
connection);
--------
This lists all the lookup tables.
We have recently migrated to a postgresql db so need to know the
postgresql equivalent to SHOW.

thanks in advance.

D

----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums

Sponsored Links