pattern matching in postgresql

Question

I need to substring "test" from my variable "5.myname (test)" in postgresql I am able to extract number[i.e 5] and text [i.e myname] from above string but unable to extract test. can anyone please suggest pattern to extract test from above string.

put your attempts to the question please

Vao Tsun
– Vao Tsun

2017-04-26 12:45:25 +00:00
Commented Apr 26, 2017 at 12:45 — Vao Tsun
– Vao Tsun, Commented Apr 26, 2017 at 12:45

Laurenz Albe · Accepted Answer · 2017-04-26 12:51:21Z

1

SELECT substring('5.myname (test)' from '\((.*)\)');

answered Apr 26, 2017 at 12:51

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

pattern matching in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related