| From: | Bricklen Anderson <BAnderson(at)PresiNET(dot)com> |
|---|---|
| To: | "Karl O(dot) Pinc" <kop(at)meme(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Questions about functionality |
| Date: | 2005-02-04 17:55:00 |
| Message-ID: | 4203B6F4.6070906@PresiNET.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Karl O. Pinc 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.
>
>
> Karl <kop(at)meme(dot)com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
Look in /contrib directory for dblink. That will enable you to query other pg databases.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rick Apichairuk | 2005-02-04 17:55:39 | Re: [ADMIN] vacuum ran out of space and now i cant get back into db |
| Previous Message | Juan Casero (FL FLC) | 2005-02-04 17:40:50 | plpgsql function errors |