Обсуждение: Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?

Hi,

Is it possible to get an overview/the contents of the stopwords list,
dictionary, synonyms or thesaurus using an SQL query, e.g. "SELECT *
from stopwords"?

Is it possible to add or remove entries from the dictionaries using SQL?

TIA

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

Joost Kraaijeveld wrote:
> Hi,

Hi,

> Is it possible to get an overview/the contents of the stopwords list,
> dictionary, synonyms or thesaurus using an SQL query, e.g. "SELECT *
> from stopwords"?

if I understand correctly, you want to see the content of the
dictionarys. No - you can't see the entries with SQL because the data is
not stored in the database but in files. Usually you can find the files  in

/usr/share/postgresql/8.x/tsearch_data/

or

/usr/local/share/postgresql/8.x/tsearch_data/

> Is it possible to add or remove entries from the dictionaries using SQL?

see above ...

> TIA

Cheers

Andy