Configure StopWords in full text search without a configuration file?
Hello Postgres Community,
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
)
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?
Thank you very much,
Regards
Florian
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