Re: escape string syntax and pg_dumpall

On Mon, Jul 18, 2005 at 03:01:31PM -0400, Tom Lane wrote:
> Andrew - Supernews <andrew+nonews@supernews.com> 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