-
Book Overview & Buying
-
Table Of Contents
AI-Ready PostgreSQL 18
By :
Texts and documents have become an increasingly important part of what is stored and managed in databases. Historically, developers reverted to specialized text-search tools to extract value from that textual data. However, PostgreSQL's growing polymorphic (or multi-model) capabilities mean that developers can not only store documents in PostgreSQL but also analyze them without resorting to third-party tools.
In this chapter, we will review the text-search capabilities in PostgreSQL:
LIKEtsvector and tsquerypg_trgmThey each have different strengths and weaknesses, which make them the tool of choice for specific use cases. We will provide guidance on when to use which capability.
Your purchase includes a free PDF copy + code bundle
Your purchase...