Take backup of a table from remote Database server conditionally in postgres Database
posted 1 year ago
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.