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");
}
?>
|