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!!!
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!!!