From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/view-pg-timezone-names.html | 38 +++++++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 doc/src/sgml/html/view-pg-timezone-names.html (limited to 'doc/src/sgml/html/view-pg-timezone-names.html') diff --git a/doc/src/sgml/html/view-pg-timezone-names.html b/doc/src/sgml/html/view-pg-timezone-names.html new file mode 100644 index 0000000..bbcb17c --- /dev/null +++ b/doc/src/sgml/html/view-pg-timezone-names.html @@ -0,0 +1,38 @@ + +54.32. pg_timezone_names
54.32. pg_timezone_names
Prev UpChapter 54. System ViewsHome Next

54.32. pg_timezone_names

+ 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. +

Table 54.32. pg_timezone_names Columns

+ Column Type +

+

+ Description +

+ name text +

+

+ Time zone name +

+ abbrev text +

+

+ Time zone abbreviation +

+ utc_offset interval +

+

+ Offset from UTC (positive means east of Greenwich) +

+ is_dst bool +

+

+ True if currently observing daylight savings +


Prev Up Next
54.31. pg_timezone_abbrevs Home 54.33. pg_user
\ No newline at end of file -- cgit v1.2.3