(Sorry for asking so many questions, but I can't find answers in the
documentation.)
Why would one bother to create a schema (with "create schema blah
blah")? Isn't a database enough to keep tables, etc. separate? I can
see that schemas *may* be useful for complicated designs having a few
hundred tables (i.e. one in which name collisions could become a
common problem), but I can't think of any other situation.
Thanks!
kj