Postgres Pro
Downloads
Home   >   mailing lists

Parser function / command again ... - Mailing list pgsql-novice

From AarniRuuhimäki / Megative Tmi / KYMI.com
Subject Parser function / command again ...
Date
Msg-id 20020629072006.ODJD3204.fep06.tmt.tele.fi@there
Whole thread Raw
List pgsql-novice
Tree view 
Hi !

Let me rephrase my question:

Is there a way to parse a MS-SQL .csv file 'on the fly' with COPY ?

Something like

COPY temp_update FROM file.csv USING DELIMITERS ';' NUMBEROFDELIMITERS '12'
LINEBREAKS '#'

Or what would be the way to go about this ?

Please, anyone ?

BR,

aarni

pgsql-novice by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: command length?
Next
From: Andrew McMillan
Date:
Subject: Re: PostgreSQL setup on dual boot laptop