Guest User

Untitled

a guest
May 24th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. 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"
  2. #copy table from db on server 1 to another db on server 2
  3. 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