1

postgresql documentation says:

All timezone-aware dates and times are stored internally in UTC. They are converted to local time in the zone specified by the timezone configuration parameter before being displayed to the client.

timezone parameter is a session parameter. When all TIMESTAMP WITH TIME ZONEs will be stored as UTC and the client connection will specify the session timezone, then what is the benefit of setting TimeZone parameter in postgresql.conf?

Improve this question

1 Answer 1

Reset to default
3

Like with any other parameter that can be defined for every session, the setting in postgresql.conf is the default in the absence of an explicit setting for the session.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.