my command is
\copy meta.amz_payment1("Date", settlement_id, type, order_id, sku,
description, quantity, marketplace, fulfillment, order_city, order_state,
order_postal, product_sales, shipping_credits, promotional_rebates,
sales_tax_collected, selling_fees, fba_fees, other_transaction_fees,other, total)
from '/Users/manish/Downloads/amz.csv' delimiter ',' csv header
but it gives following error :
ERROR: invalid input syntax for type numeric: "-8,791.41" CONTEXT: COPY amz_payment1, line 23, column total: "-8,791.41"