Postgresql regex to return multiple values

I have a scenario in postgres where I need to gather all entries between multiple sets of square brackets.

The following example would be what I would expect to capture this:

SELECT (regexp_matches('Hello [World] How [Are] You','[(.*?)]')) 

But this simply returns


ignoring the second [Are] section.

In a regular regex this seems to work, so I’m unsure as to why its failing here.

Ideally, I would like to return the result as as csv text string.


but I can’t seem to find the right query to do this.

Any input appreciated. Thanks.

Source: regex

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.