---
title: "Discussion on \"Text and Pattern matching in Postgres\" | Hashnode"
description: "Discussion on \"Text and Pattern matching in Postgres\". Text matching is a pretty common problem while working with SQL. LIKE, SIMILAR TO and POSIX are pretty common querying use cases. But, taking advantage of indexes when using these is something to pay attention to. A simple b-tree index on a text/varc..."
url: "https://hashnode.com/posts/text-and-pattern-matching-in-postgres/65a95edcc5aec7b99ee29e48"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Text and Pattern matching in Postgres](https://backend.engg.wiki/text-and-pattern-matching-in-postgres?utm_source=hashnode&utm_medium=feed)

Text matching is a pretty common problem while working with SQL. LIKE, SIMILAR TO and POSIX are pretty common querying use cases. But, taking advantage of indexes when using these is something to pay attention to. A simple b-tree index on a text/varc...

Jan 18, 2024 · 7 min read · backend.engg.wiki  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#databases](https://hashnode.com/tag/databases)
-   [#indexing](https://hashnode.com/tag/indexing)

## Written by

[Pradeep Chodisetti](https://hashnode.com/@pradeepchodisetti)

@pradeepchodisetti

  
[View profile](https://hashnode.com/@pradeepchodisetti)

Lead Engineer @ Newfold (Web.com, Bluehost)

Lead Engineer @ Newfold (Web.com, Bluehost) Coding enthusiast Degree in Computer Engineering from NIT Surat Mail me: contact@pradeep.email

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
