I used this code when creating the table: CREATE TABLE box_office( movie_id INTEGER PRIMARY KEY, international_box_office FLOAT, domestic_box_office FLOAT, worldwide_box_office FLOAT, production_budget FLOAT );
After, I wanted to import the table but got this error: ERROR: invalid input syntax for type double precision: " $4.604.101,00 " CONTEXT: COPY box_office, line 2, column international_box_office: " $4.604.101,00 "
Any ideas? Thanks!