[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-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[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