Postgres

Question 1

access postgres

Answer 1

sudo su postgres -c psql

Question 2

delete role

Answer 2

drop role user;

Question 3

login

Answer 3

psql -d table -U user

Question 4

create superuser with login privelages role basic

Answer 4

CREATE ROLE SUPERUSER LOGIN;

Question 5

set password for role

Answer 5

alter role jwhorto1 with encrypted password ‘x’;

Question 6

give existing role createdb ability

Answer 6

alter role jwhorto1 with createdb;

Question 7

list all roles and role attributes and groups theyre part of

Answer 7

\du

Question 8

list all dbs

Answer 8

\list

Question 9

list all tables in current db

Answer 9

\dt