Re: [GENERAL] COPY FROM and NULL AS does not work

2006-12-01 Thread Arnaud Lesauvage
Richard Huxton a écrit : Arnaud Lesauvage wrote: HI List, Trying to import data from a text file, with a semicolon as the delimiter, double-quotes as the quoting character. I would like empty strings to be inserted as NULL values in a varchar column. In the text file, they are writen as :

Re: [GENERAL] COPY FROM and NULL AS does not work

2006-12-01 Thread Dimitri Fontaine
Le vendredi 1 décembre 2006 11:28, Arnaud Lesauvage a écrit : > HI List, > > Trying to import data from a text file, with a semicolon as > the delimiter, double-quotes as the quoting character. > > I would like empty strings to be inserted as NULL values in > a varchar column. In the text file, t

Re: [GENERAL] COPY FROM and NULL AS does not work

2006-12-01 Thread Richard Huxton
Arnaud Lesauvage wrote: HI List, Trying to import data from a text file, with a semicolon as the delimiter, double-quotes as the quoting character. I would like empty strings to be inserted as NULL values in a varchar column. In the text file, they are writen as : ;""; I'm not sure you c