Re: Problem with backing up a large database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>
Cc: Athanasios Kostopoulos <athanasios(dot)kostopoulos(at)classmarkets(dot)com>, Luca Ferrari <fluca1978(at)infinito(dot)it>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Problem with backing up a large database
Date: 2013-08-20 13:51:19
Message-ID: 3260.1377006679@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Vik Fearing <vik(dot)fearing(at)dalibo(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mael Rimbault 2013-08-20 17:47:03 Re: Problem with backing up a large database
Previous Message Vik Fearing 2013-08-20 12:06:22 Re: Problem with backing up a large database