[development] Supporting PostgreSQL schema level
Jean-Michel Pouré
jm at poure.com
Thu Jan 17 17:33:12 UTC 2008
On jeu, 2008-01-17 at 08:56 -0800, Jason Flatt wrote:
> I don't know if it provides what you are referring to, or if you're
> using the
> same term to describe something different, but in Drupal 6, there is a
> new
> Schema API: http://drupal.org/node/146843
>
It is not the same.
I was refering to PostgreSQL schema :
http://www.postgresql.org/docs/8.2/static/ddl-schemas.html
database contains one or more named schemas, which in turn contain
tables. Schemas also contain other kinds of named objects, including
data types, functions, and operators. The same object name can be used
in different schemas without conflict; for example, both schema1 and
myschema may contain tables named mytable. Unlike databases, schemas are
not rigidly separated: a user may access objects in any of the schemas
in the database he is connected to, if he has privileges to do so.
There are several reasons why one might want to use schemas:
* To allow many users to use one database without interfering with
each other.
* To organize database objects into logical groups to make them
more manageable.
* Third-party applications can be put into separate schemas so
they cannot collide with the names of other objects.
Schemas are analogous to directories at the operating system level,
except that schemas cannot be nested.
More information about the development
mailing list