Re: Queries from different databases - Mailing list pgsql-general

From Joe Conway
Subject Re: Queries from different databases
Date
Msg-id 3C90DEC5.7060901@joeconway.com
Whole thread Raw
In response to Re: Postgres on Apple hardware?  (Jeff Fitzmyers <flume33@yahoo.com>)
List 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




pgsql-general by date:

Previous
From: "Enrico Mangano"
Date:
Subject: UPDATE and SELECT result difference
Next
From: Jeff Eckermann
Date:
Subject: Re: User permissions