X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (mx2.hub.org [200.46.204.254])
	by postgresql.org (Postfix) with ESMTP id 04A3711F6970
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Sat, 22 Apr 2006 00:04:11 -0300 (ADT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Score: -2.452
X-Spam-Level: 
X-Spam-Status: No, score=-2.452 required=5 tests=[AWL=0.149, BAYES_00=-2.599,
	SPF_HELO_PASS=-0.001, SPF_PASS=-0.001]
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024)
	with ESMTP id bP+VqgK9rwtS
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Sat, 22 Apr 2006 00:04:08 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from candle.pha.pa.us (candle.pha.pa.us [70.90.9.53])
	by postgresql.org (Postfix) with ESMTP id 8123611F656C
	for <pgsql-general@postgresql.org>;
	Sat, 22 Apr 2006 00:04:07 -0300 (ADT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.11.6) id k3M345f05475;
	Fri, 21 Apr 2006 23:04:05 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200604220304.k3M345f05475@candle.pha.pa.us>
Subject: Re: COPY command documentation
In-Reply-To: <4422B9F8.60100@oisinglynn.com>
To: Oisin Glynn <me@oisinglynn.com>
Date: Fri, 21 Apr 2006 23:04:05 -0400 (EDT)
CC: pgsql general <pgsql-general@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL121 (25)]
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary=ELM1145675045-26004-0_
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200604/974
X-Sequence-Number: 94415


--ELM1145675045-26004-0_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII


I have added the following patch for 8.2 that suggests using E'' strings
and doubling backslashes used as path separators, and backpatched the
later suggestion to 8.1.  Thanks.

---------------------------------------------------------------------------

Oisin Glynn wrote:
> I have driven myself to distraction for the last 30 minutes trying to 
> get COPY to work on Windows  XP.  The Unix style c:/afolder/afile 
> instead of c:\afolder\afile was a desperation attempt.
> 
> I had tried all sorts of double slashes \\ putting the whole path in 
> quotes basically all sorts of foolishness.  I would suggest the there 
> should be a Windows example(s) in the documents as well as a *NIX style 
> one(s) where necessary. Did I miss this somewhere or should I put a 
> comment on the doc or what can I do to help the next Windows user.
> 
> Oisin
> 
> 
> P.S.
> I just discovered that the comments from 8.0 had the answer I was 
> looking for but these comments are not in the 8.1 docs. Should the 
> comments be rolled forward as new versions are created? Or if valid 
> comments added to the docs themselves?
> 
> http://www.postgresql.org/docs/8.1/interactive/sql-copy.html
> 
> http://www.postgresql.org/docs/8.0/interactive/sql-copy.html
> 
> Now happily using COPY,
> Oisin
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 

-- 
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

--ELM1145675045-26004-0_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain
Content-Disposition: inline; filename="/bjm/diff"

Index: doc/src/sgml/ref/copy.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v
retrieving revision 1.73
diff -c -c -r1.73 copy.sgml
*** doc/src/sgml/ref/copy.sgml	3 Mar 2006 19:54:10 -0000	1.73
--- doc/src/sgml/ref/copy.sgml	22 Apr 2006 02:58:39 -0000
***************
*** 106,112 ****
      <term><replaceable class="parameter">filename</replaceable></term>
      <listitem>
       <para>
!       The absolute path name of the input or output file.
       </para>
      </listitem>
     </varlistentry>
--- 106,114 ----
      <term><replaceable class="parameter">filename</replaceable></term>
      <listitem>
       <para>
!       The absolute path name of the input or output file.  Windows users
!       might need to use an <literal>E''</> string and double backslashes
!       used as path separators.
       </para>
      </listitem>
     </varlistentry>

--ELM1145675045-26004-0_--