Re: What are schemas? - Mailing list pgsql-novice

From Tom Lane
Subject Re: What are schemas?
Date
Msg-id 4669.1020225656@sss.pgh.pa.us
Whole thread Raw
In response to What are schemas?  (Francisco Reyes <lists@natserv.com>)
Responses Re: What are schemas?  (Francisco Reyes <lists@natserv.com>)
List pgsql-novice
Francisco Reyes <lists@natserv.com> writes:
> What are schemas?
> I have a general/vague idea, but would like to better understand it.

To my mind, schemas are the SQL-spec equivalent of subdirectories,
folders, or namespaces: you can name stuff in a schema without concern
for name conflicts against what the guy in the next cubicle is naming
the stuff in his schema.

SQL is a little weird in that there's only one level of schema naming;
you can't have schemas-in-schemas, whereas practically every other
folder/directory/whatever design allows hierarchical naming.  But it's
the same kind of idea.

            regards, tom lane

pgsql-novice by date:

Previous
From: Francisco Reyes
Date:
Subject: What are schemas?
Next
From: Denny Permana
Date:
Subject: Once again about 'OID'