>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.
1) remove all $ characters from csv before import
OR
2) import into text field (perhaps in
On 9/13/19 11:22 AM, stan wrote:
I am trying to import some data from spreadsheets. Included in the data
What program?
Usually there is an option to save the raw values not the formatted
ones. In LibreOffice you uncheck the Save content as shown option.
sets are US monetary values. These
>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 wrote:
>
> I am trying to import some data from spreadsheet
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;
sta
