On Wed, 2019-12-11 at 21:07 -0700, S.Bob wrote: > we have a client that needs us to pull data via sql and stage it in a > file with odd hex / octal characters as the field delimiter (Hex 1F or > Oct 31) > > Is there an easy way to do this ? No problem: COPY uni TO ... (FORMAT 'csv', DELIMITER E'\u001F') Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com