By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 1,905 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

Issue With COPY TO STDOUT / COPY FROM STDIN

P: 1
I seem to be having issues with the <psql -U postgres -d database1> -c "COPY <tablename> TO STDOUT;" | <psql -U postgres -d database2> -e -c "COPY <tablename> FROM STDIN;" when both databases reside on the same localhost machine. These commands work beautifully when the databases reside on different remote machines.

I could find nothing in documentation or forums that would indicate that this is an issue. The only difference in execution is location of the databases -- nothing else.

Is there something I'm missing regarding local execution?
Feb 8 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
I seem to be having issues with the <psql -U postgres -d database1> -c "COPY <tablename> TO STDOUT;" | <psql -U postgres -d database2> -e -c "COPY <tablename> FROM STDIN;" when both databases reside on the same localhost machine. These commands work beautifully when the databases reside on different remote machines.

I could find nothing in documentation or forums that would indicate that this is an issue. The only difference in execution is location of the databases -- nothing else.

Is there something I'm missing regarding local execution?
what is the error message?
Feb 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.