to_number('$2,900.00', 'L9G999D99')
postgres=# SELECT to_number('$2,900.00', 'L9G999D99') postgres-# AS monetary; monetary ---------- 2900.00 (1 row) postgres=#