In nearly all cases, I recommend people use TIMESTAMPTZ with UTC timezone (i.e. convert on the way in). If possible, operate your apps with UTC until it hits a user's eyes, i.e. internally define your "day" to start in ~Greenwich UK.
This saves a __lot__ of headaches, of which timestamp vs timestamptz is the tip of the iceberg.
asah · · focus · HN ↗
This saves a __lot__ of headaches, of which timestamp vs timestamptz is the tip of the iceberg.