Re: Simple Regex question, hoping for direct answer (no Socratic approach necessary) - Mailing list pgsql-general

Postgres User wrote:
> I'm new to Regex in Postgres.  Can someone give me a quick pointer on
> how I'd SELECT the substring between   '<name>'    and  '</name>'  in
> a field?
>
> Sample field data:
> address city here <name>Rogers, Jim</name> zip code place
>
> and I'd like the SELECT to return only:
> Rogers, Jim

SELECT regexp_replace(
          'Sing along with <name>Rogers, Jim</name>',
          '.*<name>(.*?)</name>.*',
          E'\\1');

 regexp_replace
----------------
 Rogers, Jim
(1 row)

Yours,
Laurenz Albe