Querying multiple PostgreSQL databases.

Hello everyone,

PostgreSQL newbie here, so the following may be a dumb question. Is there a way I can create a view (or something similar) which gets data from multiple databases (all found on distinct machines) and can be queried like a single database? The databases all have exactly the same structure - they are from multiple installations of the same application. Outside applications should not be aware it works this way - they should view it as a single, big database.

Check out the dblink module

http://www.postgresql.org/docs/current/static/dblink.html