Re: Load Mysql table CSV into postgresql

On 06/06/2013 12:58 PM, Adarsh Sharma wrote:
> Thanks Adrian , i think it works but still facing problem while loading
> Mysql ( MEDIUMBLOB ) column into PG ( BYTEA ) column :
>
> test=# \encoding LATIN1;
> test=# copy jobs from '/tmp/test.csv' with DELIMITER AS ',' QUOTE '"'
> NULL AS '\N' ESCAPE E'\\' CSV;
> ERROR: invalid input syntax for type bytea
> CONTEXT: COPY jobs, line 259, column wf_instance:
> "\0$0000000-120805203721153-oozie-oozi-W\0\0)<?xml version="1.0"
> encoding="UTF-8" standalone="no"?><..."
> test=#
>
> wf_instance is single mediumblob column in the table.

I have not done that conversion. All I can do is point you at this link,
courtesy of Google:

http://dba.stackexchange.com/questions/4211/how-to-migrate-large-blob-table-from-mysql-to-postgresql

Others on the list may have better ideas.

>
> Cheers

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com