Implement full-text search in PostgreSQL via Sequelize, searching across join table fields, supporting start, end, and middle substring searches
I’m new to PostgreSQL and Sequelize. I need to implement a global search in my user table. Users are linked with userAddress, userEducation, and userProfession tables using a hasMany relation. I want to perform a full-text search using Sequelize and PostgreSQL that searches in the user table and all joined tables. The search must support starting with, ending with, and middle substring searches.