From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Oisin Glynn <me@oisinglynn.com>
Cc: pgsql general <pgsql-general@postgresql.org>
Subject: Re: COPY command documentation
Date: Fri, 21 Apr 2006 23:04:05 -0400 (EDT)
Message-ID: <200604220304.k3M345f05475@candle.pha.pa.us> (raw)
In-Reply-To: <4422B9F8.60100@oisinglynn.com>
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. +
Attachments:/bjm/diff (text/plain, 937B) download
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>
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: pgsql-docs@postgresql.org
Cc: pgman@candle.pha.pa.us, me@oisinglynn.com, pgsql-general@postgresql.org
Subject: Re: COPY command documentation
In-Reply-To: <200604220304.k3M345f05475@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox