As we are using triggers in PostgreSQL to fill Created Date or Modified Date with current date time, you need to ensure that you set the correct time zone for your location. By default PostgreSQL gives UTC date time.
I faced a situation where I had to change a column type from Boolean to Integer. And I wanted to rename the column name. For example, we have table that has a boolean column "bDeleted". I have to remane "dDeleted" to "iDeleted" and all boolean values need to convert into 0 and 1. Then you have to run below PostgreSQL queries.