If you’ve found this, your searching on how to show the time zone in PostgreSQL. So I won’t rant on about what the time zone is used for in PostgreSQL and get straight to the code. to change the time zone in PostgreSQL, run the following SQL command in PGAdmin, against the database you want to change: