title: How to format and insert a character in between a string- Postgresql
body: <p>I have this table.</p>
  
  <p><code>member_id | phone_number 
  -----------+--------------
           1 | 09151234567
           2 | 09904897851
           3 | 09196332111
           4 | 09957935412
           5 | 09251279633
           6 | 09357489412
           7 | 09155974684
  (7 rows)</code></p>
  
  <p>I format the phone_number column to this format <strong>(63)xxxxxxxxx</strong>. Using this code  <br>
  <code>update member set phone_number = regexp_replace(phone_number, '0(.)', '(63)');</code></p>
  
  <p><code>member_id | phone_number<br>
  -----------+---------------
           1 | (63)151234567
           2 | (63)904897851
           3 | (63)196332111
           4 | (63)957935412
           5 | (63)251279633
           6 | (63)357489412
           7 | (63)155974684
  (7 rows)
  </code>
  <br>
  And now I need to update this column again to this format <strong>(63)xxx-xxxxxx</strong>.
  I don't want to replace a character, I need to insert a character in between the string.
  I've tried using substring, regexp_replace but failed. I'm doing something wrong. I did find questions somehow related to this but they are all about string replacement.</p>