[development] Supporting PostgreSQL schema level

Chris Johnson cxjohnson at gmail.com
Fri Jan 18 12:36:36 UTC 2008


Actually, MySQL is the exception for NOT implementing SQL standards.
All of the big commercial databases and Postgres support database
objects named by a hierarchical triple.

In Postgres, they are:

database.schema.object

In Oracle, they are:

database.owner.object


MySQL only implements the last 2 positions:

[missing.]database.object

In MySQL, a database is analogous to a Postgres schema.


More information about the development mailing list