Databases

Postgres

sudo apt install postgresql
sudo service postgresql status
sudo passwd postgres
sudo -u postgres psql

create database dbname;
create user username with encrypted password 'password';
grant all privileges on database dbname to username;

Useful commands

ALTER TABLE table ADD column dataType NOT NULL;

\l list databases
\c select database
\dt list tables