SQL · Regular expressions and text search

to_tsvector()

Builds a searchable text vector. PostgreSQL full-text search.

sqlRunnable example sql course

Syntax

to_tsvector(config, text)

Example

Open in the lab

-- PostgreSQL
-- SELECT to_tsvector('english', 'Learn CSS layout');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.