title: how to split columns in two parts after first
body: <p>there is a column of type <strong>text</strong> in postgresql
  and have data in form</p>
  
  <pre><code>aa.bbb.cc.dddd
  ee.fff.gg.hh.iiii
  kk.ffg.hjf
  </code></pre>
  
  <p>I want to split it into two parts after first <code>.</code> as follows:</p>
  
  <pre><code>aa   bbb.cc.dddd
  ee   fff.gg.hh.iiii
  kk   ffg.hjf
  </code></pre>
  
  <p>What query can I use to do so?</p>
  
  <p>I have tried </p>
  
  <pre><code>SELECT split_part(col_name, '.', 1) AS part1,
         split_part(col_name,'.',2) AS part2 
  from table_name;
  </code></pre>
  
  <p>But this is splitting it into aa and bbb</p>