"Jan-Peter Seifert" <Jan-Peter.Seifert@xxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
