Preview:
select max(f)
from (with t as (
    select format(
                          'COPY (SELECT  cast(s.operativen_prot as bytea)
            FROM migration.mssql_patient_dosie_data s
            where s.dep_patient_id = %s) TO ''%s''',
                          f.dep_patient_id, concat('/archive/ss-storage/Protocol2/', f.dep_patient_id, '.hex')) as query
           from migration.mssql_patient_dosie_data f
           where f.operativen_prot is not null
)
      select f_execute_test(query) f

      from t) as t
;
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter