{"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":"732a0e24fe02809341eeefabd930aaae0019e53cfc1a83b5b2ebade0ea24ef25","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":"english-manuals:ea84334cdf945db8d26f95fecdf2162532d366b9aeee4e890de2b817aab0b9d6","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":""}},"Definition":{"Collection":"catalog","Key":"pg_timezone_names","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_timezone_names","SourceRevision":"english-manuals:ea84334cdf945db8d26f95fecdf2162532d366b9aeee4e890de2b817aab0b9d6","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},{"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},{"array_dimensions":0,"attnum":3,"description":"Offset from UTC (positive means east of Greenwich)","description_zh":"","documented":true,"documented_name":"utc_offset","hidden":false,"name":"utc_offset","not_null":false,"references":"","type":"interval","type_modifier":-1,"type_oid":1186},{"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}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.38.4","file":"view-pg-timezone-names.html","lang":"en","sha256":"6c1a3157eb092f44662f1eed387ca75972be544c9661fa6b1e75c69cf40c96bc","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_timezone_names","Summary":"视图pg_timezone_names提供了一个由SET TIMEZONE识别的时区名称列表，以及它们的相关缩写、UTC偏移和夏令时状态。（从技术上讲，PostgreSQL不使用UTC，因为不处理闰秒。）与在pg_timezone_abbrevs中显示的缩写不同，这些名称中的许多隐含一组夏令时转换日期规则。因此，相关信息在跨越本地夏令时切换边界时发生变化。显示的信息是基于CURRENT_TIMESTAMP的当前值计算的。","BodyHTML":"\u003cp\u003e视图pg_timezone_names提供了一个由SET TIMEZONE识别的时区名称列表，以及它们的相关缩写、UTC偏移和夏令时状态。（从技术上讲，PostgreSQL不使用UTC，因为不处理闰秒。）与在pg_timezone_abbrevs中显示的缩写不同，这些名称中的许多隐含一组夏令时转换日期规则。因此，相关信息在跨越本地夏令时切换边界时发生变化。显示的信息是基于CURRENT_TIMESTAMP的当前值计算的。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"d44d502b0cccee0ef93fe669d78e32466deb46f55e887ba90472b219c21f4a6e","Payload":{"columns":[{"description_zh":"时区名","name":"name","type":"text","zh_from":"doc"},{"description_zh":"时区缩写","name":"abbrev","type":"text","zh_from":"doc"},{"description_zh":"相对于UTC的偏移（正值表示格林威治以东）","name":"utc_offset","type":"interval","zh_from":"doc"},{"description_zh":"如果当前采用夏令时，则为真","name":"is_dst","type":"boolean","zh_from":"doc"}],"description_zh":"视图pg_timezone_names提供了一个由SET TIMEZONE识别的时区名称列表，以及它们的相关缩写、UTC偏移和夏令时状态。（从技术上讲，PostgreSQL不使用UTC，因为不处理闰秒。）与在pg_timezone_abbrevs中显示的缩写不同，这些名称中的许多隐含一组夏令时转换日期规则。因此，相关信息在跨越本地夏令时切换边界时发生变化。显示的信息是基于CURRENT_TIMESTAMP的当前值计算的。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}