COPY TO '|gzip > /my/cool/file.gz'

[<david.sahagian@xxxxxxx>]

>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-


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general