Francisco Reyes <lists(at)natserv(dot)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