« Return to Thread: Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?

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

by Netzmeister :: Rate this Message:

Reply to Author | View in Thread

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

 « Return to Thread: Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?