Numeric and CSV under 8.0.1 ?
От | Stef |
---|---|
Тема | Numeric and CSV under 8.0.1 ? |
Дата | |
Msg-id | 20050408165147.GV30669@survivor.hades обсуждение исходный текст |
Ответы |
Re: Numeric and CSV under 8.0.1 ?
Re: Numeric and CSV under 8.0.1 ? |
Список | pgsql-sql |
Hello Everyone,Currently, here at work, I am doing the whole 'advocacy' part of postgreSQL. It's not really hard to do, as the other database's are MySQL and Sybase ;) There is obviously a whole spat of data munging going on in the background, and I noticed that psql in 8.0.1 now accepts CSV ! Great. Except, it doesn't really appear to be 100% there. Numeric's wrapped in '...' don't want to appear to go in. Is this a 'known problem' ? Table "public.visitor_main" Column | Type | Modifiers ------------------+----------------------+------------------------------iuserid | numeric(12,0) | not nullfirstname | character(25) | not nulllastname | character(25) | not null Sample Data line '3236','Alonzo','Peter' ERROR: invalid input syntax for type numeric: "'3236'" CONTEXT: COPY visitor_main, line 1, column iuserid: "'3236'" Thoughts ?RegardsSteph
В списке pgsql-sql по дате отправления: