Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
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

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread John R Pierce
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,

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread David G. Johnston
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

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread David G. Johnston
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 ? > > >

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
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

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread Jerry Sievers
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

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread Thomas Kellerer
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

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
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

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread Bill Moran
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

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
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

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread Berend Tober
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

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread Michael Paquier
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?

[GENERAL] What is exactly a schema?

2017-07-14 Thread marcelo
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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make