CODE EXAMPLE FOR SQL

postgresql replace html tags from string

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