query

[Federico Balbi <fbalbi@xxxxxxxxxxx>]

Hi,
  I was just wondering if postgresql supports queries between servers in
order to pull info from different machines.
Let's say server A can run a query against server B... something like:

server1 running a SELECT * FROM server2.table

or joins

SELECT A.name, B.name FROM server1.table A, server2.table B WHERE A.id=B.id

This is very common on MS SQL server for example.

Thanks,
Federico


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq