title: Get days of week in Postgresql
body: <p>Had been trying to figure out a select query to display days of week such as Monday, Tuesday, Wednesday, etc. I ended up with a select query displaying dates of a week,</p>
  
  <pre><code>select ((date_trunc('week',current_date)::date) + (i+6)) as week_date 
    from generate_Series(0,6) i;
  </code></pre>
  
  <p>Is there a way to get the result as Monday, Tuesday and so on.</p>