title: How to change datestyle in PostgreSQL?
body: <p>In postgres I have a table with date column. Now postgres allows me to write date in Y-m-d format. But I need date in d/m/Y format. How to change it?  </p>
  
  <p>When I do:</p>
  
  <pre><code>   show datestyle;
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code> "ISO, DMY"
  </code></pre>
  
  <p>And input date in table in this format <code>13/02/2009</code> </p>
  
  <p>But when I close and open table again I see this <code>2009-02-13</code>. JDBC gives me date in this format too. What am I doing wrong?</p>