| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | jm(dot)poure(at)freesurf(dot)fr |
| Cc: | Carlo Florendo <fcarlo(at)ntsp(dot)nec(dot)co(dot)jp>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Queries from different databases |
| Date: | 2002-03-14 17:32:53 |
| Message-ID: | 3C90DEC5.7060901@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jean-Michel POURE wrote:
> Le Jeudi 14 Mars 2002 06:18, Carlo Florendo a écrit :
>
>>Does PostgreSQL 7.2 support queries on tables from different databases?
>>If so, I'd like to know the syntax.
>>
>
> I don't think so. The only possibility (?) would be to used an untrusted
> server-side language (such as PLperl if it can be used as untrusted) and
> query other backends. By now, this is merely impossible. If someone knows how
> to do it, I would be interested in knowing.
>
> Cheers,
> Jean-Michel pOURE
>
See dblink in contrib. It is crude, but might work for you depending on
your needs.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joey Mingrone | 2002-03-14 17:38:15 | problem authenticating with encrypted passwords in pg_shadow |
| Previous Message | Enrico Mangano | 2002-03-14 17:20:44 | UPDATE and SELECT result difference |