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: (view raw, whole thread or download thread mbox)
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:

  from E'f:\company.csv"

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:
Sent from the PostgreSQL - novice mailing list archive at


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-2017 The PostgreSQL Global Development Group