postgresql
1#change to user postgres
2sudo -i -u postgres
3
4#get into sql-mode
5psql
6
7#create new role
8createuser --interactive
9
10#list dbs
11\l
12
13#select db
14\c database-name
15
16#list tables
17\dt
18
19#exit postgres
20\q
https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-16-04