Re: Howto get the contents of mystopwords/dictionary/synonym/thesaurus ? - Mailing list pgsql-general

From ANdreas Wenk
Subject Re: Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?
Date
Msg-id 4A4E5AF6.2070209@netzmeister-st-pauli.de
Whole thread Raw
In response to Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?  ("Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl>)
List 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


pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Q: data modeling with inheritance
Next
From: Martin Gainty
Date:
Subject: Re: Store derived data or use view?