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.