COPY command documentation

From: Oisin Glynn <me(at)oisinglynn(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: COPY command documentation
Date: 2006-03-23 15:08:40
Message-ID: 4422B9F8.60100@oisinglynn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Jim Nasby 2006-03-23 18:00:13 Re: COPY command documentation
Previous Message Thomas F. O'Connell 2006-03-23 04:54:15 Re: Online Backups: Minor Caveat, Major Addition?

Browse pgsql-general by date

  From Date Subject
Next Message denis 2006-03-23 15:24:27 Interval regression test failing with -march=pentium4
Previous Message JP Glutting 2006-03-23 15:03:24 Re: ERROR: could not convert UTF8 character to ISO8859-1