Re: BUG #5535: Backslash in condition for LIKE statement is not seen - Mailing list pgsql-bugs

"Jeff Benjamin" <jeff@ivertex.com> wrote:

> Seems one cannot use a backslash character in a LIKE condition.

By default that has special meaning as an escape character.

Try this:

select * from test where pattern like E'\\w%' escape '#';

or this:

select * from test where pattern like E'\\\\w%';

-Kevin