"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> Description: LIKE clause double-unescapes characters
This is not a bug, and it is documented. You can adjust the behavior
with LIKE ... ESCAPE ... if you don't like it.
regards, tom lane