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

From: ANdreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
To: J(dot)Kraaijeveld(at)Askesis(dot)nl, pgsql-general(at)postgresql(dot)org
Subject: Re: Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?
Date: 2009-07-03 19:24:38
Message-ID: 4A4E5AF6.2070209@netzmeister-st-pauli.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2009-07-03 19:46:50 Re: Store derived data or use view?
Previous Message David Fetter 2009-07-03 18:29:45 Re: Q: data modeling with inheritance