Invalid Input Syntax for Type Date
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!
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!
- How to enforce uniqueness across two columns within the scope of a third?
- pg_dump and pg_restore across different major versions of PostgreSQL
- hasMany called with something that's not an instance of Sequelize.Model
- PostgreSQL unterminated quoted identifier
- Multi-row insert with pg-promise
- SQL getting the data by timestamp interval
- Insert inserted id to another table
- docker compose psql: error: FATAL: role "postgres" does not exist
- Counting business hours between timestamps
- "row is too big (...) maximum size 8160" when running "grant connect on database"
- How to cast type bytea to double precision
- Transform timestamp to local time for a given timezone during 'COPY .. TO ..'
- Better way than multiple SELECT statements?
- How to call a stored procedure(PostgreSQL) with Spring JPA?
- Why does 'now()'::timestamp return the current timestamp in PostgreSQL?
- Get TZ abbrev for given timestamp and TZ name
- Avoid checks for each row, replace query by function?
- Get average for "last month" only
- Select values in given sequential numbers
- Sum time differences across multiple timezones in PostgreSQL
- Unexpected results from SQL query with BETWEEN timestamps
- Disadvantages of using date_trunc
- Will changing column from timestamp to timestamptz lock the table?
- Subtract hours from the now() function
- Postgresql 8.4 update query syntax error in plpgsql function
- Return rows based on timestamp respective to their time zone
- time zone confusion in relational databases
- Default timestamp format and fractional seconds
- SQL in postgres convert datetime for recurring event to future datetime
- Query on a time range ignoring the date of timestamps