PostgreSQL: How to parse the hyphenated word?

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing a small demonstration on how to parse the hyphenated words in PostgreSQL.

Recently, I got a result set and where few columns have hyphenated words. Now, we need analysis on hyphenated words.

At first glance, it looks like string operation, but it is one type of string parsing which we can do using ts_debug.

We can use ts_debug for text Parsing.

Check the below example:

SELECT

alias

,description

,token

FROM ts_debug('yellow-red-orange');

Result:

PostgreSQL hyphenated word parsing

Apr 30, 2018Anvesh Patel