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 >
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 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
