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.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
