title: How do I extract the name from pg_timezone_names()?
body: <p>In postgres I am trying to extract the name from <code>pg_timezone_names()</code> (<a href="https://www.postgresql.org/docs/8.2/static/view-pg-timezone-names.html" rel="nofollow noreferrer">https://www.postgresql.org/docs/8.2/static/view-pg-timezone-names.html</a>). Right now, it is returning all the records in 1 column.</p>
  
  <p>The version of Postgres is 8.0.2, and the below image is what <code>select pg_timezone_names()</code> returns:</p>
  
  <p><a href="https://i.stack.imgur.com/gAibN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gAibN.png" alt="enter image description here"></a></p>