>ERROR: invalid input syntax for type numeric: "$1.00" >CONTEXT: COPY employee, line 2, column hourly_rate: "$1.00"
Try changing the format of the column from currency to numeric BEFORE exporting. On Fri, Sep 13, 2019 at 2:22 PM stan <st...@panix.com> wrote: > > 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@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 > > > -- *Melvin Davidson* *Maj. Database & Exploration Specialist* *Universe Exploration Command – UXC* Employment by invitation only!
