Из еpoch в timestamp:
   'epoch'::timestamptz  + '$epoch_time sec'::interval
   или $epoch_time::int4::abstime::timestamptz
   или timestamptz 'epoch' + '$epoch_time second'

Из timestamp в epoch:
   date_part('epoch', timestamp_field)