Postgres function works in pgAdmin but not via JDBC

182 views Asked by At

I have installed the PostgreSQL pg_simialrity extension as described here so that I can use the jarowinkler function. The function works perfectly in pgAdmin but not via Spring JDBC. When executed via JDBC this error is reported

org.postgresql.util.PSQLException: ERROR: function jarowinkler(text, text) does not exist

Does anyone know what needs to be done to fix this problem? I am using PostgreSQL 14.0, Java 8, Spring JDBC 4.3.25.RELEASE and PostgreSQL JDBC Driver 42.2.23

Thanks.

0

There are 0 answers