PostgreSQL Full-Text index

--Add a full-text index field and create a trigger--ALTER TABLE keyword add COLUMN tsv tsvector;--Create or Replace function keyword_ts_trigger_function () returns trigger as $$--begin--New. Keyword_participle: = To_tsvector ('English_nostop', COALESCE (New. keyword,"') );--return New;--End--$$ language plpgsql;-- --CREATE TRIGGER Messages_ts_trigger--before insert--On keyword-- forEach row--Execute procedure keyword_ts_trigger_function ();--Create an index--CREATE INDEX keyword_full_text_index on keyword--usingGin (To_tsvector ('English_nostop', keyword));
--Update The field you just created
--

Reference article:

Https://stackoverflow.com/questions/1497895/can-i-configure-stop-words-programmatically-with-postgresql-full-text-search

Https://www.youtube.com/watch?v=LS6kF43DEt8

PostgreSQL Full-Text index