PostgreSQL Concepts: Difference between revisions
Jump to navigation
Jump to search
(→Schema) |
(→Schema) |
||
| Line 6: | Line 6: | ||
=Schema= | =Schema= | ||
Each database has by default a public schema. | |||
=Tablespace= | =Tablespace= | ||
Revision as of 19:12, 18 October 2018
Internal
Database
Schema
Each database has by default a public schema.
Tablespace
Authentication
User
Users are shared across databases.
The "user" concept is equivalent with the "role" concept.
Role
The "role" concept is equivalent with the "user" concept.
Role Attributes
A specific role may:
- be a superuser
- create another role
- create a database