
Código PHP:
$fp = fopen($photo, 'rb');
$buffer = fread($fp, filesize($photo));
$buff = pg_escape_bytea($buffer);
$sql = "SELECT record_id as id FROM public.photos WHERE id_card='$id_card'";
$rps = $this->connPg->query($sql);
$r = $rps->fetch();
if ($r['id']) {
$sql = "UPDATE public.photos SET archivo_bytea='$buff',created_date=now() WHERE id_card='$id_card'";
$this->connPg->query($sql);
}
fclose($fp);