| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | "Karl O(dot) Pinc" <kop(at)meme(dot)com> |
| Cc: | Ignacio Colmenero <ignacio(dot)colmenero(at)micotan(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Questions about functionality |
| Date: | 2005-02-04 18:01:16 |
| Message-ID: | 1107540076.16640.240.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2005-02-04 at 11:59, Karl O. Pinc wrote:
> On 02/04/2005 10:06:49 AM, Ignacio Colmenero wrote:
> > 4. Can I query an object in another database, like in Oracle's
> > dblink?
>
> I'm no expert. I don't believe so. You can query across scheams
> in the same database but not across databases. You could do
> something (anything!) by writing an external function in C or
> whatever, but I couldn't say how much work that would take.
Actually, there's a contrib module that does just that.
contrib/dblink. It's useful for running autonomous transactions also.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-02-04 18:05:41 | Re: Questions about functionality |
| Previous Message | Karl O. Pinc | 2005-02-04 17:59:37 | Re: Questions about functionality |