Write at 0001 Jan 01

I like psql a lot than a GUI, everything is just on your finger tips and every single time when I used it, I build up my memory which definetely help when inspecting/debuging Postgres in production.

Passing credential via env

Typing password everytime is painful. Using environment var is a better way because when pairing with a password manager I can fetch them from my terminal and have psql immediately login

export PG


Want to see what did you run, use \s to see your history. If you want to save it some some file \s filename

Run command from file

\i filename


On Linux, we have the command time. Prefix