SELECT vs COPY (SELECT) TO STDOUT
As far as the server and the network protocol are concerned, the result of a query and the binary COPY protocol are pretty much identical.

So you would choose COPY only if your client's PG library handles it better in your situation.