From May 31, 2006; 12:03pm . . .
"It struck me that we are missing a feature that's fairly common in Unix programs.
Perhaps COPY ought to have the ability to pipe its output to a shell command,
or read input from a shell command. "
Maybe something like:
COPY mytable TO '| gzip >/home/tgl/mytable.dump.gz';
Is such a feature (ie being able to tell postgres to write a compressed file via COPY TO) being worked on ?
-dvs-