CODEWITHSUNDEEP
postgresqluuid
Endy Tjahjono
Endy Tjahjono

Reputation: 24450

Generate uuid in windows postgresql

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).

How can I generate uuid in windows postgresql?

Upvotes: 7

Views: 7565

Answers (3)

Lewis Nakao
Lewis Nakao

Reputation: 7362

On windows, I did the following to generate UUIDs:

Log into the server using this command on Command Prompt:

psql -U postgres

This is basically accessing PostgreSQL as root.

Then select the database you want this function to be available in:

postgres=# \c <name of database>

Then execute the following:

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

Then test by immediately executing:

SELECT uuid_generate_v4();

I recommend you review the uuid-ossp documentation on the available UUID functions.

Upvotes: 2

Milen A. Radev
Milen A. Radev

Reputation: 62563

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.

Upvotes: 15

Frank Heikens
Frank Heikens

Reputation: 126971

The uuid-ossp-module in the contrib, does work on Windows XP 32 bits. The 64 bits version is not available yet, the OSSP UUID library project has to fix this problem.

Upvotes: 3

Related Questions