SQLzoo.net

Read tables from another schema/database

Postgres
A particular server may support a number of different sets of tables. In Oracle these are schemas in MySQL they are databases. In both cases each user normally has their own set of tables, other users tables may be accessed using a dot notation.


Specific to Postgres
The current implementation of postgres does not allow this. However support will be included in release 7.3 as a new feature.
Thanks to Derek Barrett for this advice.

Related links:

  • USERS