extract last word in postgresql using regex

Question

I have some date in rows of a table like this:

colname
-------
/test/test/value1
/test/value2
/test:code&/value3
/value4

now I want last word of each rows (which are value1, value2, value3, value4)

Ed Bangga · Accepted Answer · 2019-12-09 03:15:42Z

1

You can use regexp_replace function.

regexp_replace('/test/test/value1', '^.*/', '')

answered Dec 9, 2019 at 3:15

Ed Bangga

13k4 gold badges18 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thank you. but sounds like, in the first of pattern the ^ is not necessary.