On Fri, Jul 14, 2017 at 9:01 AM, Jerry Sievers <gsiever...@comcast.net> wrote:
> marcelo <marcelo.nico...@gmail.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.