Adarsh Sharma wrote on 06.06.2013 19:33:
Hi,
Today i need to load some mysql ( 5.1.58 ) tables dump in postgresql
( PG 9.2 ). I loaded few tables successfully but while loading one
table i am facing below error :
After some research , i think it is failing because Mysql table has
character set
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'\\' C
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
On 06/06/2013 10:33 AM, Adarsh Sharma wrote:
Hi,
Today i need to load some mysql ( 5.1.58 ) tables dump in postgresql (
PG 9.2 ). I loaded few tables successfully but while loading one table i
am facing below error :
test=# copy jobs from '/tmp/test.csv' with DELIMITER AS ',' QUOTE '"'
NULL A
