How to solve issue when extensions aren't in public
archlemon opened this issue · 0 comments
archlemon commented
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;