marcelo <marcelo.nicolet@xxxxxxxxx> 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.
