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.)
