Re: Isolation of multiple databse instances provided by a single postgres server

On 11/21/19 8:42 AM, stan wrote:
> On Thu, Nov 21, 2019 at 08:18:21AM -0600, Ron wrote:
[snip]
>> Yes, but ... schema in Postgres are /different/ from Oracle schema.?? In
>> Postgres, the CREATE SCHEMA command creates a schema, whereas CREATE USER
>> creates a schema in Oracle.
> I am still struggling with the schema - role - user relationship in Postgres.
> It appears to me there is one more layer than is needed/useful.

For one thing, there are no users in Postgres anymore.

https://www.postgresql.org/docs/9.6/sql-createuser.html

CREATE USERis now an alias forCREATE ROLE
<https://www.postgresql.org/docs/9.6/sql-createrole.html>. The only
difference is that when the command is spelledCREATE USER,LOGINis assumed by
default, whereasNOLOGINis assumed when the command is spelledCREATE ROLE.

--
Angular momentum makes the world go 'round.