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 |
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 |
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 |
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 |