---
title: "pg_timezone_abbrevs"
id: view-pg-timezone-abbrevs
pg_version: "20devel"
---

<a id="view-pg-timezone-abbrevs"></a>

## 53.35. pg_timezone_abbrevs

The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents of this view change when the [`TimeZone` (`string`)](runtime-config-client.md#guc-timezone) or [`timezone_abbreviations` (`string`)](runtime-config-client.md#guc-timezone-abbreviations) run-time parameters are modified. 

**pg_timezone_abbrevs Columns**

| Column Type | Description | 
| --- | --- |
| `abbrev` `text` | Time zone abbreviation |
| `utc_offset` `interval` | Offset from UTC (positive means east of Greenwich) |
| `is_dst` `bool` | True if this is a daylight-savings abbreviation |

While most timezone abbreviations represent fixed offsets from UTC, there are some that have historically varied in value (see [Section B.4](datetime-config-files.md) for more information). In such cases this view presents their current meaning.