On 1/19/07, Ed Leafe <[EMAIL PROTECTED]> wrote: > On Jan 19, 2007, at 1:47 PM, Carl Karsten wrote: > > >> Nope. The tables in schema A are completely distinct from tables in > >> schema B. No different than if they were tables in two databases. > > > > Then what is the difference between a schema and a database? > > A level; that's about it. In MySQL, a host can contain several > databases, each of which can contain several tables. In PostgreSQL, a > host can contain several databases, each of which can contain several > schemas, each of which can contain several tables.
If it's just namespace, why don't we treat them as separate databases. The namespace issues can be resolved in the backend. > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com > > > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
