regex - Stripping HTML tags in PostgreSQL

Question

How would you strip HTML tags in PostgreSQL such that the data inside the tags is preserved?

I found some solutions by googling it but they were striping the text between the tags too!

Answer 1

select regexp_replace(content, E'<[^>]+>', '', 'gi') from message;