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.
