Query with Querying Database

[rachelle]

I am using PostgreSQL for the past few months. Now I am faced with a problem.I want to query a database other than the current one.Is it possible to query multiple databases using POSTGRE. How can I do that.

[ashlee]

It is not possible for you to query multiple databases at the same time using POSTGRE. The reason being PostgreSQL does the loading of database by using database-specific system catalogs. If you still want to use multiple databases results I would suggest you to handle on the user interface side by making separate connections to each of these and then combining the results in the user interface side. But this approach would reduce your performance. So use this only if you need it very essential.