ERROR: invalid input syntax for type numeric (SQL)

Question

I've created a data set with Mockaroo and then added the file with cmd. But I am getting this error. ERROR: invalid input syntax for type numeric: The table definiton is this :

create table car(
id BIGSERIAL NOT NULL PRIMARY KEY,
make VARCHAR(100) NOT NULL,
model VARCHAR(100) NOT NULL,
price NUMERIC(19,2) NOT NULL);

And this is how the numeric number (price) looks like:

insert into car (id, make, model, price) values (1, 'Mercury', 'Grand Marquis', '$52656.16');

I added the cmd screen shot for you to see.

Note : the translated version of the error written in my cmd is:

ERROR: invalid input syntax for type numeric:

p.s : I tried making (19,2) to even (50,20). It did not work.

cmd

Remove the dollar sign. It is not part of a number value.

Gordon Linoff
– Gordon Linoff

2021-01-10 14:15:00 +00:00
Commented Jan 10, 2021 at 14:15 — Gordon Linoff
– Gordon Linoff, Commented Jan 10, 2021 at 14:15

Popeye · Accepted Answer · 2021-01-10 14:16:32Z

1

Your price column is numeric and data that you are entering into it is varchar('$52656.16')

Either replace '$52656.16' with numeric value 52656.16 or change price column to varchar.

answered Jan 10, 2021 at 14:16

Popeye

36k4 gold badges12 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dakon · Accepted Answer · 2022-01-02 16:42:37Z

0

If you use VARCHAR for the price column you may still get a invalid input syntax for type numeric error.

What i think you should try is changing the data sets from mockaroo by changing the money option with numbers and add the decimals (you can choose 2 decimals option) option. You should have a data set without the $ sign.

answered Jan 2, 2022 at 16:42

Dakon

112 bronze badges

1 Comment

pringi Over a year ago

This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review

Collectives™ on Stack Overflow

ERROR: invalid input syntax for type numeric (SQL)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related