Postgres Pro
Downloads
Home   >   mailing lists

select result / functions from another database in plpgsql - Mailing list pgsql-general

From Matthew Peter
Subject select result / functions from another database in plpgsql
Date
Msg-id 20061106082549.98686.qmail@web35213.mail.mud.yahoo.com
Whole thread Raw
Responses Re: select result / functions from another database in  (Richard Huxton <dev@archonet.com>)
Re: select result / functions from another database in plpgsql  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: nando@freemail.gr (Tsakiridis Orestis)
Date:
Subject: No subject
Next
From: Richard Huxton
Date:
Subject: Re: select result / functions from another database in