Code: Select all
if (pg_connection_status($connection)==PGSQL_CONNECTION_OK){
$result = pg_query($connection, "select * from pg_tables where schemaname='public';");
echo "<br />";
$row = pg_fetch_row($result);
echo "first cell: $row[0]";
echo "$row[1]";
echo "$row[2]";
echo "$row[3]";
echo "<br />";
echo pg_last_error($connection);
}Code: Select all
"select * from pg_tables where schemaname='public';"I am definitely a beginner in both PHP and PostgreSQL so I would be very grateful if I could get help with this. I have spent about twenty minutes trying to find answers with no luck so far. Thanks in advance for whatever help you can offer!