Re: select result / functions from another database in plpgsql

Поиск
Список
Период
Сортировка
От Matthew Peter
Тема Re: select result / functions from another database in plpgsql
Дата
Msg-id 20061106201653.99644.qmail@web35203.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: select result / functions from another database in  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
--- Richard Huxton <dev@archonet.com> wrote:

> Matthew Peter wrote:
> > I have DB1 and DB2 pg_databases... I then have a function in DB2 that
> > wants some results from DB1, is it possible to query another db? Like
> > how \! lets you hit the command line... but I need it in plpgsql if
> > possible.
>
> Look into the db_link or dbi_link packages. These are exactly what you
> are after.
>
> --
>    Richard Huxton
>    Archonet Ltd
>


Perfect. Leave it to me not to check the contrib package first :) Thanks again




____________________________________________________________________________________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Marc Munro
Дата:
Сообщение: Re: [pgsql-general] Daily digest v1.6578 (20 messages)
Следующее
От: AgentM
Дата:
Сообщение: Re: PostgreSQL in an embedded platform