This is another one of those things I've done all this several times before, but need to keep looking up the documentation.
sudo -u postgres psql
from there you can create a user and access it as you normally would.
createuser -P -s -e michael
to connect to a database use
to list the tables run
and to make the output format expanded so it fits on a small screen simply switch
In my case that's usually on Debian or Ubuntu but it should be the same on most Linux distros. ↩