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.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
