Re: What is exactly a schema?

marcelo <marcelo(dot)nicolet(at)gmail(dot)com> writes:

> 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.

Take a look at the PGOPTIONS env variable an/or libpq connect parameter variant.

>
> 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
>>
>>
>>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800