Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackerspgsql-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!

In response to

Responses

pgsql-docs by date

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

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group