Invalid Input Syntax for Type date

[1251ila]

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!

[rski]

Writing

I am trying to import a text file into a postgres table

you mean using

copy

command?
Is any data put into table when you do the import or no?
When you say about date format, did you check it in the database using

show datestyle

command?