public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Mike Toews <[email protected]>
Cc: [email protected]
Subject: Re: pg_dump -t '"Table"' for cmd.exe
Date: Mon, 1 Jul 2013 14:53:41 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAM2FmMo5YbxtAa_ZQhP99NqHod=UUyfXoCLrio2DJ344Wb81kQ@mail.gmail.com>
References: <CAM2FmMo5YbxtAa_ZQhP99NqHod=UUyfXoCLrio2DJ344Wb81kQ@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
On Tue, Nov 13, 2012 at 02:45:05PM +1300, Mike Toews wrote:
> I'm not sure if this is worth documenting, but pg_dumping mixed-case tables
> with the '-t table' option appears to not be accurately documented for cmd.exe.
> Here are my four attempts, with only the last as success:
>
> Intuitive (supplying "My Table" like "My Database"), but not correct:
> C:\>"C:\Program Files\PostgreSQL\9.1\bin\pg_dump.exe" -U postgres -t "My Table"
> "My Database"
> pg_dump: No matching tables were found
>
> As documented in last example at http://www.postgresql.org/docs/9.1/static/
> app-pgdump.html
> C:\>"C:\Program Files\PostgreSQL\9.1\bin\pg_dump.exe" -U postgres -t '"My
> Table"' "My Database"
> pg_dump: No matching tables were found
>
> Escaping quotes, but using single quotes:
> C:\>"C:\Program Files\PostgreSQL\9.1\bin\pg_dump.exe" -U postgres -t '\"My
> Table\"' "My Database"
> pg_dump: too many command-line arguments (first is "My Database")
>
> Escaping quotes, but using double quotes:
> C:\>"C:\Program Files\PostgreSQL\9.1\bin\pg_dump.exe" -U postgres -t "\"My
> Table\"" "My Database"
>
> works!
Good point. Docs updated with attached patch, and patched to 9.3 beta
as well.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
[text/x-diff] quote.diff (596B, 2-quote.diff)
download | inline diff:
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml
new file mode 100644
index 2b5e95b..1ed5e4f
*** a/doc/src/sgml/ref/pg_dump.sgml
--- b/doc/src/sgml/ref/pg_dump.sgml
*************** CREATE DATABASE foo WITH TEMPLATE templa
*** 1224,1230 ****
like
<screen>
! <prompt>$</prompt> <userinput>pg_dump -t '"MixedCaseName"' mydb > mytab.sql</userinput>
</screen></para>
</refsect1>
--- 1224,1230 ----
like
<screen>
! <prompt>$</prompt> <userinput>pg_dump -t "\"MixedCaseName\"" mydb > mytab.sql</userinput>
</screen></para>
</refsect1>
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pg_dump -t '"Table"' for cmd.exe
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox