Skip site navigation (1) Skip section navigation (2)

Parser function / command again ...

From: Aarni Ruuhimäki / Megative Tmi / KYMI(dot)com <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Parser function / command again ...
Date: 2002-06-29 07:18:08
Message-ID: 20020629072006.ODJD3204.fep06.tmt.tele.fi@there (view raw or flat)
Thread:
Lists: pgsql-novice
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

Next:From: Masaru SugawaraDate: 2002-06-29 13:29:09
Subject: Re: optimizing pl/pgsql function
Previous:From: Andrew McMillanDate: 2002-06-28 23:06:06
Subject: Re: PostgreSQL setup on dual boot laptop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group