PostgreSQL stores all the history SQL commands that were executed in the .psql_history file within your home directory

To view it execute the command below

cat ~/.psql_history