<p>I need to do a query that search for a text with <strong>'Nome % teste \  / '</strong> as prefix. I'm doing the query using:</p>

<p><strong>where "name" ILIKE 'Nome a% teste \ /%' ESCAPE 'a'</strong> (using a as escape character).</p>

<p>There is a row that match this, but this query returns nothing. Removing the slash (<strong>'Nome % teste \'</strong>), it works. But I don't see why the <strong>slash</strong> is a problem, since the default escape is a <strong>backslash</strong> and I've changed it to <strong>'a'</strong> in this test.</p>

<p>There is something that I'm missing? (I've consulted TFM)</p>

Have you tried just using the backslash to escape it like this:
```
```
where "name" ILIKE 'Nome \% teste \\\/';
```
```