Re: What is exactly a schema?

Thank you.
Now I have a related question.
Could I select a specific schema in the connection string? Say, by
example database=mydb.schemanumbertwo ?

I'm asking this because I will be using Devart's dotConnect and Entity
developer to access the database. I have not full control, so I cannot
set the search path immediately after the connection.

If the first example is possible, I will replace the schema name on the
fly, before connection attempt.

TIA

On 14/07/17 07:58, Berend Tober wrote:
> 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
>
>
>