I am trying to import a text file into a postgres table and I get the following error message:

Invalid input syntax for type date: field name

The date format is yyyy-mm-dd
So the text file has 1999-02-22 as an example

I also tried changing the date format but the error was still raised

Please help!