How to solve issue when extensions aren't in public

[archlemon]

To fix the issue where your pgcrypto extension is install in a different schema to public, you can create an alias function; replacing YOUR_SCHEMA with the schema you've installed the extension into.

create function public.gen_random_uuid() returns uuid as $$
  select YOUR_SCHEMA.gen_random_uuid();
$$ language sql;