Quick Links

copy data from one db into another via copy & psql

From:	Kevin Kempter <kevink(at)consistentstate(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	copy data from one db into another via copy & psql
Date:	2010-05-21 04:59:39
Message-ID:	201005202259.39757.kevink@consistentstate.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

Responses

Re: copy data from one db into another via copy & psql at 2010-05-21 05:27:17 from A. Kretschmer
Re: copy data from one db into another via copy & psql at 2010-05-21 06:24:19 from Scott Marlowe
Re: copy data from one db into another via copy & psql at 2010-05-22 10:36:03 from Jasen Betts

Browse pgsql-general by date

	From	Date	Subject
Next Message	A. Kretschmer	2010-05-21 05:27:17	Re: copy data from one db into another via copy & psql
Previous Message	Peter Hunsberger	2010-05-21 04:37:35	Re: How to lose transaction history (xmin values, WAL, etc.)?