Re: LIKE - bug or expected behaviour? - Mailing list pgsql-admin

"Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de> writes:
> Strangely the following select:

> SELECT table_name FROM information_schema.views WHERE table_schema = current_schema() AND table_name LIKE
'\_%\_username';

> does also match views with names like table_username.

Unless you have standard_conforming_strings turned on, those backslashes
are going to be eaten by the string-literal parser.  So the LIKE code
just sees '_%_username'.

            regards, tom lane