Re: What are schemas?

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