Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Take backup of a table from remote Database server conditionally in postgres Database

 
Sawan Mishra
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've been using postgres database.But often wondered if there is any way to take a backup of a table having where clause.

Copy command doesn't seem to be elegant solution as we can't give remote server IP in it. And also if we need to execute it then manually we need to add Copy (all field names) STDIN; in the first line of sql file being generated.

Is there anyway to take a dump of a table conditionally even from a remote server.

If i try to access from one database to other Cross database reference not implemented message pops up.


Please someone tell how to take backup of a table having where condition from remote server or from local server in postgres.It should have insert scripts.




 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic