Re: pg_dump -t broken for mixed case table names in beta3? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump -t broken for mixed case table names in beta3?
Date
Msg-id 5470.1164742997@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump -t broken for mixed case table names in beta3?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: pg_dump -t broken for mixed case table names in  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: pg_dump -t broken for mixed case table names in beta3?  (David Fetter <david@fetter.org>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [pgsql-www] FAQs and Port Status
Next
From: Peter Eisentraut
Date:
Subject: Re: Short writes