I can connect to a remote Postgres database like this: #psql -h 123.456.789.123 -U username -d database . So now I want to update a table on that remote DB from a Postgres DB on the server I am on. Is that even possable?
Yes it is possible: dblink