可否把mysql的资料PostgreSQL

bopchung

因一直用mysql

有甚麽工具把mysql的资料轉到 PostgreSQL

netkiller

自己写一个脚本导入，就行了如：
-bash-2.05b$ cat mysql2pgsql.sh
mysql -ugdfz gdfz <export.sql| \
awk -F ' ' '{print $1 "," $2 "," $3 "," $4 ","$5}' | \
awk -F ',' '{printf("insert into \"user\"(userid,passwd,name,nickname,active,email,question,answer) \
values(\x127" $1 "\x127,\x127" $2 "\x127,\x127 \x127,\x127" $3 "\x127,\x127true\x127,\x127" $4 "\x127,\x127\x127,\x127\x127);\n" }' >;user_data.sql
psql -Uchen member -f user_data.sql

bopchung

谢谢啦！

安装後试试看！