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)
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
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
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
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
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