postgresql timestamp timezone brasilia code example

Example 1: timezone brasil postgresql

/* Query in your sql */
SHOW config_file;

/* Open config_file, search and update */
timezone='America/Sao_Paulo'

Example 2: postgresql date at timezone

select updatedat AT TIME ZONE 'UTC';