How to create SHA1 digest in jOOQ postgres?

Question

I need to implement the following part of the query in jOOQ digest(callables.fasten_uri, 'sha1'::text) from postgres, however, I could not find anywhere such functionality. Could someone point me to it, please?

Answer 1

PostgreSQL has hundreds of built-in functions. It wouldn't make sense to support them all in the jOOQ API. But you can work around this limitation easily in two ways:

• Use plain SQL templating
• Use code generation of the pg_catalog schema, where all these functions are stored