title: in postgres, can you set the default formatting for a timestamp, by session or globally?
body: <p>In Postgres, is it possible to change the default format mask for a timestamp?</p>
  
  <p>right now comes back as</p>
  
  <pre><code>2012-01-03 20:27:53.611489
  </code></pre>
  
  <p>I would like resolution to minute like this:</p>
  
  <pre><code>2012-01-03 20:27
  </code></pre>
  
  <p>I know I can do this on individual columns with <code>to_char() as</code> or stripped down with a <code>substr()</code> by the receiving app, but having it formatted correctly initially would save a lot of work and reduce a lot of errors.</p>