PostgreSQL Concepts: Difference between revisions
Jump to navigation
Jump to search
(→User) |
|||
| Line 19: | Line 19: | ||
Users are shared across [[#Database|databases]]. | Users are shared across [[#Database|databases]]. | ||
The "user" concept is equivalent with the "[[#Role|role]]" concept. | The "user" concept is equivalent with the "[[#Role|role]]" concept. They mean the same thing. | ||
{{Internal|Postgresql_DDL_Operations#Users|User Operations}} | {{Internal|Postgresql_DDL_Operations#Users|User Operations}} | ||
Revision as of 19:54, 18 October 2018
Internal
Database
A PostgresSQL usually comes with 4 pre-existing databases (admin, postgres, template0, template1). "postgres" is fit for general use and it should be used by default.
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. They mean the same thing.
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