| From: | Matthew Peter <survivedsushi(at)yahoo(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: select result / functions from another database in plpgsql |
| Date: | 2006-11-06 20:16:53 |
| Message-ID: | 20061106201653.99644.qmail@web35203.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--- Richard Huxton <dev(at)archonet(dot)com> wrote:
> Matthew Peter 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.
>
> Look into the db_link or dbi_link packages. These are exactly what you
> are after.
>
> --
> Richard Huxton
> Archonet Ltd
>
Perfect. Leave it to me not to check the contrib package first :) Thanks again
____________________________________________________________________________________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | AgentM | 2006-11-06 20:28:42 | Re: PostgreSQL in an embedded platform |
| Previous Message | Marc Munro | 2006-11-06 20:00:21 | Re: [pgsql-general] Daily digest v1.6578 (20 messages) |