"Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)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