{"Entry":{"collection":"catalog","key":"pg_timezone_names","name":"pg_timezone_names","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.1","order":false,"removed":[],"status":"added","to":"8.2","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.0","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.1","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.5","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.6","types":[],"unlisted":[]}],"column_count":4,"content_hash":"d9fbedcd7e3ef5478b37727d3323bfaa752c4071b5bf6b2a6a9c2e35f8976c3a","derived_content_hash":"6906f8eeed96f7b8fc0e60e8d2aebb0ba1e833add6cded3c5b7452898518945c","first_version":"8.2","imported_at":"2026-09-30T00:40:56.271225+08:00","kind":"view","last_version":"20","name":"pg_timezone_names","position":141,"present_in":["8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:62228adef885325e2a326170e820181c907827101eadd18d3982d2e9945db229","summary":"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.","summary_zh":"视图 pg_timezone_names 提供了一个由 SET TIMEZONE 识别的时区名称列表，以及它们的相关缩写、UTC 偏移和夏令时状态。（从技术上讲，PostgreSQL 不使用 UTC，因为不处理闰秒。）与在 pg_timezone_abbrevs 中显示的缩写不同，这些名称中的许多隐含一组夏令时转换日期规则。因此，相关信息在跨越本地夏令时切换边界时发生变化。显示的信息是基于 CURRENT_TIMESTAMP 的当前值计算的。"}},"Definition":{"Collection":"catalog","Key":"pg_timezone_names","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_timezone_names","SourceRevision":"catalog-bilingual-repair:62228adef885325e2a326170e820181c907827101eadd18d3982d2e9945db229","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Time zone name","description_zh":"时区名","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Time zone abbreviation","description_zh":"时区缩写","documented":true,"documented_name":"abbrev","hidden":false,"name":"abbrev","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Offset from UTC (positive means east of Greenwich)","description_zh":"相对于 UTC 的偏移（正值表示格林威治以东）","documented":true,"documented_name":"utc_offset","hidden":false,"name":"utc_offset","not_null":false,"references":"","type":"interval","type_modifier":-1,"type_oid":1186,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"True if currently observing daylight savings","description_zh":"如果当前采用夏令时，则为真","documented":true,"documented_name":"is_dst","hidden":false,"name":"is_dst","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"}],"description":"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 does not use 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.","description_zh":"视图 pg_timezone_names 提供了一个由 SET TIMEZONE 识别的时区名称列表，以及它们的相关缩写、UTC 偏移和夏令时状态。（从技术上讲，PostgreSQL 不使用 UTC，因为不处理闰秒。）与在 pg_timezone_abbrevs 中显示的缩写不同，这些名称中的许多隐含一组夏令时转换日期规则。因此，相关信息在跨越本地夏令时切换边界时发生变化。显示的信息是基于 CURRENT_TIMESTAMP 的当前值计算的。","description_zh_html":"\u003cp\u003e视图 pg_timezone_names 提供了一个由 SET TIMEZONE 识别的时区名称列表，以及它们的相关缩写、UTC 偏移和夏令时状态。（从技术上讲，PostgreSQL 不使用 UTC，因为不处理闰秒。）与在 pg_timezone_abbrevs 中显示的缩写不同，这些名称中的许多隐含一组夏令时转换日期规则。因此，相关信息在跨越本地夏令时切换边界时发生变化。显示的信息是基于 CURRENT_TIMESTAMP 的当前值计算的。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.38.4","file":"view-pg-timezone-names.html","lang":"en","sha256":"6c1a3157eb092f44662f1eed387ca75972be544c9661fa6b1e75c69cf40c96bc","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","abbrev","utc_offset","is_dst"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-timezone-names.html","sha256":"c0d475bbdedaa699cc8e48b055392a415ca37e3bdf6c7cfb67499746d4872716","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:ea84334cdf945db8d26f95fecdf2162532d366b9aeee4e890de2b817aab0b9d6","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.38.4","file":"view-pg-timezone-names.html","lang":"en","sha256":"6c1a3157eb092f44662f1eed387ca75972be544c9661fa6b1e75c69cf40c96bc","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-timezone-names.html","sha256":"c0d475bbdedaa699cc8e48b055392a415ca37e3bdf6c7cfb67499746d4872716","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:ea84334cdf945db8d26f95fecdf2162532d366b9aeee4e890de2b817aab0b9d6","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","abbrev","utc_offset","is_dst"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_timezone_names","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_timezone_names","Summary":"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 does not use 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.","BodyHTML":"\u003cp\u003eThe 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 does not use 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:62228adef885325e2a326170e820181c907827101eadd18d3982d2e9945db229","ContentHash":"9a38e9ae195e56852030cef87b74261d321f307aa313362b017fa91d463f7733","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Time zone name","description_zh":"时区名","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Time zone abbreviation","description_zh":"时区缩写","documented":true,"documented_name":"abbrev","hidden":false,"name":"abbrev","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Offset from UTC (positive means east of Greenwich)","description_zh":"相对于 UTC 的偏移（正值表示格林威治以东）","documented":true,"documented_name":"utc_offset","hidden":false,"name":"utc_offset","not_null":false,"references":"","type":"interval","type_modifier":-1,"type_oid":1186,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"True if currently observing daylight savings","description_zh":"如果当前采用夏令时，则为真","documented":true,"documented_name":"is_dst","hidden":false,"name":"is_dst","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"}],"description":"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 does not use 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."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}