title: to find new lines character in postgres
body: <p>Having couple of entries in database table that have multiple line "names" data. 
  I try to find single newline character from it. </p>
  
  <pre><code>SELECT
     id,
     strpos ( NAME, E'\n' ) AS Position_of_substring
  FROM
     problems
  WHERE
     strpos ( NAME, E'\n' ) &gt; 0;
  </code></pre>
  
  <p>But it fails for the data that have more than 1 new line character (\n).
  ANy way to find "n" number of "\n" in names data.</p>