Re: [GENERAL] Conversion of columns during CSV Import

2012-07-01 Thread Jasen Betts
On 2012-06-29, Patrick Schneider wrote: > Hello, > > is there any possibility to convert special columns during an CSV import > via COPY? > For example: > > HELLO;WORLD;;011001 > > should be converted to a character field do you mean like '' (easy) or like '香' or like '✏' (harder)

Re: [GENERAL] Conversion of columns during CSV Import

2012-06-29 Thread Edson Richter
Em 29/06/2012 14:10, Raymond O'Donnell escreveu: On 29/06/2012 08:54, Patrick Schneider wrote: Hello, is there any possibility to convert special columns during an CSV import via COPY? For example: HELLO;WORLD;;011001 should be converted to a character field 011001 to the date 10th J

Re: [GENERAL] Conversion of columns during CSV Import

2012-06-29 Thread Alban Hertroys
On 29 Jun 2012, at 9:54, Patrick Schneider wrote: > Hello, > > is there any possibility to convert special columns during an CSV import via > COPY? > For example: > > HELLO;WORLD;;011001 > > should be converted to a character field > 011001 to the date 10th January 2001 > > For the m

Re: [GENERAL] Conversion of columns during CSV Import

2012-06-29 Thread Steve Crawford
On 06/29/2012 12:54 AM, Patrick Schneider wrote: Hello, is there any possibility to convert special columns during an CSV import via COPY? For example: HELLO;WORLD;;011001 should be converted to a character field 011001 to the date 10th January 2001 For the moment the only idea we

Re: [GENERAL] Conversion of columns during CSV Import

2012-06-29 Thread Raymond O'Donnell
On 29/06/2012 08:54, Patrick Schneider wrote: > Hello, > > is there any possibility to convert special columns during an CSV import > via COPY? > For example: > > HELLO;WORLD;;011001 > > should be converted to a character field > 011001 to the date 10th January 2001 > > For the moment

[GENERAL] Conversion of columns during CSV Import

2012-06-29 Thread Patrick Schneider
Hello, is there any possibility to convert special columns during an CSV import via COPY? For example: HELLO;WORLD;;011001 should be converted to a character field 011001 to the date 10th January 2001 For the moment the only idea we have is, to import the CSV into a TEMP table and