PostgreSQL Concepts

From NovaOrdis Knowledge Base
Revision as of 19:12, 18 October 2018 by Ovidiu (talk | contribs) (→‎Schema)
Jump to navigation Jump to search

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.

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