select result / functions from another database in plpgsql

From: Matthew Peter <survivedsushi(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: select result / functions from another database in plpgsql
Date: 2006-11-06 08:25:49
Message-ID: 20061106082549.98686.qmail@web35213.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!


---------------------------------
Sponsored Link

Free Uniden 5.8GHz Phone System with Packet8 Internet Phone Service

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-11-06 08:30:48 Re: select result / functions from another database in
Previous Message Tsakiridis Orestis 2006-11-06 07:53:45 No subject