On 03/03/2015 06:18 AM, Tim Semmelhaack wrote:
Hi,
I want to copy data between two servers (Version 9.1 and 9.4)
I've tried
psql -h host1 -U user1 -d db1 -f /q1.sql | psql -h host2 -U user2 -d db2 -f
/q2.sql
Both sql-scripts include the COPY (SELECT ...) TO STDOUT or COPY (SELECT
...) TO STDIN
As a result nothing is copied.
When I run a much simpler version of the query with the -c "Select .."
option it works. Because the sql-scripts are quite long, I don't to do it
without the -f option.
Have you tried?:
psql -h host1 -U user1 -d db1 < /q1.sql | psql -h host2 -U user2 -d db2
< /q2.sql
So where is the difference between the -c and the -f option?
Tim
-- Semmelhaack(at)gmx(dot).de
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
