test=# select regexp_replace('asssadddv', E'(.)\\1+', E'\\1', 'g'); regexp_replace ---------------- asadv (1 row)