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!
- Can't drop role because it has privileges that are not revoked even when REVOKE statement is successful
- How to transfer string from one column to another if it doesn’t contains substring
- How to use uuid with postgresql gist index type?
- How to format date if it can be null spring
- Postrgres Regex to replace part of a String
- Query Condition in Laravel 5
- How to restrict RLS on certain column(s) in PostgreSQL/Supabase?
- Joining too many tables makes Postgres query extremely slow
- Laravel and PHP8.3 can't connect to Postgres database
- CASE vs Multiple UPDATE queries for large data sets - Performance
- Invalid resource manager ID in primary checkpoint record
- postgresql list and order tables by size
- PgAdmin 4: Cannot edit rows from one table
- Add PRIMARY KEY constraint to existing table
- Count of available items with start and end dates grouped by month
- Hibernate mapping between Postgres array of varchar and a Java/Kotlin collection of enum
- Correct way to install psql without full Postgres on macOS?
- Why pg_typeof(TIMESTAMP '2004-10-19 10:23:54+02') shows timestamp without time zone
- "extra data after last expected column" while trying to import a csv file into postgresql
- Postgres - using select statement inside CASE WHEN
- How to split events into periods of activity in postgres?
- Streak for a given endDate SQL (Postgres)
- How to set a timestamptz column in postgres to a range of values to simulate real world data?
- Why is string literal '2021-02-16 09:00' without timezone information interpreted as `timestamp with time zone` with AT TIME ZONE?
- Postgres won't accept table alias before column name
- Named argument passed as a dict: SyntaxError: syntax error at or near "%" or SyntaxError: type modifiers must be simple constants or identifiers
- pg_cron - can not query cron.job after job is scheduled
- PostgreSQL Selecting Most Recent Entry for a Given ID
- Difference between timestamps with/without time zone in PostgreSQL
- connect superset to postgresql in a docker container - The port is closed