Michael Fuhr <mike@fuhr.org> writes:
> How backward compatible should vacuumlo remain? This patch changes
> the string to E'...' but other ways would be to use dollar quotes
> or ESCAPE.
In this particular case, a far better answer is to replace
> ! strcat(buf, " AND s.nspname NOT LIKE 'pg\\\\_%'");
with
> ! strcat(buf, " AND s.nspname !~ '^pg_'");
which sidesteps the problem entirely and is more readable to boot.
regards, tom lane