Código PHP:
function pg_list_tables() {
$conex = _CONEXION_
$sql = "SELECT a.relname AS Name
FROM pg_class a, pg_user b
WHERE ( relkind = 'r') and relname !~ '^pg_' AND relname !~ '^sql_'
AND relname !~ '^xin[vx][0-9]+' AND b.usesysid = a.relowner
AND NOT (EXISTS (SELECT viewname FROM pg_views WHERE viewname=a.relname));";
$res = pg_query($conex, $sql);
$rows = pg_fetch_all($res);
return $rows;
}
$rows es una array bidimensional