begin;
create temporary table _temp_debtags_sha256
(
    sha256 sha256
) on commit drop;

COPY _temp_debtags_sha256 (sha256) FROM STDIN;
\\xfb78f9b3c701509d42cb7709dc495b5723aedfe8b306cf60e3aaa73904a9015d
\\x1aca7c611b16204ab8d9fbe9f228d2ad2f501c28ed8980fef4dbff99dfd38075
\\x610ebae9d6b7066c3960c81061210a7784c518fd1d87771ade04a5cfa2abad3f
\.

select t.sha256, sha1
from _temp_debtags_sha256 t
left join content
using (sha256);
commit;