Re: [GENERAL] What is exactly a schema?

marcelo wrote:
> The question is not trivial. Could I maintain two or three separate/distinct "versions" of same
> database using one schema for every of them?
> Could some tables (in the public schema) be shared among all the schemas?
>
>

Yes and yes. In the Postgresql world, the word "schema" is maybe unfortunately overloaded, but
whenever you read it think "namespace". In fact, in the systems catalog there are columns named
"namespace" that store data referring to named schemas.

-- B