Search Postgresql Archives

Re: Configure StopWords in full text search without a configuration file?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 2022-11-17 at 14:30 +0100, Florian Fuchs wrote:
> is it possible to configure a StopWord list without a file in the
> configuration-filesystem of postgres?
> (StopWord: https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-STOPWORDS)

No, this is impossible.

> By default, the StopWord files are stored at  $SHAREDIR/tsearch_data/*.stop - I don't
> have access to the filesystem, so I need to configure custom StopWords
> within my database/schema (SQL-Access).
> 
> Is this somehow possible?

If you have superuser access or have a user that is a member of
"pg_write_server_files", you could write the stopword file via SQL.
Other than that, I see no possibility.

Yours,
Laurenz Albe





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux