Re: Queries from different databases

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Queries from different databases
Дата
Msg-id 3C90DEC5.7060901@joeconway.com
обсуждение исходный текст
Ответ на Re: Postgres on Apple hardware?  (Jeff Fitzmyers <flume33@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Enrico Mangano"
Дата:
Сообщение: UPDATE and SELECT result difference
Следующее
От: Jeff Eckermann
Дата:
Сообщение: Re: User permissions