From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Possible TODO item: copy to/from pipe
Date: Sat, 3 Jun 2006 20:12:05 -0400 (EDT)
Message-ID: <200606040012.k540C5V29587@candle.pha.pa.us> (raw)
In-Reply-To: <447DB844.6010507@pse-consulting.de>
Andreas Pflug wrote:
> Tom Lane wrote:
> > After re-reading what I just wrote to Andreas about how compression of
> > COPY data would be better done outside the backend than inside, 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';
For use case, consider this:
COPY mytable TO '| rsh x@y.com > test ';
so you can COPY to another server directly.
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: pgman@candle.pha.pa.us, pgadmin@pse-consulting.de, tgl@sss.pgh.pa.us
Subject: Re: Possible TODO item: copy to/from pipe
In-Reply-To: <200606040012.k540C5V29587@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox