Postgres, plpgsql: Is there a way to connect to another database from within a stored procedure?

Question

I have two DBs, one of which is sent by filtering data from the other, now I use a perl script witch to query a foreign database, save the result in a csv file and load it into a local database using \ COPY sytnatx

Is there a way to write a plpgsql function that will connect to someone else's database and load the filtered data into a local database (I know this can be done in ie plperl, but I'm looking for a more “native” way)

Answer 1

And there is DBI-LINK which supports much more databases :)

Answer 2

PostgreSQL dblink, PostgreSQL, - , .

Answer 3

PL/Proxy, - ( , , ) , PL/Proxy . Skype .