pgsql usage record

Format long type time field

-- long type time field formatted
SELECT
    to_timestamp(create_time/1000) AT TIME ZONE 'Asia/Shanghai' AS create_time_local,
    *
FROM Ftable_name;