Update:

I installed the latest version of PostgreSQL on my machine and now this is working:

CREATE EXTENSION pgcrypto;
select gen_random_uuid();

The older version below is less secure so should be avoided.

This is just a little thing for me because I keep hitting this - for whatever reason the way recommended by the docs to generate a UUID in Postgresql just isn't working for me, but this is: create extension "uuid-ossp"; select uuid_generate_v1mc() So there you go.