Well if your doing an update, do it column by column and when you do a date column replace the '.' with '/' -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Jan Christian Dittmer Sent: Wednesday, May 07, 2008 10:16 AM To: pgsql-general@xxxxxxxxxxxxxx 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 another problem then. Our date format is also german :-( "DD.MM.YY" or "DD.MM.YYYY". So if I just exchange '.' and ',' the date will be unreadable for the import :-( The (current) file is 1.4 GB so it will take ages to let awk chew on it I guess. Christian Ken Allen wrote: > I would replace the ',' with something else such as a '#' first then > replace the decimal with the ',' then replace the '#' with a decimal '.' > > If you do the ',' with a '.' first then all of them will be '.' and you > wont know which ones to change. > > Don't know, but you can replace the , to . within the ascii-file (sed, > awk, ...). > > > Andreas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- This message has been scanned by MailScanner
