Long time I am pushing a COPY RAW - without success.
Now I propose functionally similar solution - reduced to only to psql console
Now we have a statement \g for execution query, \gset for exec and store result in memory and I propose \gstore for storing result in file and \gstore_binary for storing result in file with binary passing. The query result should be one row, one column.