Re: [GENERAL] What is exactly a schema? - Mailing list pgsql-general

From Berend Tober
Subject Re: [GENERAL] What is exactly a schema?
Date
Msg-id 38f5d2b3-22b2-3389-ceea-38bb471a568f@computer.org
Whole thread Raw
In response to [GENERAL] What is exactly a schema?  (marcelo <marcelo.nicolet@gmail.com>)
Responses Re: [GENERAL] What is exactly a schema?
List pgsql-general
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




pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [GENERAL] What is exactly a schema?
Next
From: marcelo
Date:
Subject: Re: [GENERAL] What is exactly a schema?