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