Re: [GENERAL] Import German Decimal Numbers

2008-05-08 Thread Dimitri Fontaine
Hi, Le 7 mai 08 à 15:57, Tino Wildenhain a écrit : There is also http://pgfoundry.org/projects/pgloader/ and if not already implemented it should be fairly easy to implement a data filter within this one. pgloader indeed support user reformating modules, and comes with a mysql to pgsql times

Re: [GENERAL] Import German Decimal Numbers

2008-05-07 Thread Tino Wildenhain
William Temperley wrote: ... Bit of a tangent, but Is there any possibility of SQL injection via data provided to copy? depends on how you call COPY, but usually not :-) Cheers Tino smime.p7s Description: S/MIME Cryptographic Signature

Re: [GENERAL] Import German Decimal Numbers

2008-05-07 Thread William Temperley
> Jan Christian Dittmer wrote: > > > >Thank you very much! > >You have remind me that the our server runs under Linux and not under > > Windows as our clients :-) > >So indeed I can use a sed-pipe construct to switch '.' and ','. > >But wait, there is just another problem then. Our

Re: [GENERAL] Import German Decimal Numbers

2008-05-07 Thread Tino Wildenhain
Thomas Pundt wrote: On Mittwoch, 7. Mai 2008, Jan Christian Dittmer wrote: | The (current) file is 1.4 GB so it will take ages to let awk chew on it | I guess. If you think awk is a bottleneck, I'd recommend using perl instead. It's waaay faster and should process your file within minutes if not

Re: [GENERAL] Import German Decimal Numbers

2008-05-07 Thread Thomas Pundt
On Mittwoch, 7. Mai 2008, Jan Christian Dittmer wrote: | The (current) file is 1.4 GB so it will take ages to let awk chew on it | I guess. If you think awk is a bottleneck, I'd recommend using perl instead. It's waaay faster and should process your file within minutes if not faster. Ciao, Thomas

Re: [GENERAL] Import German Decimal Numbers

2008-05-07 Thread Tino Wildenhain
Jan Christian Dittmer wrote: Thank you very much! You have remind me that the our server runs under Linux and not under Windows as our clients :-) So indeed I can use a sed-pipe construct to switch '.' and ','. But wait, there is just another problem then. Our date format is also german :-( "D

Re: [GENERAL] Import German Decimal Numbers

2008-05-07 Thread Ken Allen
neral@postgresql.org Subject: Re: [GENERAL] Import German Decimal Numbers Thank you very much! You have remind me that the our server runs under Linux and not under Windows as our clients :-) So indeed I can use a sed-pipe construct to switch '.' and ','. But wait, there is just

Re: [GENERAL] Import German Decimal Numbers

2008-05-07 Thread Jan Christian Dittmer
Thank you very much! You have remind me that the our server runs under Linux and not under Windows as our clients :-) So indeed I can use a sed-pipe construct to switch '.' and ','. But wait, there is just another problem then. Our date format is also german :-( "DD.MM.YY" or "DD.MM.". So i

Re: [GENERAL] Import German Decimal Numbers

2008-05-07 Thread Ken Allen
nt know which ones to change. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Kretschmer Sent: Wednesday, May 07, 2008 9:38 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Import German Decimal Numbers am Wed, dem 07.05.2008, um 14:25:13 +02

Re: [GENERAL] Import German Decimal Numbers

2008-05-07 Thread A. Kretschmer
am Wed, dem 07.05.2008, um 14:25:13 +0200 mailte Jan Christian Dittmer folgendes: > Hi! > > I want to import some data from an ascii file using the COPY sql-command. > Unfortunatly the decimal numbers are given in german format, meaning the > decimal point is replaced by a comma (, instead of .)