<?php

  $user = "jobdb";
  $pass = "password";

  try
  {
      $db = new PDO('pgsql:host=localhost;dbname=jobdb', $user, $pass);
  }

  catch (PDOException $e)
  {
      print "Error!: " . $e->getMessage() . "<br/>";
      die();
  }

  $stmt = $db->query('SELECT * from jobs');
   $result = $stmt->fetchAll();
  foreach( $result as $row)
  {
      print_r($row);
  }

?>