How to transfer table from one database to another in postgresql

Asked 2 years, 6 months ago

Viewed 702 times

pg_dump -h host_ip -U postgres -d source_db -t aa_nqrgs.act_26022017  | 
    psql -h destination_host_ip -U postgres -d destination_db

I have tried this command to transfer a table from one server to another, but it shows an error like 'invalid command \N'. How can I resolve this?

dezso

23.4k12 gold badges63 silver badges102 bronze badges

asked Mar 8 '17 at 6:37

s.kumar

112 bronze badges

you can use dblink to copy a table from one host to another. – Sayad Xiarkakh Mar 8 '17 at 7:39
5

"invalid command \N" is typically not the original error, but a result of a previous error in the script and the copy command can't continue properly. So you need to find out what went wrong. If you pass -a option to psql it will output all steps, thus giving you a hint on where the processing of the script failed. – a_horse_with_no_name Mar 8 '17 at 8:09
As an alternative, you can also try to use a Foreign Data Wrapper, and CREATE a foreign TABLE – joanolo Mar 11 '17 at 13:57
pg_dump is much faster than insertion into FDW, in my experience. – sudo Mar 14 '17 at 23:53

add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy