4 ms·

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.

• chromatin 5y ago
  Thank goodness with Postgres 13 the uuidv4 function got moved into core (not requiring pgcrypto installation)
  • leetrout 5y ago
    Maybe you are thinking of uuid-ossp? I'm not aware of pgcrypto being required for UUIDs.
    • chromatin 5y ago
      > If you only need randomly-generated (version 4) UUIDs, consider using the gen_random_uuid() function from the pgcrypto module instead. https://www.postgresql.org/docs/12/uuid-ossp.html https://www.postgresql.org/docs/12/uuid-ossp.html
      • leetrout 5y ago
        Ah! Well TIL. Thank you
• tragomaskhalos 5y ago
  Yeah in general any extension should go in its own schema.