The following table shows the ODBC SQL data types to which numeric C data may be converted. For an explanation of the columns and terms in the table, see Converting Data from C to SQL Data Types.
ALTER COLUMN balance TYPE NUMERIC(20,8) USING balance::NUMERIC, ALTER COLUMN total_purchased TYPE NUMERIC(20,8) USING total_purchased::NUMERIC, ALTER COLUMN total ...