Display `timestamptz` in Different Timezone in PostgreSQL

loading views

There is an easy way to display/convert timestamptz fields to different timezones.

The short version: created_at AT TIME ZONE 'America/Toronto' AS local_time

The full version:

SELECT
    created_at AT TIME ZONE entries.timezone AS local_time
FROM
    entries