--=-m8vcQcyxIr2PM/90tEMh
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
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.com.au
--=-m8vcQcyxIr2PM/90tEMh
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
Try <BR>
SELECT datname FROM pg_database<BR>
<BR>
eg:<BR>
<BR>
<?<BR>
$db="template1";<BR>
$db_connect=pg_connect("host=192.168.101.1 user=postgres port=5432 dbname=$db");<BR>
$db_query="SELECT datname FROM pg_database";<BR>
$db_result=pg_exec($db_connect, $db_query);<BR>
$db_numrows=pg_numrows($db_result);<BR>
<BR>
//display results<BR>
<BR>
for ($i=0; $i<$db_numrows; $i++)<BR>
{<BR>
$pg_data=pg_fetch_row($db_result, $i);<BR>
printf("$pg_data[0]\n");<BR>
}<BR>
?><BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
<DIV ALIGN=center><A HREF="mailto:admin [at] paransolutions.com.au">admin [at] paransolutions.com.au</A></DIV><BR>
<BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>
--=-m8vcQcyxIr2PM/90tEMh--
