Find Postgres text search dictionaries

Question

I created a thesaurus for full text search a few months ago. I recently added some entries and (I think) I am updating 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 remember how my thesaurus was called. How can I figure this out?

+3

Theron luhn Feb 17 13 at 2:49 am

1 answer

Daniel Vérité · Accepted Answer · 2013-02-17T18:07:02+0000

You can find it in the output:

SELECT dictname FROM pg_catalog.pg_ts_dict;