Re: copy data from one db into another via copy & psql

On 2010-05-21, Kevin Kempter <kevink(at)consistentstate(dot)com> wrote:
> Can I copy from one db (via COPY) and pipe the results to a psql/COPY stmt so
> I can load the data into a table in the second db 'inline' without writing to
> & reading from a flat file?

Yes.

COPY ... TO stdout;

at the source and

COPY ... FROM stdin;

at the destination.

I use this with the

COPY ( query ) TO STDOUT ;

syntax when I want to copy only a few rows.