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@sss.pgh.pa.us> 11/28/06 1:43 PM >>>
"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?
regards, tom lane