Hacker News Reader

In example pgcrypto extension has a lot of functions, if you have more stored functions it might be worth to install pgcrypto in dedicated schema.

Thank goodness with Postgres 13 the uuidv4 function got moved into core (not requiring pgcrypto installation)

Maybe you are thinking of uuid-ossp? I'm not aware of pgcrypto being required for UUIDs.

> If you only need randomly-generated (version 4) UUIDs, consider using the gen_random_uuid() function from the pgcrypto module instead.

Ah! Well TIL. Thank you

Yeah in general any extension should go in its own schema.