From: Fabio Milillo <fmilillo@agr.uniba.it>
To: pgsql-general@postgresql.org
Subject: Re: COPY command documentation
Date: Fri, 15 Jul 2011 05:54:49 -0700 (PDT)
Message-ID: <1310734489540-4590548.post@n5.nabble.com> (raw)
In-Reply-To: <4422B9F8.60100@oisinglynn.com>
References: <4422B9F8.60100@oisinglynn.com>
Hi Oisin,
I am right in the condition you described, but nowadays the 8.0
documentation is only available without comments.
I tried the way suggested by Richard Sydney-Smith (*eliminating the spaces
in the path*), but unsuccessfully.
Could you please help me?
thanks, Fabio
*hint from Richard Sydney-Smith*
(
http://postgresql.1045698.n5.nabble.com/Windows-file-path-for-copy-tt1847135.html
):
/Windows XP SP2 with Postgresql 8.0.3
Two commands on fails the other succeeds:
*Fails *:
select import_sharedata('C:\\Documents and
Settings\\Richard\\Desktop\\EzyChart-20050721');
*Succeeds*:
select import_sharedata('C:\\EzyChart-20050721'); /
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. [...]
> 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
>
--
View this message in context: http://postgresql.1045698.n5.nabble.com/GENERAL-COPY-command-documentation-tp1858906p4590548.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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: fmilillo@agr.uniba.it, pgsql-general@postgresql.org
Subject: Re: COPY command documentation
In-Reply-To: <1310734489540-4590548.post@n5.nabble.com>
* 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