Hello,
Tom Lane wrote:
>> 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'.
a very belated thank you very much for the explanation. So it matched
every view ending on the user's name ...
Makes me wonder whether this query was broken to begin with or did this
change with time / introduction of standard conforming strings?
Thank you very much,
Peter