Re: What is exactly a schema?

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 14/07/17 09:19, Bill Moran wrote:
> On Fri, 14 Jul 2017 08:59:13 -0300
> marcelo <marcelo(dot)nicolet(at)gmail(dot)com> 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 dotConnect and Entity
>> developer to access the database. I have not full control, so I cannot
>> set the search path immediately after the connection.
>>
>> If the first example is possible, I will replace the schema name on the
>> fly, before connection attempt.
> I don't think you can do exactly what you're asking. However, you should
> be able to achieve the same result by setting a default schema for the
> user that you're connecting as. See the docs for ALTER ROLE and SET.
>