Re: Problems when using unaccent

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jansenmauro(at)gmail(dot)com
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Problems when using unaccent
Date: 2024-01-02 16:43:59
Message-ID: 4097926.1704213839@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

PG Doc comments form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2024-01-02 22:59:31 incorrect description of Python try / except
Previous Message PG Doc comments form 2024-01-02 04:12:30 Problems when using unaccent