From: | DMan65 <tony(at)exquisiteimages(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Need help doing a CSV import |
Date: | 2010-07-13 23:25:59 |
Message-ID: | 29156720.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am in the process of moving a FoxPro based system to PostgreSQL.
We have several tables that have memo fields which contain carriage returns
and line feeds that I need to preserve. I thought if I converted these into
the appropriate \r and \n codes that they would be imported as carriage
returns and line feeds, but instead they are stored in the database as \r
and \n.
The command I am using is:
copy main.company
from E'f:\company.csv"
DELIMITER "|"
CSV HEADER QUOTE '"' ESCAPE E'\\';
The command imports all of the data, but I want the escaped codes to be
expanded to their actual values.
Can anyone assist me with this?
--
View this message in context: http://old.nabble.com/Need-help-doing-a-CSV-import-tp29156720p29156720.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kelly | 2010-07-14 18:03:25 | Order by provided IDs? |
Previous Message | Greg | 2010-07-13 15:28:01 | Re: Extended Query Protocol Question |