Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- psql -h prdd542b -d catissedb -U sysdba -c "copy qtg.esquoteinstr to stdout" | psql -h devd542a -d catissedb -U sysdba -c "Copy qtg.esquoteinstr_prod from stdin"
- #copy table from db on server 1 to another db on server 2
- psql -h nutanixrestore04 -d catissedb -U sysdba -c "copy (Select opportunity_id,track_ref_code from qtg.esopportunity ) to stdout with csv" | psql -h prdd542a -d catissedb -c "\copy appdba.esopportunity_4pm(opportunity_id,track_ref_code) from stdin csv"
Add Comment
Please, Sign In to add comment