title: Postgresql: date format and local language output
body: <p>I have two problem with postgresql.
  The first one is I have to convert date in specific format like: friday 04 november 2016</p>
  
  <pre><code>SELECT to_char(tstamp, 'Day DD month YYYY') FROM ...
  </code></pre>
  
  <p>that's the result: <a href="https://i.stack.imgur.com/RjNnm.png" rel="noreferrer">https://i.stack.imgur.com/RjNnm.png</a></p>
  
  <p>at first look the tstamp table disappeared and there're more space in the string:</p>
  
  <pre><code>friday....04.November..2016
  </code></pre>
  
  <p>*Hex encoding</p>
  
  <p>the second one is that i have to convert it in a language format, in italian for example: "Venerdì 04 Novembre 2016".</p>
  
  <p>Thank's for help</p>