On 11/6/06, Matthew Peter <survivedsushi(at)yahoo(dot)com> 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