-
编辑 删除
PostgreSQL添加UUID功能。
d[@more@]1. 下载UUID-1.6.2.2. 下载完后在UUID-1.6.2目录中运行#./configure#make#makeinstall3. 安装POSTGRESQL3.1 在虚拟机上安装的时候，先同步一下时间。Config的时候要写进去。./configure LDFLAGS=-L/usr/local/lib --prefix=/usr/local/pg911 --with-ossp-uuid --with-libxml --with-libxslt#make#make install4. 在postgresql解压目录下，postgresql-9.1.1/contrib/uuid-ossp/#make#make install5. 在postgres用户的profile下添加LD_LIBRARY_PATH=/usr/local/lib6. 最后进psql. 运行postgres=# create extension "uuid-ossp
-
编辑 删除
postgresql copy UNICODE txt 问题。
d[@more@]从sqlserver 2005 导出的unicode的格式的txt.无法直接用copy导入到linux上的postgersql.解决办法：In adition of set the local encoding (Client and Server), if you arerunnning +nix there is a command called iconv that let you convertfrom one charset to another. Always i used it, i never had any problems.iconv -f UNICODE -t UTF-8 location.txt -o 1location.txt
