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