pg_dump and table exclusion: multiple patterns

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump and table exclusion: multiple patterns
Date: 2010-09-28 11:57:27
Message-ID: C4DAC901169B624F933534A26ED7DF31034BB7FD@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hello,

I'm trying to export a schema with multiple table exclusions:

pg_dump -i -v -nXXX -T
'*20((08[0-9]+)|(09[0-9]+)|(100[1-8][0-9]+)|(1009[0-1][0-9]+))'

unfortunately, the filter does not work as expected.(no table at all
are excluded)

when I try the same pattern with psql dt\, I get the expected list of
tables to exclude...

pg_dump --version

pg_dump (PostgreSQL) 8.3.9

I'd appreciate some help.

best regards,

Marc Mamin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Mamin 2010-09-28 12:56:03 Re: pg_dump and table exclusion: multiple patterns
Previous Message Lukasz Brodziak 2010-09-28 07:48:00 Could not read block error question