On 11/6/06, Matthew Peter <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
