Any table name in a SELECT statement may be qualified by the name of the schema to which the table belongs in the form schema.table.
Unqualified table names are implicitly qualified by the ident name of the current user.
The table name must be written in its qualified form if the name of the schema to which the table belongs differs from the name of the current user.
For example:SELECT * FROM mimer_store.formats;
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40