Re: Using tables in other PostGreSQL database

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Using tables in other PostGreSQL database
Дата
Msg-id 47EB6C89.5050401@archonet.com
обсуждение исходный текст
Ответ на Using tables in other PostGreSQL database  ("Pettis, Barry" <Barry.Pettis@atmel.com>)
Ответы Re: Using tables in other PostGreSQL database
Список pgsql-general
Pettis, Barry wrote:
> Now this PostGreSQL "server" has many databases in it.  Some of which I
> have access to.  I don't want to reinvent the wheel ( so to speak ) by
> having to replicate the table in my database.  Then having to create
> routines that will extract from A to replicate in B.  How do I reference
> a table in another database?

There is an add-on in contrib/ called "dblink" that lets you connect to
a remote database. There's also a dbilink project that uses Perl.

> Also to respond in the thread... Do I just reply to the message?

Reply-All is the default on the pg lists.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: "Alain Roger"
Дата:
Сообщение: returned value from SQL statement
Следующее
От: Harald Fuchs
Дата:
Сообщение: Re: Survey: renaming/removing script binaries (createdb, createuser...)