[GENERAL] Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?

[Joost Kraaijeveld]

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



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?

[ANdreas Wenk]

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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general