Skip site navigation (1) Skip section navigation (2)

Re: New pg_dump options: exclude tables/schemas, multiple all, wildcards

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: New pg_dump options: exclude tables/schemas, multiple all, wildcards
Date: 2006-01-18 01:07:57
Message-ID: 7d8398553bf8cd745a2923ed6dfb5c95@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> In practice, I don't think that LIKE-style patterns (% and _ wildcards)
> will pose a serious compatibility problem if we just decree that the
> -n and -t switches now take patterns rather than plain names.  I agree
> that regex-style patterns would open some gotchas, but what's wrong with
> standardizing on LIKE patterns?

Sounds good, but the more I think about it, why don't we just use regexes via
the ~ operator? After all, if we want to exclude schemas starting with an
underscore from pg_dump, then -N '^_.*' is no worse than -N '\\_%' and has
the added advantage of being more like regexes people are used to. I guess
my earlier 'which is which' argument isn't too much to worry about either -
chances are very slim that an existing script is using a -t argument that
contains regular expressions. Plus, while the underscore is common in
namespace names, a period is not.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200601172005
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFDzZSpvJuQZxSWSsgRAiEQAKD5YXJjne5ZjbSUyHLiVKrEBtLPxQCfbsN8
JlQH5S+UVTogKpyRQJoU6jk=
=Sfcu
-----END PGP SIGNATURE-----



In response to

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2006-01-18 03:54:31
Subject: Re: Huge number of disk writes after migration to 8.1
Previous:From: Alvaro HerreraDate: 2006-01-18 00:51:05
Subject: Re: Huge number of disk writes after migration to 8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group