From: | marcelo <marcelo(dot)nicolet(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: What is exactly a schema? |
Date: | 2017-07-14 17:41:33 |
Message-ID: | 8d8c8cf7-dbfc-a79c-ef14-41da08012191@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2017-07-14 19:11:19 | Re: Monitoring of a hot standby with a largely idle master |
Previous Message | John R Pierce | 2017-07-14 16:50:12 | Re: What is exactly a schema? |