I am trying to import some data from spreadsheets. Included in the data
sets are US monetary values. These appear in the CSV file, like this: $1.00
The column is defined like this: NUMERIC(5,2) NOT NULL. When I try to
import this data using the \copy functionality, i get the following error;
stan(at)smokey:~/pm_db/live_data$ psql < import_employee.sql
ERROR: invalid input syntax for type numeric: "$1.00"
CONTEXT: COPY employee, line 2, column hourly_rate: "$1.00"
How can I work around this?
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin