to_number('123,456,789.00', '999G999G999D99')
postgres=# SELECT to_number('123,456,789.00', '999G999G999D99') AS formatted; formatted -------------- 123456789.00 (1 row) postgres=#