PostgreSQL

UNDER CONSTRUCTION

Install PostgreSQL (CentOS):

yum install postgresql

Enter PostgreSQL:

psql -U postgres

Exit PostgreSQL:

\q

Show databases:

\l

Create database

CREATE DATABASE db_name;

Delete database:

DROP DATABASE db_name;

Create user:

CREATE USER user_name;

Grant privileges:

GRANT ALL PRIVILEGES ON DATABASE db_name TO user_name;

Create role:

CREATE ROLE role_name;

Delete role:

DROP ROLE role_name;

Grant role:

GRANT role_name TO user_name;

List roles:

\du

Set role's password:

ALTER ROLE role_name WITH PASSWORD '0Yfa1f4';

Remove role's password:

ALTER ROLE role_name WITH PASSWORD NULL;

Edit role:

ALTER ROLE role_name <parameters>;

Parameters:

SUPERUSER

NOSUPERUSER

CREATEDB

NOCREATEDB

CREATEROLE

NOCREATEROLE

CREATEUSER

NOCREATEUSER

INHERIT

NOINHERIT

LOGIN

NOLOGIN

CONNECTION LIMIT connlimit

PASSWORD password

ENCRYPTED

UNENCRYPTED

VALID UNTIL 'timestamp'