Re: How to insert Ecoded values into postrgresql

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: venkat <ven(dot)tammineni(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to insert Ecoded values into postrgresql
Date: 2010-04-15 03:07:30
Message-ID: 201004150307.o3F37UR18348@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Merlin Moncure wrote:
> On Wed, Apr 14, 2010 at 6:51 AM, venkat <ven(dot)tammineni(at)gmail(dot)com> wrote:
> > Dear All,
> >
> > ?? How to insert encoded data that is(/\_+(at)#$%^&*)(_+) something like
> > that....I have Csv file .Which contains encoded values.when i try to insert
> > those. I am getting error..I am not able to insert encoded data.Please
> > anyone guide me.
>
> *) how are you loading your csv file? with copy?
>
> *) is your file properly csv formatted to a particular standard? (such
> as rfc4180)
>
> aside: anyone know if postgres properly handles csv according to rfc4180?

Wow, I had no idea there was an RFC for CSV. Could you test and tell us
how we compare --- that would be a good thing to document.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Mead 2010-04-15 03:08:15 Re: Inconsistent SQL errors
Previous Message gvim 2010-04-15 03:04:15 Inconsistent SQL errors