>I could write a SCAN that would do this in less time than all the time I wasted with COPY TO but that's no fun, is it?
>If you figure it out, lets us know how you did it,
There's some of fatal attraction to the COPY TO command, to it's promise that it can be done in an one-liner. So we rather waste 20 messages and eventually write ten lines of code, while still trying to find the combination of parameters which will give us what we want.
And those ten lines of code are just waiting to happen. Since the first step.