setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->beginTransaction(); $stmt = $db->prepare("SELECT doc FROM document WHERE id = ?"); $stmt->execute(array(1)); $stmt->bindColumn('doc', $oid, PDO::PARAM_STR); $stmt->fetch(PDO::FETCH_BOUND); $stream = $db->pgsqlLOBOpen($oid, 'r'); header("Content-type: application/pdf"); fpassthru($stream); ?>