• 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.

my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!