, , and below with your actual DB, user, and password. $db_conn = new PDO("pgsql:dbname=;user=" . . ";password=" . . ";host=localhost"); $query = $db_conn->prepare("select * from testschema.testtable order by test_id"); $query->execute(); while($row = $query->fetch()) { var_dump($row); } ?>