Select on multiple servers

[xenology]

I'm guessing I'm not searching on the right keywords but I can't find any information on how to accomplish this. I'd appreciate any point in the right direction or links to any documents.

I have a production POSTGRES database on one server and a development version on another. What/how do I query from both databases in the same query? (i.e. Microsoft SQLServer is "linked servers")

SELECT p.* FROM production.database.table p WHERE p.id NOT IN (SELECT d.id FROM development.database.table d);

Using:
PostgreSQL 8.2.6 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20070925 (Red Hat 4.1.2-33)

Thanks!!!

 

[rski]

Maybe use dblink module