| PostgreSQL 9.2.4 Documentation | ||||
|---|---|---|---|---|
| Prev | Up | Chapter 45. System Catalogs | Next | |
The view pg_timezone_names
provides a list of time zone names that are recognized by
SET TIMEZONE, along with their
associated abbreviations, UTC offsets, and daylight-savings
status. (Technically, PostgreSQL
uses UT1 rather than UTC
because leap seconds are not handled.) Unlike the abbreviations
shown in pg_timezone_abbrevs, many of these names
imply a set of daylight-savings transition date rules. Therefore,
the associated information changes across local DST boundaries.
The displayed information is computed based on the current value
of CURRENT_TIMESTAMP.
Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.
Proceed to the comment form.