在Windows Postgresql中生成uuid [英] Generate uuid in windows postgresql

问题描述

我在Windows上安装了Postgresql 9，但没有内置uuid生成器。有OSSD程序包，可以将它作为uuid生成器绑定到postgresql，但它仅适用于* nix（我认为）。

I have a postgresql 9 installation on windows, which doesn't have built in uuid generator. There is OSSD package, which can be bound to postgresql as uuid generator, but it's for *nix only (I think).

如何在Windows postgresql中生成uuid？

How can I generate uuid in windows postgresql?

推荐答案

EnterpriseDB的一键式安装程序确实具有该功能。该DLL称为 uuid-ossp.dll，位于（Postgres的安装目录）\lib中，而安装SQL脚本称为 uuid-ossp.sql，并且位于（Postgres的安装目录）＼中＼share\contrib。您必须执行所选数据库中的最后一个。

The one-click installer from EnterpriseDB does have it. The DLL is called "uuid-ossp.dll" and resides in "(Postgres' installation directory)\lib" and the installation SQL script is called "uuid-ossp.sql" and resides in "(Postgres' installation directory)\share\contrib". You have to execute the last one in the DB of your choice.

这篇关于在Windows Postgresql中生成uuid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！