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

[GENERAL] Import German Decimal Numbers

2008-05-07 Thread Jan Christian Dittmer
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 .). Is there any possiblility to switch the clients behaviourr (like 'set datestyle') for int