Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy

by

Have you tried setting the datestyle setting of the server? 

SET datestyle="ISO,DMY";

You are using the psql meta-command \copy, which means the input file is local to the client. But it’s still the server who has to coerce the input to matching data-types.

More generally, unlike the psql meta-command \copy which invokes COPY on the server and is closely related to it .. I quote the manual concerning \set:

Note: This command is unrelated to the SQL command SET.

More Related Contents:

  1. PostgreSQL “DESCRIBE TABLE”
  2. How to exit from PostgreSQL command line utility: psql
  3. How to import CSV file data into a PostgreSQL table
  4. In psql, why do some commands have no effect?
  5. How do I specify a password to ‘psql’ non-interactively?
  6. Run batch file with psql command without password
  7. How to export table as CSV with headings on Postgresql?
  8. Run a PostgreSQL .sql file using command line arguments
  9. How to switch databases in psql?
  10. Permission denied for relation
  11. Postgresql: Scripting psql execution with password
  12. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  13. Generate series of dates – using date type as input
  14. Can I automatically create a table in PostgreSQL from a csv file with headers?
  15. How to make a select with array contains value clause in psql
  16. Return SETOF rows from PostgreSQL function
  17. psql: FATAL: database “” does not exist
  18. Difference between timestamps with/without time zone in PostgreSQL
  19. PostgreSQL: Why psql can’t connect to server?
  20. Use variable set by psql meta-command inside of DO block
  21. Update timestamp when row is updated in PostgreSQL
  22. Select from a table variable
  23. Alternate output format for psql showing one column per line with column name
  24. Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
  25. PostgreSQL disable more output
  26. PostgreSQL – set a default cell value according to another cell value
  27. now() default values are all showing same timestamp
  28. psql: FATAL: Ident authentication failed for user “postgres”
  29. Custom ORDER BY Explanation
  30. About clustered index in postgres

Leave a Comment