postgresql : search full text inside a table

Jeevachaithanyan Sivanandan - Jan 3 - - Dev Community

Hi,
If you want to search a string "hello" inside a table in a postgres database, try running the snippet below

SELECT * FROM website WHERE to_jsonb(website)::text ILIKE '%hello%';

make sure that you are connected to the database already

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .