Trying to follow the example in http://php.net/manual/en/pdo.query.php and connecting with
$dbh = new PDO('pgsql:host=localhost;port=5432;dbname=example;user=postgres');
and running query
foreach ($dbh->query('SELECT * from Animals') as $row) {
print $row;
}
I am getting the error:
Warning: Invalid argument supplied for foreach() in /Users/zaitsev/tests/pg-php/pdo-test.php on line 13
What is wrong here?