环境:
postgresql9.3, navicat premium.
选中某一数据库
新建 '查询', 运行:
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
3. 运行
select uuid_generate_v4()
4. 查看安装的扩展:
SELECT * FROM pg_extension;
参考: http://stackoverflow.com/questions/12505158/generating-a-uuid-in-postgres-for-insert-statement