I'm sorry. dotConnect for PostgreSql is able to set the schema at
connection time. This may be set as part of the connection string, or as
a dbconnection class' property.
i was in doubt because the version I'm using is somewhat old, but
decompiling it shows the property in place.
So, I will close this thread.
Thanks to all who answered. I acquired some new knowledge.
On 14/07/17 13:50, John R Pierce wrote:
> On 7/14/2017 4:59 AM, marcelo wrote:
>> Now I have a related question.
>> Could I select a specific schema in the connection string? Say, by
>> example database=mydb.schemanumbertwo ?
>
> the default search_path is $user,public
>
> so if you connect with different SQL usernames for your different
> schemas, and have all your common tables in PUBLIC, then it will just
> fall out. you'll need to be careful with permissions, of course.
>
>