On Tue, Nov 28, 2006 at 02:43:17PM -0500, Tom Lane wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Index: doc/src/sgml/ref/pg_dump.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v
retrieving revision 1.91
diff -c -r1.91 pg_dump.sgml
*** doc/src/sgml/ref/pg_dump.sgml       23 Oct 2006 18:10:32 -0000      1.91
--- doc/src/sgml/ref/pg_dump.sgml       28 Nov 2006 22:50:15 -0000
***************
*** 805,810 ****
--- 805,818 ----
    </para>
  
    <para>
+    To dump a single table named <literal>camelCaseTable</>:
+ 
+ <screen>
+ <prompt>$</prompt> <userinput>pg_dump -t '"camelCaseTable"' mydb &gt; 
db.sql</userinput>
+ </screen>
+   </para>
+ 
+   <para>
     To dump all tables whose names start with <literal>emp</> in the
     <literal>detroit</> schema, except for the table named
     <literal>employee_log</literal>:
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to