title: SQL - How to escape parentheses in PostgreSQL
body: <p>I have the following sql command, i need to escape parentheses in PostgreSQL, how can i do that?</p>
  
  <pre><code>SELECT rua 
    FROM logradouros 
   WHERE rua ~* 'Antonio De Sant\'Ana Galvao Av Frei (Av 01 Parte A)' 
   LIMIT 100;
  </code></pre>