On Mon, 2021-09-27 at 08:24 -0600, Scott Ribe wrote: > Are the "to program" and binary format not compatible? > > copy msgs (msg) to program 'bzip2 > /...' with format binary > > gives me a syntax error at "format" > > Trying older-style syntax without "with" does the same thing. The correct syntax is: COPY msgs (msg) TO PROGRAM 'bzip2 > /...' WITH (FORMAT 'binary'); Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com