title: How can I truncate (substring) all values for a particular column of a table in a PostgreSQL database?
body: <p>I'm fairly new to PostgreSQL. I'm working with a table that has not had a max-length (character count) enforced in the "title" column. The application needs it to be less than 1000 characters but some fields are at 1200, 1300 etc.</p>
  
  <p>I'm quite familiar with mySql but I'm having a harder time picking up PostgreSQL.</p>
  
  <p>If this was mySql I would so something like:</p>
  
  <pre><code>UPDATE TABLE entries SET title = LEFT(title,1000)
  </code></pre>
  
  <p>How can I accomplish the same thing with PostgreSQL?</p>
  
  <p>I have  phppgadmin and the commmand line at my disposal.</p>