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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump -t broken for mixed case table names in beta3?
Date: 2006-11-28 19:43:17
Message-ID: 5470.1164742997@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers pgsql-patches

"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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Kevin Grittner 2006-11-28 19:49:31 Re: pg_dump -t broken for mixed case table names in
Previous Message Kevin Grittner 2006-11-28 19:27:55 pg_dump -t broken for mixed case table names in beta3?

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-11-28 19:48:06 Re: Short writes
Previous Message Josh Berkus 2006-11-28 19:32:29 Re: [HACKERS] FAQs and Port Status

Browse pgsql-patches by date

  From Date Subject
Next Message Kevin Grittner 2006-11-28 19:49:31 Re: pg_dump -t broken for mixed case table names in
Previous Message Kevin Grittner 2006-11-28 19:27:55 pg_dump -t broken for mixed case table names in beta3?