Re: managing multiple db developers

On 1/15/19 1:31 PM, Mark Phillips wrote:
> On Jan 15, 2019, at 10:14 AM, S. Bob <sbob(at)quadratum-braccas(dot)com
> <mailto:sbob(at)quadratum-braccas(dot)com>> wrote:
>>
>> PostgreSQL supports schema's as well, a schema in PostgreSQL is a
>> simple namespace, which is a different concept from Oracle but you
>> can accomplish the same thing with a schema, in particular via the
>> "CREATE SCHEMA AUTHORIZATION" approach
>
> Thank you for the suggestion.
>
> My only concern about using pg schemas is the level of separation.
> Also, I have toyed with create schema but, to my ignorant mind, I
> don’t see the tables and such in the “dev schema”.
>
>  - Mark

You'll need to augment setting the schema with setting the search_path,
you can also set a default search_path for a user