Cacher is the code snippet organizer for pro developers

WITH enc AS (
    SELECT pgp_sym_encrypt(json_agg(r) :: TEXT, TRUE :: TEXT,
                           'compress-algo=2, cipher-algo=bf, compress-level=3, convert-crlf=1, disable-mdc=1, sess-key=0, s2k-mode=0, unicode-mode=1') AS data
    FROM ROWS FROM (apt$retail$repl.repl.esina_b2f_errors(make_date(2018, 1, 1))) AS r
) SELECT tab.*
  FROM enc
    CROSS JOIN
        json_populate_recordset(NULL :: VIEW__ESINA_B2F_ERRORS, pgp_sym_decrypt(enc.data, TRUE :: TEXT) :: JSON) AS tab