Schema support

The bits I was allowed to see from the ANS SQL standard ISO/IEC 9075, was the results from a search query for "SQL table name" and I quote.

ISO/IEC 9075 specifies that an object such as an SQL-invoked routine, a user-defined type, a domain, a table, a view, or a privilege shall be part of exactly one schema.

At #36 @robinson-rso raised an interesting question, can we handle schemas. Which is at first I thought nothing strange of surely PDO will take care of that, but does it?
PostgreSQL's use of schemas is not all that different to using multiple MySQL databases simultaneously where you would prefix the table name with the database name.

The following tasks items should be actioned.

• Can we use multiple databases out of the box- create tests to prov it

if not

• Can we deal with PostgreSQL schema in connection string? this won't solve multiple databases/schemas but at least it's not completely defunct.
• Investigate how others have approached the problem
• Discuss and design the ideal solution which will allow multiple databases/schemas

@Respect and the friends of Respect what are your thoughts on this?
Please help with suggestions, research and test results.

Start by creating tests for whether multiple databases can be used out of the box, as requested in the issue. If that is unsupported, investigate PostgreSQL schemas in the connection string and how other projects handle multiple databases or schemas; done requires an agreed design and test-backed support.