Postgresql Import Chinese Table method

At that time encountered this problem, a variety of Baidu also found no solution. Now that we've solved it, let's share the method:

1. Table format must be CSV format 650) this.width=650; "title=" Eeeee.png "src=" http://s3.51cto.com/wyfs02/M01/75/16/wKiom1Yx_ Uct35n7aab8cccmavq446.jpg "alt=" Wkiom1yx_uct35n7aab8cccmavq446.jpg "/>

2. Open the file with Notepad, then click "Encode" in File > Save as > Lower right corner to select "UTF-8" and save after changing the file name

   650) this.width=650; "title=" 22.png "src=" http://s3.51cto.com/wyfs02/M02/75/15/wKiom1Yx-zaxApK_AACp63AFZ3U014.jpg "alt=" Wkiom1yx-zaxapk_aacp63afz3u014.jpg "/>

3. Then import the table with Chinese into the Pgsql database: format: CSV, character encoded as UTF8

   650) this.width=650; "title=" Ww.png "src=" http://s3.51cto.com/wyfs02/M02/75/13/wKioL1Yx_HCRcBnQAAD4JOo_H1w851.jpg "alt=" Wkiol1yx_hcrcbnqaad4joo_h1w851.jpg "/>

This article from the "Desert oo Eagle" blog, reproduced please contact the author!

Postgresql Import Chinese Table method