Invalid Input Syntax for Type Date

debugcn Published at Dev

Xkid

I'm triying to load data to PosgreSQL Data Base remotly by command Line in CMD, copying data from CSV file to a specific Table. It was working well but, somehow when I try to load data now, CMD throws me this error

Curiously CSV file has the "fecha_carga" field in date type as well is in the table storage in Data Base in this way, here is my try:

psql -h suggestedorder.postgres.database.azure.com -d DataAnalytics -U dev_ext@suggestedorder -c "TRUNCATE planning.env_cat_bloqueados" -c "\copy planning.env_cat_bloqueados (key, bloqueado, fecha_carga)from 'C:\Users\geradiaz.MODELO\Desktop\Envase\Catalogos\Outputs_Catalogos\Catalogo_Bloqueados\Catalogo_Bloqueados_Output.csv'with delimiter as ','

Can someone explain me what is happening here? and how could I fixed it up?

Best regards and thanks!

Xkid

The @Adrian Klaver comment gave me the idea what was wrong with my command line, in effect the fields on my CSV file was taking as data, so I changed the command line specifying that my CSV file has headers by using the next instruction at the end instead with delimiter as ',' :

with (format csv, header)

So, this is the whole command line:

psql -h suggestedorder.postgres.database.azure.com -d DataAnalytics -U dev_ext@suggestedorder -c "TRUNCATE planning.env_cat_bloqueados" -c "\copy planning.env_cat_bloqueados (key, bloqueado, fecha_carga)from 'C:\Users\geradiaz.MODELO\Desktop\Envase\Catalogos\Outputs_Catalogos\Catalogo_Bloqueados\Catalogo_Bloqueados_Output.csv'with (format csv, header)

Thanks!

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-04-7

Comments

0 comments

From Dev

Related Related

Article

Invalid Input Syntax for Type Date

Invalid Input Syntax for Type Date

Invalid input syntax for type date: "\N" in postgresql when fetching data

ActiveRecord::StatementInvalid (PG::InvalidDatetimeFormat: ERROR: invalid input syntax for type date: ""

Invalid input syntax for type interval

PostgreSQL - Error: "invalid input syntax for type bytea"

"invalid input syntax for type numeric" for entering "emptyness"

Invalid input syntax for type double precision

rails postgres ERROR: invalid input syntax for type double precision

Postgres COPY FROM Fails With invalid input syntax for type timestamp

rails postgres ERROR: invalid input syntax for type double precision

pg nodejs package results in 'invalid input syntax for type json'

How to solve invalid input syntax for type double precision

Error: invalid input syntax for integer: ""

Error: invalid input syntax for integer: ""

Invalid input syntax PLPGSQL script

invalid input syntax for integer (string)

'Invalid input syntax for type inet' db error in Django app with postgres and Gunicorn+Nginx as reverse proxy

Limit a date in input type date

Input type="date" thymeleaf

Input type="date" thymeleaf

pq: invalid input syntax for integer: "$1"

DataError: (DataError) invalid input syntax for integer: "None"

"invalid input syntax for integer" when input is actually a string

AngularJS directive to prevent input of invalid date

input type=date in iOS 7

Styling input[type=date] in chrome

HTML input type=date weekdays

Styling input[type=date] in chrome

HTML input type=date weekdays

Why does DateTime.parse not recognize this invalid input as an invalid date?