On Mon, Mar 20, 2023 at 9:13 AM DAVID ROTH <adaptron(at)comcast(dot)net> wrote:
> Is there any good reference to explain the best usage of each of these
> structures.
> I am coming from Oracle. What is the best analog to Oracle's "user".
>
A schema is a namespace mechanism for objects. It has no relationship to
roles aside from the possibility, if you so choose, to define a schema to
have the same name as a role, in which case that schema becomes parts of
that role's default search_path.
There is no low-level difference between role and user. A user is a role
with the login privilege.
David J.