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

History

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

Timing

On Linux, we have the command time. Prefix