el codigo es el siguiente
Código PHP:
<?php
$conn = pg_connect("user=usuario password=1234 dbname=mibd host=localhost") or die('No pudo conectarse: ' . pg_last_error());
$query = pg_query($conn, "SELECT foto FROM contactos WHERE id = 559");
$row = pg_fetch_row($query);
$image = pg_unescape_bytea($row[0]);
header("Content-type: image/jpeg");
echo $image;
pg_close($conn);
?>