On Wed, 2005-05-11 at 15:41 -0400, Rod Taylor wrote: > > There are some nontrivial issues to be thought about here, like under > > what conditions "CREATE SCHEMA foo" ought to create a top-level schema > > versus creating a schema under some other schema that we are pretending > > is the active "catalog". But it seems on first glance like something > > could be worked out. > > Just go the extra info and call the top level catalogs in the commands
Extra inch, not info. > as well: > > CREATE DATABASE mydb; > \c mydb > > CREATE CATALOG foo; > CREATE SCHEMA foo.bar > CREATE TABLE foo.bar.baz (bif serial); -- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly