Joachim Wieland <joe@mcknight.de> writes:
> Getting a list of active timezones could be easily done
> with a system view but you might not want to promise its existence when you
> think about moving the whole thing to a system catalog later...
A read-only view wouldn't be a bad idea, actually, for both the
long-form TZ names and the abbreviations. It'd be easy to cons one
up the same way as our other views based on functions. Doesn't even
need to be in core, could be contrib, if there's doubts about its
usefulness.
regards, tom lane