On Mon, Jul 18, 2005 at 03:01:31PM -0400, Tom Lane wrote: > Andrew - Supernews <[EMAIL PROTECTED]> writes: > >>> "WHERE spcname NOT LIKE E'pg\\_%'"); > > > It's not even correct as it stands - if you want to match a literal _ > > using LIKE then you would need E'pg\\\\_%' there. > > Good point! > > > Would NOT LIKE 'pg!_%' ESCAPE '!' be better? > > Seems like a fine solution --- I was about to object that ESCAPE > doesn't go back as far as PG 7.0, but neither does pg_tablespace, > so that seems OK.
The ESCAPE version which you commited works, thanks! > Or perhaps better, use a regular regex: spcname !~ '^pg_'. The > majority of the comparable cases in psql's describe.c do it this > way, and they seem more readable to me ... Likewise.. then again your fix already works.. Cheers, Patrick ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq