On Monday, February 06, 2012 9:43:35 pm Lockas wrote:
> OK .. my offending line number is 4533
> How can i remove it while copying ?
As others have said if it is just the one line remove it manually and then do
the COPY.
If there are many lines and if you will dealing with this on a recurring ba
On 7 February 2012 06:43, Lockas wrote:
> OK .. my offending line number is 4533
> How can i remove it while copying ?
You can remove it before copying or after, but not while.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
--
Sent via pgsql-gen
OK .. my offending line number is 4533
How can i remove it while copying ?
*COPY Table
FROM 'insert .csv dir here'
USING DELIMITERS ';' CSV HEADER*
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5462255.html
Sent from the Pos
On 6 February 2012 13:26, Lockas wrote:
> *
> ok then if I want to except that row from copying. how i can write it ?*
You can either remove the offending line(s) from the csv file or copy
to a staging table that doesn't have those limitations on field
lengths first.
--
If you can't see the for
On Feb 6, 2012, at 7:26, Lockas wrote:
> *
> ok then if I want to except that row from copying. how i can write it ?*
>
>
Copy is all or nothing. Either fix the problem row(s) or remove them from the
file manually.
David J.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
*
ok then if I want to except that row from copying. how i can write it ?*
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5459976.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-gene
On 6 February 2012 07:37, Lockas wrote:
> I've tried a lot of sizes
> but I still have messages in my log saying:
>
> * ---
> ERROR: value too long for type character varying(200)
> --- *
>
> Why is this? There are no other varchar(200) columns in my DB at all,
> no other table. Only this colu
I've tried a lot of sizes
but I still have messages in my log saying:
* ---
ERROR: value too long for type character varying(200)
--- *
Why is this? There are no other varchar(200) columns in my DB at all,
no other table. Only this column used to be 25 characters and using
the alter ty
no not all of rows
is that gonna work ?
thanks
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5459396.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-ge
Subject: Re: [GENERAL] Error while importing CSV file
>
> OK that problem solved
> Thanks so much
>
> but I had another problem
>
> *ERROR: value too long for type character varying(100)*
>
> although in the original file it was varying(25) only !!
>
> --
> Vi
OK that problem solved
Thanks so much
but I had another problem
*ERROR: value too long for type character varying(100)*
although in the original file it was varying(25) only !!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p54
Thanks but still i get this :
*ERROR: invalid input syntax for integer: "id"*
(1st col only)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5459334.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
On Feb 5, 2012, at 11:04, Shadin_ wrote:
>
> am new at dealing with PostgreSQL
> I was using PGAdmin and needed to export some data from a query I had run
> and then import it in another DB.
>
> *my columns names* : id (int4), name (varchar), time_starp(timestamp)
>
> so I followed these inst
am new at dealing with PostgreSQL
I was using PGAdmin and needed to export some data from a query I had run
and then import it in another DB.
*my columns names* : id (int4), name (varchar), time_starp(timestamp)
so I followed these instructions
http://www.question-defense.com/2010/10/15/how-to-
14 matches
Mail list logo
