| From: | Josh Jore <josh(at)greentechnologist(dot)org> |
|---|---|
| To: | Dean Grubb <dean(at)atrium-online(dot)com(dot)au> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Access Two Databases |
| Date: | 2002-07-23 03:31:14 |
| Message-ID: | Pine.BSO.4.44.0207222229160.23685-100000@kitten.greentechnologist.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Tue, 23 Jul 2002, Dean Grubb wrote:
> Is it possible using pl/pgSQL functions to grab data from another database
> or even another database on a different host.
This is where your external-to-PostgreSQL language comes in handy. Open a
second connection to the database, do whatever you are going to do and
mash the results together outside of PostgreSQL. If for some reason you
think the data is related then perhaps you've erred by having more than
one database.
Joshua b. Jore ; http://www.greentechnologist.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Morcombe | 2002-07-23 03:56:09 | Re: Can't link to libpq |
| Previous Message | Brian Dougherty | 2002-07-23 03:02:00 | Difficulty updating TEXT fields with JDBC. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-07-23 03:59:24 | Re: Access Two Databases |
| Previous Message | Christopher Kings-Lynne | 2002-07-23 02:43:37 | Stats Collector |