Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Im****t Ger...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 7 Topic 15479 of 17437
Post > Topic >>

Re: Im****t German Decimal Numbers

by andreas.kretschmer@[EMAIL PROTECTED] ("A. Kretschmer") May 7, 2008 at 02:37 PM

am  Wed, dem 07.05.2008, um 14:25:13 +0200 mailte Jan Christian Dittmer
folgendes:
> Hi!
> 
> I want to im****t 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?

Don't know, but you can replace the , to . within the ascii-file (sed,
awk, ...).


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 7 Posts in Topic:
Import German Decimal Numbers
jcdittmer@[EMAIL PROTECTE  2008-05-07 14:25:13 
Re: Import German Decimal Numbers
andreas.kretschmer@[EMAIL  2008-05-07 14:37:43 
Re: Import German Decimal Numbers
KenA@[EMAIL PROTECTED] (  2008-05-07 09:44:58 
Re: Import German Decimal Numbers
jcdittmer@[EMAIL PROTECTE  2008-05-07 15:15:50 
Re: Import German Decimal Numbers
KenA@[EMAIL PROTECTED] (  2008-05-07 10:21:12 
Re: Import German Decimal Numbers
mlists@[EMAIL PROTECTED]   2008-05-07 14:48:21 
Re: Import German Decimal Numbers
dim@[EMAIL PROTECTED] (D  2008-05-08 13:59:14 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 12:04:53 CST 2008.