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

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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump -t broken for mixed case table names in
Date: 2006-11-28 19:49:31
Message-ID: 456C3E6A.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackerspgsql-patches
Thanks much; it might have been a while before I tried that nested
quoting technique.  I think it's worth documenting.  Would you like me
to try to put a doc patch together, or would it be better for someone
else to do so?
 
-Kevin
 
 
>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 11/28/06 1:43 PM >>> 
"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

pgsql-docs by date

Next:From: David FetterDate: 2006-11-28 22:51:09
Subject: Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?
Previous:From: Tom LaneDate: 2006-11-28 19:43:17
Subject: Re: pg_dump -t broken for mixed case table names in beta3?

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-11-28 19:56:28
Subject: Re: Short writes
Previous:From: Peter EisentrautDate: 2006-11-28 19:48:06
Subject: Re: Short writes

pgsql-patches by date

Next:From: David FetterDate: 2006-11-28 22:51:09
Subject: Re: [HACKERS] pg_dump -t broken for mixed case table names in beta3?
Previous:From: Tom LaneDate: 2006-11-28 19:43:17
Subject: Re: pg_dump -t broken for mixed case table names in beta3?

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