Re: pg_dump -t broken for mixed case table names in

Thanks much; it might have been a while before I tried that nested
quoting technique. I think it's worth documenting. Would you like me
to try to put a doc patch together, or would it be better for someone
else to do so?

-Kevin


>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 11/28/06 1:43 PM >>>
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)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?

regards, tom lane