From: Jim Johannsen <jjsa@gvtc.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Numeric and CSV under 8.0.1 ?
Date: Fri, 08 Apr 2005 17:56:35 +0000
Message-ID: <4256C5D3.3050102@gvtc.com> (raw)
In-Reply-To: <20050408165147.GV30669@survivor.hades>
References: <20050408165147.GV30669@survivor.hades>
Stef:
Why is iuserid numeric? Are you going to do any math on the field?
If not, change it to varchar. In the long run you'll be happier.
Stef wrote:
>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 null
> firstname | character(25) | not null
> lastname | 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 ?
> Regards
> Steph
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jjsa@gvtc.com
Subject: Re: Numeric and CSV under 8.0.1 ?
In-Reply-To: <4256C5D3.3050102@gvtc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox