Re: [GENERAL] How to insert Ecoded values into postrgresql

2010-04-20 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> Given the lack of field complaints, I think changing this would be a >> pretty terrible idea; much more likely to break things than fix them. >> It's not like that RFC has huge recognition as The Standard. > Should we document we support the standard? I

Re: [GENERAL] How to insert Ecoded values into postrgresql

2010-04-20 Thread Bruce Momjian
Tom Lane wrote: > Merlin Moncure writes: > > *) csv is supposed to be CRLF *always*. We do not do this. We do > > however read different types of newlines. So we are a 4180 reader but > > not an emitter. Not so sure if I think changing this is a good idea > > though without exposing a knob. >

Re: [GENERAL] How to insert Ecoded values into postrgresql

2010-04-19 Thread Tom Lane
Merlin Moncure writes: > *) csv is supposed to be CRLF *always*. We do not do this. We do > however read different types of newlines. So we are a 4180 reader but > not an emitter. Not so sure if I think changing this is a good idea > though without exposing a knob. Given the lack of field com

Re: [GENERAL] How to insert Ecoded values into postrgresql

2010-04-19 Thread Merlin Moncure
On Thu, Apr 15, 2010 at 12:29 AM, Tom Lane wrote: > Bruce Momjian writes: >> Merlin Moncure wrote: >>> aside: anyone know if postgres properly handles csv according to rfc4180? > >> Wow, I had no idea there was an RFC for CSV. > > Me either.  I'd bet the percentage of "CSV"-using programs that ac

Re: [GENERAL] How to insert Ecoded values into postrgresql

2010-04-18 Thread Jasen Betts
On 2010-04-14, venkat wrote: > --0016362845f4b36d220484302ab7 > Content-Type: text/plain; charset=ISO-8859-1 > > Dear All, > >How to insert encoded data that is(/\...@#$%^&*)(_+) something like > thatI have Csv file .Which contains encoded values.when i try to insert > those. I am getting

Re: [GENERAL] How to insert Ecoded values into postrgresql

2010-04-15 Thread Merlin Moncure
On Thu, Apr 15, 2010 at 12:29 AM, Tom Lane wrote: > Bruce Momjian writes: >> Merlin Moncure wrote: >>> aside: anyone know if postgres properly handles csv according to rfc4180? > >> Wow, I had no idea there was an RFC for CSV. > > Me either.  I'd bet the percentage of "CSV"-using programs that ac

Re: [GENERAL] How to insert Ecoded values into postrgresql

2010-04-14 Thread Tom Lane
Bruce Momjian writes: > Merlin Moncure wrote: >> aside: anyone know if postgres properly handles csv according to rfc4180? > Wow, I had no idea there was an RFC for CSV. Me either. I'd bet the percentage of "CSV"-using programs that actually conform to the RFC is very small anyway; so while it

Re: [GENERAL] How to insert Ecoded values into postrgresql

2010-04-14 Thread Bruce Momjian
Merlin Moncure wrote: > On Wed, Apr 14, 2010 at 6:51 AM, venkat wrote: > > Dear All, > > > > ?? How to insert encoded data that is(/\...@#$%^&*)(_+) something like > > thatI have Csv file .Which contains encoded values.when i try to insert > > those. I am getting error..I am not able to insert

Re: [GENERAL] How to insert Ecoded values into postrgresql

2010-04-14 Thread Merlin Moncure
On Wed, Apr 14, 2010 at 6:51 AM, venkat wrote: > Dear All, > >    How to insert encoded data that is(/\...@#$%^&*)(_+) something like > thatI 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 guid

[GENERAL] How to insert Ecoded values into postrgresql

2010-04-14 Thread venkat
Dear All, How to insert encoded data that is(/\...@#$%^&*)(_+) something like thatI 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. I am waiting for your great response. Thanks and R