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. So where is the difference between the -c and the -f option? Tim -- Semmelhaack(at)gmx(dot).de -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
