Retrieve a list of databases using PHP

Try
SELECT datname FROM pg_database

eg:

<?
$db="template1";
$db_connect=pg_connect("host=192.168.101.1 user=postgres port=5432
dbname=$db");
$db_query="SELECT datname FROM pg_database";
$db_result=pg_exec($db_connect, $db_query);
$db_numrows=pg_numrows($db_result);

//display results

for ($i=0; $i<$db_numrows; $i++)
{
$pg_data=pg_fetch_row($db_result, $i);
printf("$pg_data[0]\n");
}
?>

admin(at)paransolutions(dot)com(dot)au