Here lies docker commands for postgresql

docker

docker pull postgres

// run postgres container
docker run --name mypg -e POSTGRES_PASSWORD=mysecretpassword -d -p 5432:5432 postgres

// root access to potgres
psql -U postgres

// see roles
\du

// see databases
\l

// create new database in docker
create database DBNAME;

// connect to db
\c DBNAME

// connect to postgres container from local machine
psql -h localhost -p 5432 -U postgres