PostgreSQL #5 - Roles & Schemas
PostgreSQL #5 - Roles&Schemas In the last post I described the physical layer(files on disk) of PostgreSQL db. From now on everything that we will talk about can be explained because you already now the physical and logical structure of PostgreSQL. In this post I'm gonna focus on roles and schemas. The topics that I am going to focus on this post are: -What are roles and schemas? -How can I create each one of them ? -How can I manage them ? -What is search path and how we configure it ? - Priviledges -Important schemas Roles The official and most clear defenition of a role is that a role is an entity that can own database objects and has database priviledges (- PostgreSQL 9.6 documentation ). A role can be a specific user or a group or even sometimes it can both, depends on how you use it. Roles are defined on the cluster level and therefore they are available in all the databases in our cluster. You can get a list of all the roles in ...