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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
