> 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 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 6: Have you searched our list archives? http://archives.postgresql.org