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

Поиск
Список
Период
Сортировка
От
Тема COPY TO '|gzip > /my/cool/file.gz'
Дата
Msg-id F3CBFBA88397EA498B22A05FFA9EC49D297B9C4E@MX22A.corp.emc.com
обсуждение исходный текст
Ответы Re: COPY TO '|gzip > /my/cool/file.gz'  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
Re: COPY TO '|gzip > /my/cool/file.gz'  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-general
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-


В списке pgsql-general по дате отправления:

Предыдущее
От: Rick Genter
Дата:
Сообщение: Re: Another unexpected behaviour
Следующее
От: Vibhor Kumar
Дата:
Сообщение: Re: COPY TO '|gzip > /my/cool/file.gz'