How to Use regexp_matches and regexp_match in PostgreSQL

An explanation of when to use PostgreSQL's regexp_matches(), regexp_match(), and regexp_substr() functions effectively.