Re: Problems when using unaccent

PG Doc comments form <noreply@postgresql.org> writes:
> I'm trying to query a database with unaccent, but PostgreSQL gives me
> exceptions:

> ERROR:  function unaccent(character varying) does not exist at character
> 139

It looks like you haven't installed the unaccent extension in that
database.  See

https://www.postgresql.org/docs/current/contrib.html

            regards, tom lane