title: How do I get the current timezone name in Postgres 9.3?
body: <p>I want to get the current timezone name. 
  What I already achieved is to get the <code>utc_offset</code> / the timezone abbreviation via:</p>
  
  <pre><code>SELECT * FROM pg_timezone_names WHERE abbrev = current_setting('TIMEZONE')
  </code></pre>
  
  <p>This gives me all Continent / Capital combinations for this timezone but not the exact <code>timezone</code>. For example I get:</p>
  
  <pre><code>Europe/Amsterdam
  Europe/Berlin
  </code></pre>
  
  <p>The server is in <code>Berlin</code> and I want to get the timezone name of the server. </p>
  
  <p>The problem I have with <code>CET</code> that it is always <code>UTC+01:00</code> and does not account for <code>DST iirc</code>.</p>