Re: managing multiple db developers

"S. Bob" <sbob@xxxxxxxxxxxxxxxxxxxxx> · Tue, 15 Jan 2019 14:52:08 -0700



    On 1/15/19 1:31 PM, Mark Phillips
      wrote:

    
      On Jan 15, 2019, at 10:14 AM, S. Bob <sbob@xxxxxxxxxxxxxxxxxxxxx> 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