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
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,
On Fri, Jul 14, 2017 at 9:13 AM, marcelo wrote:
> I'll be using Devart's dotConnect. I have two alternatives at this moment
>
> a) To set the user name to the required schema. This has the (little)
> drawback that forces user configuration for every schema...
>
​With
On Fri, Jul 14, 2017 at 9:01 AM, Jerry Sievers
wrote:
> marcelo 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'll be using Devart's dotConnect. I have two alternatives at this moment
a) To set the user name to the required schema. This has the (little)
drawback that forces user configuration for every schema...
b) To manually do something like the JDBC driver you mention, but it
triggers some
marcelo 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
marcelo schrieb am 14.07.2017 um 13:59:
> Could I select a specific schema in the connection string? Say, by example
> database=mydb.schemanumbertwo ?
The JDBC driver does indeed support that:
jdbc:postgresql://localhost/somedatabase?currentSchema=some_schema
I think in the backround it
Thank you. I know that. It would be my last resort, because aside, I
need that every app user must login to be able to assign logical
privileges at the app level.
Of course, I will have my own tables of users and roles, independently
of the postgres users an roles.
I will think of it.
On
On Fri, 14 Jul 2017 08:59:13 -0300
marcelo wrote:
> 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
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
marcelo wrote:
The question is not trivial. Could I maintain two or three separate/distinct
"versions" of same
database using one schema for every of them?
Could some tables (in the public schema) be shared among all the schemas?
Yes and yes. In the Postgresql world, the word "schema" is
On Fri, Jul 14, 2017 at 12:00 PM, marcelo wrote:
> The question is not trivial. Could I maintain two or three separate/distinct
> "versions" of same database using one schema for every of them?
> Could some tables (in the public schema) be shared among all the schemas?
12 matches
Mail list logo