Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D07089FB27F for ; Tue, 28 Nov 2006 15:43:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 10823-07 for ; Tue, 28 Nov 2006 15:43:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 67D279FB273 for ; Tue, 28 Nov 2006 15:43:18 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kASJhHOJ005471; Tue, 28 Nov 2006 14:43:17 -0500 (EST) To: "Kevin Grittner" cc: pgsql-hackers@postgresql.org Subject: Re: pg_dump -t broken for mixed case table names in beta3? In-reply-to: <456C395A.EE98.0025.0@wicourts.gov> References: <456C395A.EE98.0025.0@wicourts.gov> Comments: In-reply-to "Kevin Grittner" message dated "Tue, 28 Nov 2006 13:27:55 -0600" Date: Tue, 28 Nov 2006 14:43:17 -0500 Message-ID: <5470.1164742997@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/920 X-Sequence-Number: 94382 "Kevin Grittner" 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