pgsql导出到mysql_PostgreSQL导出一张表到MySQL

region_il>select count(*) fromresult_basic;+----------+

| count(*) |

+----------+

| 2611527 |

+----------+

1 row in set (0.94sec)

region_il>select * from result_basic where result_id = 2\G*************************** 1. row ***************************result_id:2ppid: SUK5QD9B7C16D826B26E5

title: ????? ??????? ????????

categories: {791}

phone:

brand_code:

street_address: ???? ?????? ???? ?? ?????????

zip_code:42314city: ???????

state: ???????

country: SAU

lat:24.47893lon:39.65331vendor_code: NOCO

vendor_poi_id:1040248605actual_street_address:

actual_zip_code:

extender: {"sideOfStreet":"+","mapLinkId":"571732670"}

titles:1 row in set (0.05sec)

region_il>show variables like '%char%';+--------------------------+----------------------------------+

| Variable_name | Value |

+--------------------------+----------------------------------+

| character_set_client | latin1 |

| character_set_connection | latin1 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | latin1 |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/local/mysql/share/charsets/ |

+--------------------------+----------------------------------+

8 rows in set (0.03sec)

region_il>set character_set_results =utf8;

Query OK,0 rows affected (0.02sec)

region_il>select * from result_basic where result_id = 2\G*************************** 1. row ***************************result_id:2ppid: SUK5QD9B7C16D826B26E5

title: هندسة العمارة والديكور

categories: {791}

phone:

brand_code:

street_address: طريق الأمير مقرن بن عبدالعزيز

zip_code:42314city: المدينة

state: المدينة

country: SAU

lat:24.47893lon:39.65331vendor_code: NOCO

vendor_poi_id:1040248605actual_street_address:

actual_zip_code:

extender: {"sideOfStreet":"+","mapLinkId":"571732670"}

titles:1 row in set (0.00 sec)