On 11/6/06, Matthew Peter <survivedsushi@xxxxxxxxx> wrote:
I have DB1 and DB2 pg_databases... I then have a function in DB2 that wants some results from DB1, is it possible to query another db? Like how \! lets you hit the command line... but I need it in plpgsql if possible. Also, I know functions are local to db (unless it inserted into template1 prior to createdb) but is there any other way to call functions from another db? Thanks!
check out dblink contrib module for starters. Maybe take a look at pl/sh, which looks pretty neat. merlin
