Questions tagged [unaccent]
The unaccent tag has no usage guidance.
15 questions
3
votes
1
answer
311
views
PostgreSQL unaccent and full text search for Arabic/Persian
I'm using an application that uses PostgreSQL as its database and it uses the unaccent extension to normalize text.
I want to improve its search functionality by modifying the unaccent.rules file.
I ...
0
votes
3
answers
669
views
Remove spaces and replace characters with regexp_replace()
I wish to ...
... remove spaces
... delete apostrophes
... replace 'é' and 'è' with 'e'
I use the function regexp_replace().
For the moment, I can delete the spaces but poorly. Indeed, when the ...
- 125
0
votes
2
answers
424
views
PostgreSQL's unaccent function is unable to remove accents (diacritic signs) from Japanese characters like 'ド'
The postgresql out of box unaccent function is unable to remove accents (diacritic signs) with more then one diacritic in a character. The character 'ド' which is failing for normalisation have 2 ...
2
votes
0
answers
435
views
Postgresql full text search without diacritics (effective unaccent)
I've similliar question as Postgres full text search with unaccent and inflection (conjugation, etc.) .
I want to use FTS but in "unaccent" mode. I'll explain with the example. The "...
- 21
3
votes
1
answer
4k
views
"Function unaccent(text) does not exist" in update trigger
I've created a trigger for table x1 to update a column y with the expression to_tsvector(unaccent(x1.col1 || ' ' || x2.col1)). This trigger function throws:
function unaccent(text) does not exist
...
- 132
3
votes
1
answer
2k
views
Trigram similarity (pg_trgm) with German umlauts
I try to figure out how to improve Postgres 10.6 pg_trgm queries with German umlauts (äöü). In german 'ö' can be written as 'oe'. But beware: not every 'oe' can be written as 'ö'.
CREATE TABLE public....
- 143
3
votes
1
answer
5k
views
'text search dictionary "unaccent" does not exist' entries in postgres log, supposedly during automatic analyze
I have many such entries in the postgresql main log, ever since upgrading to Postgres 10:
2018-03-28 08:51:00.281 CEST [97547] ERROR: text search dictionary "unaccent" does not exist
2018-03-28 08:...
- 901
2
votes
1
answer
576
views
Custom unaccent rules in heroku
We have an application running in heroku and we want to add a search feature on a field that contains greek characters and we want to make it accent agnostic.
So the idea is to use postgresql's ...
- 123
6
votes
1
answer
12k
views
Creating a case-insensitive and accent/diacritics insensitive search on a field
I would like to know if it makes sense to create an index combining two functions while using Full Text Search: lower(name) and f_unaccent(name) Where f_unaccent is just my wrapper to make unaccent ...
- 63
6
votes
2
answers
5k
views
Postgres full text search with unaccent and inflection (conjugation, etc.)
I want to be able to search unaccented phrases in an inflected (Polish) language in Postgres.
Say, if a document contains robiłem, the lexeme should be robić (the infinivite). Its forms are robię, ...
- 61
1
vote
3
answers
1k
views
How to speed up string cleanup function?
I need to cleanup a string, so that certain ASCII code characters are left out of the string, and others are replaced.
I am new to Postgres. My function ufn_cie_easy() performs way too slow:
DECLARE
...
- 11
2
votes
1
answer
3k
views
PostgreSQL translate special characters?
Description:
PostgreSQL 9.3
String: 'ì ằ ú ề'
Desired Result: 'i a u e'
My code:
select translate ('ì ằ ú ề', 'ìằúề', 'iaue') ; -- it works. Result: i a u e
Question:
If I use it this way, I ...
- 2,002
6
votes
1
answer
23k
views
'ERROR: text search dictionary "unaccent" does not exist' during CREATE INDEX?
I'm running PostgreSQL 9.3 on Mac OS X Yosemite.
I try to create an unaccent lowercase trigram index. To achieve it I did this:
mydb=# CREATE EXTENSION pg_trgm SCHEMA public VERSION "1.1";
...
3
votes
1
answer
2k
views
Error during pg_restore: text search dictionary "unaccent" does not exist
I'm trying to move data between servers. I recreated the whole database structure, checked that same users exist and the unaccent extension that we use is enabled for all schemas of the target ...
- 181
3
votes
3
answers
4k
views
How to query efficiently from Postgres to select special words?
Let's say that I have a table called words with very many records.
Columns are id and name.
In the words table I have for example:
'systematic', 'سلام','gear','synthesis','mysterious', etc.
NB: ...
- 3,666