Postgres Pro
Downloads
Home   >   mailing lists

Re: copy data from one db into another via copy & psql - Mailing list pgsql-general

From Jasen Betts
Subject Re: copy data from one db into another via copy & psql
Date
Msg-id ht8c2j$8ik$1@reversiblemaps.ath.cx
Whole thread Raw
In response to copy data from one db into another via copy & psql  (Kevin Kempter <kevink@consistentstate.com>)
List pgsql-general
Tree view 
On 2010-05-21, Kevin Kempter <kevink@consistentstate.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.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Is postgres installed?
Next
From: Deepa Thulasidasan
Date:
Subject: Help reqd on azimuth finction