Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3? - Mailing list pgsql-patches

From David Fetter
Subject Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?
Date
Msg-id 20061128225109.GA5713@fetter.org
Whole thread Raw
Responses Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?
List pgsql-patches
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!

pgsql-patches by date:

Previous
From: Joseph S
Date:
Subject: Re: doc patch for savepoints
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?