[code] select trim(both ’ ’ from to_char(12345678.49, ‘999,999,999.99’)) [/code]

The trim is to take away the white space from the sides.

Ref: https://www.postgresql.org/docs/9.6/static/functions-formatting.html