Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Find my Postgres text search dictionaries

Tags:

postgresql

I created a thesaurus for full text search a few months back. I just recently added some entries, and (I think) I update it like this:

ALTER TEXT SEARCH CONFIGURATION english
    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart
    WITH [my_thesaurus], english_stem;

However, I don't actually don't remember what my thesaurus was called. How can I figure this out?

like image 805
Theron Luhn Avatar asked Feb 17 '13 02:02

Theron Luhn


1 Answers

You may find it in the output of:

SELECT dictname FROM pg_catalog.pg_ts_dict;
like image 51
Daniel Vérité Avatar answered Sep 18 '22 10:09

Daniel Vérité