1.

How Do I Perform Queries Using Multiple Databases?

Answer»

There is no WAY to query a database other than the CURRENT ONE. Because POSTGRESQL loads database-specific system catalogs, it is uncertain how a cross-database query should even behave.
contrib/dblink allows cross-database queries using function calls. Of course, a client can also make simultaneous connections to different DATABASES and merge the results on the client side.

There is no way to query a database other than the current one. Because PostgreSQL loads database-specific system catalogs, it is uncertain how a cross-database query should even behave.
contrib/dblink allows cross-database queries using function calls. Of course, a client can also make simultaneous connections to different databases and merge the results on the client side.


Discussion

No Comment Found

Related InterviewSolutions