title: Postgresql regex extract all texts between parentheses
body: <p>In PostgreSQL, I have a text value <code>foo (text1) bar (text2)</code>, I want to regex match and extract all the texts between parentheses</p>
  
  <pre><code>SELECT REGEXP_MATCHES('foo (text1) bar (text2)', '\((.*)\)', 'g')
  </code></pre>
  
  <p>I got this response:</p>
  
  <pre><code>regex_matches
  -------------------
  {text1) bar (text2}
  </code></pre>
  
  <p>I expect the output to be:</p>
  
  <pre><code>regex_matches
  -------------------
  text1
  text2
  </code></pre>