Thread: Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?
On Tue, Nov 28, 2006 at 02:43:17PM -0500, Tom Lane wrote: > "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes: > > Unless I'm missing something, pg_dump is not allowing selective dump of > > a table where the table name is mixed case. > > You do it like this: > > $ pg_dump -s -t '"DbTranLogRecord"' dtr > > A bit ugly but the conflict between shell and SQL quoting rules > sometimes forces us into compromises :-( > > Perhaps it's worth having an example for this in the pg_dump man page? Please find enclosed a patch which adds this :) Cheers, D -- David Fetter <david@fetter.org> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!
David Fetter <david@fetter.org> writes: > On Tue, Nov 28, 2006 at 02:43:17PM -0500, Tom Lane wrote: >> Perhaps it's worth having an example for this in the pg_dump man page? > Please find enclosed a patch which adds this :) Already done, thanks. regards, tom lane