DEV Community

Jeevachaithanyan Sivanandan
Jeevachaithanyan Sivanandan

Posted on

postgresql : search full text inside a table

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

Top comments (0)

Billboard image

Create up to 10 Postgres Databases on Neon's free plan.

If you're starting a new project, Neon has got your databases covered. No credit cards. No trials. No getting in your way.

Try Neon for Free →

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay