Hello group
I am trying to follow through on advice I received from you earlier. I
would like to check for my database when I logon and if it is not there
create it( I am using php to write web apps). I am able to connect to
the template1 and query for pg_database. But I am getting a parse error
on the following (XXX).
Error message:
"Expected T_STRING or T_VARIABLE"
Code :
$link=pg_connect('user=marcel dbname=template1') or die ("Couldn't
connect to template1 try again.<br>");
$query = "SELECT * FROM pg_database";
$result = pg_query ($query) or die ("Couldn't get the
database names".pg_last_error());
// If it worked get the database names.
$database= pg_fetch_array ($result) or print ("Can't get the
array of databases<br>");
XXX print (" the 1st database is $database['datname'].<br>");
die ("Finshed my test.<br>");
Is this the correct way to query the system catalog for the existing
databases? Is this questions addressed to the wrong group and maybe
should be addressed to the php_pgsql group?
Again thanks for the help
Marcel Wolf