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
