psql 9.5: gen_random_uuid() not working?
ERROR: function gen_random_uuid() does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
you can check if the functions are defined using:
select * from pg_proc where proname like ‘gen_random_%’;
if both functions are not defined then you probably had an error with the extension creation – just drop it and recreate:
CREATE EXTENSION pgcrypto;