On Wed, 2006-03-08 at 14:19, Louis Gonzales wrote:
> >
> Paul,
> When you say "multiple identical schemas" are they all separate
> explicit schemas? Or are they all under a general 'public' schema.
> From my understanding, when you create a new db instance, it's under
> the public level schema by default unless you create an explicit
> schema and subsequently a db instance - or several - therein,
> effectively establishing sibling db instances belonging to a single
> schema, I know at least that data in the form of table access is
> allowed across the siblings. I'd also assume that this would be the
> case for triggers and functions that could be identified or defined at
> the 'root' level
Ummm. In PostgreSQL schemas are contained within databases, not the
other way around. It's cluster contains databases contains schemas
contains objects (tables, sequences, indexes, et. al.)