首先用postgresql的用户登陆,(su - postgres) ,然后进入数据库,假设数据库名称为“house”,命令为
[postgres@ITC-S postgres]$ psql house
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.
Type: copyright for distribution terms
h for help with SQL commands
? for help with psql commands
g or terminate with semicolon to execute query
q to quit
house=#
输入encoding GBK
house=#set encoding GBK
然后就可以插入汉字了。
from: http://publish.it168.com/2006/0219/20060219173801.shtml?positioncode=1547