Skip site navigation (1) Skip section navigation (2)

Need help doing a CSV import

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 (view raw or flat)
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.


Responses

pgsql-novice by date

Next:From: Mark KellyDate: 2010-07-14 18:03:25
Subject: Order by provided IDs?
Previous:From: GregDate: 2010-07-13 15:28:01
Subject: Re: Extended Query Protocol Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group