Re: Isolation of multiple databse instances provided by a singlepostgres server - Mailing list pgsql-general

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 USER is now an alias for CREATE ROLE. The only difference is that when the command is spelled CREATE USER, LOGIN is assumed by default, whereas NOLOGIN is assumed when the command is spelled CREATE ROLE.