pg推送到mysql模板示例

# 查看模板

```bash
python bin/datax.py -r posrgres -w mysql
```

# json配置文件

```json
{
    "job": {
        "setting": {
            "speed": {
                "channel": 1
            }
        },
        "content": [
            {
                "reader": {
                    "name": "postgresqlreader",
                    "parameter": {
                        "connection": [
                            {
                                "jdbcUrl": ["jdbc:postgresql://127.0.0.1:5432/stockdb"],
                                "querySql": ["select * from stock.dwi_cb_daily"]
                            }
                        ],
                        "username": "stock",
                        "password": "pass"
                    }
                },
                "writer": {
                    "name": "mysqlwriter",
                    "parameter": {
                        "writeMode": "insert",
                        "preSql": ["truncate table test.dwi_cb_daily"],
                        "session": [],
                        "column": [
                            "`ts_code`",
                            "`trade_date`",
                            "`pre_close`",
                            "`open`",
                            "`high`",
                            "`low`",
                            "`close`",
                            "`change`",
                            "`pct_chg`",
                            "`vol`",
                            "`amount`",
                            "`ztimestamp`"
                        ],
                        "username": "root",
                        "password": "pass",
                        "connection": [
                            {
                                "jdbcUrl": "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false",
                                "table": ["test.dwi_cb_daily"]
                            }
                        ]
                    }
                }
            }
        ]
    }
}
```

# 关键字标识符

```bash
# mysql
"`字段`","`字段`"

# pg
"\"字段\"","\"字段\""
```