| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Darren Ferguson <darren(at)crystalballinc(dot)com> |
| Cc: | Dean Grubb <dean(at)atrium-online(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Access Two Databases |
| Date: | 2002-07-23 03:59:24 |
| Message-ID: | 3D3CD49C.1040401@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Darren Ferguson wrote:
> Not that i am aware of
>
> On Tue, 23 Jul 2002, Dean Grubb wrote:
>>Hi,
>>
>>Is it possible using pl/pgSQL functions to grab data from another database
>>or even another database on a different host.
You can with contrib/dblink.
In 7.2, it is a bit (well, maybe more than a bit) awkward, but it works.
I hope to have some substantial improvements in usability for the
upcoming 7.3 release making use of the new table functions feature.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-07-23 04:21:29 | Re: Cross-Tab queries in postgres? |
| Previous Message | Jim Morcombe | 2002-07-23 03:56:09 | Re: Can't link to libpq |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB SD | 2002-07-23 07:39:21 | Re: CREATE CAST code review |
| Previous Message | Josh Jore | 2002-07-23 03:31:14 | Re: Access Two Databases |