postgres=# postgres=# SELECT btrim('123example 332', '123') AS trim_numbers; trim_numbers -------------- example (1 row) postgres=#