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

From: David Fetter <david(at)fetter(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-hackers(at)postgresql(dot)org, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>, PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?
Date: 2006-11-28 22:51:09
Message-ID: 20061128225109.GA5713@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers pgsql-patches

On Tue, Nov 28, 2006 at 02:43:17PM -0500, Tom Lane wrote:
> "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?

Please find enclosed a patch which adds this :)

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

Attachment Content-Type Size
pg_dump_camel_case_example.patch text/plain 800 bytes

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2006-11-28 22:54:55 Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?
Previous Message Kevin Grittner 2006-11-28 19:49:31 Re: pg_dump -t broken for mixed case table names in

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-11-28 22:54:55 Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?
Previous Message Bruce Momjian 2006-11-28 22:03:52 Re: Double entries in log for page slots in beta3

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-11-28 22:54:55 Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?
Previous Message Kevin Grittner 2006-11-28 19:49:31 Re: pg_dump -t broken for mixed case table names in