Answers for "postgresql select server timezone"

3

timezone brasil postgresql

## Edit file
/var/lib/postgresql/data/postgresql.conf

# Update
timezone='America/Sao_Paulo'

## If you're in docker container run:
apt update
apt install nano

# Run to edit file
nano /var/lib/postgresql/data/postgresql.conf
Posted by: Guest on August-13-2020
0

current setting postgres timezone

SELECT * FROM pg_timezone_names WHERE name = current_setting('TIMEZONE');
Posted by: Guest on December-13-2021

Code answers related to "Shell/Bash"

Browse Popular Code Answers by Language