Postgres Pro
Downloads
Home   >   mailing lists

Import German Decimal Numbers - Mailing list pgsql-general

From Jan Christian Dittmer
Subject Import German Decimal Numbers
Date
Msg-id 48219FA9.4010600@web.de
Whole thread Raw
Responses Re: Import German Decimal Numbers  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
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
interpretation of decimals?

Thanks!

best regards,
  Christian Dittmer

pgsql-general by date:

Previous
From: valgog
Date:
Subject: Re: Is this possible in a trigger?
Next
From: Raymond O'Donnell
Date:
Subject: Re: bytea and character encoding when inserting escaped literals