Re: What is exactly a schema?

On Fri, Jul 14, 2017 at 9:01 AM, Jerry Sievers <gsievers19(at)comcast(dot)net>
wrote:

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

Yes, it can be done, but doing so precludes the use connection pooling
technology (at least pg_bouncer, anyway, I suspect others).

David J.