I've a postgres database on server. There is an upsert function which takes a file as an input. Is there any way to execute the upsert function from my local without having to scp the file to server and upsert it there?

(I'm trying to automate the whole process. It'll be easier if I can upsert it directly from my local instead of doing scp and then ssh etc.)

Thanks in advance.


From what you said, I guess your database doesn't allow external connections so, basicaly, nope, you cannot do anything remotely directly to the database.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.