PostgreSQL Concepts: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 20: Line 20:


The "role" concept is equivalent with the "[[#User|user]]" concept.
The "role" concept is equivalent with the "[[#User|user]]" concept.
===Role Attributes===
A specific role may:
* be a superuser
* create another role
* create a database


=Data Types=
=Data Types=


==Timestamp==
==Timestamp==

Revision as of 19:11, 18 October 2018

Internal

Database

Schema

Authentication

User

Users are shared across databases.

The "user" concept is equivalent with the "role" concept.

User Operations

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

Data Types

Timestamp