Re: What is exactly a schema?

From: Berend Tober <btober(at)computer(dot)org>
To: marcelo <marcelo(dot)nicolet(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: What is exactly a schema?
Date: 2017-07-14 10:58:20
Message-ID: 38f5d2b3-22b2-3389-ceea-38bb471a568f@computer.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message marcelo 2017-07-14 11:59:13 Re: What is exactly a schema?
Previous Message Michael Paquier 2017-07-14 10:03:50 Re: What is exactly a schema?