Re: Oracle Style packages on postgres - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Oracle Style packages on postgres
Date
Msg-id 1115840779.725.38.camel@home
Whole thread Raw
In response to Re: Oracle Style packages on postgres  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
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);
-- 



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Oracle Style packages on postgres
Next
From: Tom Lane
Date:
Subject: Re: Oracle Style packages on postgres