Postgres Pro
Downloads
Home   >   mailing lists

Thread: Multi server query

Multi server query

From
Florent THOMAS
Date:
Hy all of you,

How do you query multi servers and multi databases on postgresql?

Regards

Re: Multi server query

From
Sergey Konoplev
Date:
Hi,

On Mon, Mar 19, 2012 at 12:12 AM, Florent THOMAS <mailinglist@tdeo.fr> wrote:
> How do you query multi servers and multi databases on postgresql?


Look at this http://wiki.postgresql.org/wiki/PL/Proxy


--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray.ru@gmail.com Skype: gray-hemp

Re: Multi server query

From
John R Pierce
Date:
On 03/18/12 1:12 PM, Florent THOMAS wrote:
> How do you query _multi servers_ and multi databases on postgresql?

other than plproxy, there's dblink, in the contrib collection.   this
lets you query another database or server from within a SQL query





--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

Re: Multi server query

From
Florent THOMAS
Date:
Great thanks to all of you regards

Le 19/03/2012 09:58, Sergey Konoplev a écrit : 
Hi,

On Mon, Mar 19, 2012 at 12:12 AM, Florent THOMAS <mailinglist@tdeo.fr> wrote:

How do you query multi servers and multi databases on postgresql?


Look at this http://wiki.postgresql.org/wiki/PL/Proxy