The Computer Oracle

List of StopWords in Postgres 9.1

--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Popsicle Puzzles

--

Chapters
00:00 List Of Stopwords In Postgres 9.1
00:22 Accepted Answer Score 11
00:48 Answer 2 Score 4
01:05 Thank you

--

Full question
https://superuser.com/questions/479400/l...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#postgresql

#avk47


ACCEPTED ANSWER

Score 11


Look at: http://www.postgresql.org/docs/9.1/static/textsearch-dictionaries.html#TEXTSEARCH-STOPWORDS

The location of stopwords for english dictionary is: $SHAREDIR/tsearch_data/english.stop for instance: /usr/share/postgresql/9.1/tsearch_data/english.stop



ANSWER 2

Score 4


For Homebrew users on MacOS you can find the Postgres StopWord files here:

ls /usr/local/Cellar/postgresql/<%version%>/share/postgresql/tsearch_data

Alternatively the up-to-date list is available on Github:

https://github.com/postgres/postgres/tree/master/src/backend/snowball/stopwords