Does Postgres (or a Postgres extension) have a uuid v5 function (ie one that takes in a UUID name space and a string to produce a new UUID)?
If not a native function, how would one write this function?
Asked
Active
Viewed 2,864 times
6
-
How is UUID v5 defined? – Laurenz Albe Sep 27 '18 at 02:39
1 Answers
6
Yes, uuid-ossp module provides such function.
uuid_generate_v5(namespace uuid, name text)
This function generates a version 5 UUID, which works like a version 3 UUID except that SHA-1 is used as a hashing method. Version 5 should be preferred over version 3 because SHA-1 is thought to be more secure than MD5.
Community
- 1
- 1
Łukasz Kamiński
- 5,630
- 1
- 19
- 32