Re: Problem with backing up a large database - Mailing list pgsql-novice

From Tom Lane
Subject Re: Problem with backing up a large database
Date
Msg-id 3260.1377006679@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with backing up a large database  (Vik Fearing <vik.fearing@dalibo.com>)
Responses Re: Problem with backing up a large database
List pgsql-novice
Vik Fearing <vik.fearing@dalibo.com> writes:
> On 08/20/2013 01:47 PM, Athanasios Kostopoulos wrote:
>> Thank you for your reply Luca. Regarding the regular expression, I
>> need to exclude all tables starting with z thus ^z. I am not sure
>> about the star, should I do something along the lines of
>> ^z[Aa-Zz|0-9]* to catch all cases?

> Just do ^z and leave the star out of it.

I think it would be '[^z]*'.  The basic notation is not regex, it's
like Unix shells' filename wildcards; so you *do* need a star.
But we do recognize regex-style character classes, else this
requirement couldn't be met at all.

            regards, tom lane


pgsql-novice by date:

Previous
From: Vik Fearing
Date:
Subject: Re: Problem with backing up a large database
Next
From: Mael Rimbault
Date:
Subject: Re: Problem with backing up a large database