“extra data after last expected column” while trying to import a csv file into postgresql

Now you have 7 fields.

You need to map those 6 fields from the CSV into 6 fields into the table.

You cannot map only 3 fields from csv when you have it 6 like you do in:

\COPY agency (agency_name, agency_url, agency_timezone) FROM 'myFile.txt' CSV HEADER DELIMITER ',';

All fields from the csv file need to to be mapped in the copy from command.

And since you defined csv , delimiter is default, you don’t need to put it.

Related Posts:

  1. Is there a way to include commas in CSV columns without breaking the formatting?
  2. Python Pandas Error tokenizing data
  3. python csv2libsvm.py: AttributeError: ‘_csv.reader’ object has no attribute ‘next’
  4. In Java, what is the “char” for a tab and how do I pass through a “Charset”?
  5. How to parse tsv file with python?
  6. PG COPY error: invalid input syntax for integer
  7. WordPress.com Stats stats_get_csv with custom field?
  8. How to import .csv file with descriptions to a gallery in media?
  9. Updating Custom Posts via CSV Import
  10. CSV import stopped working when I upgraded to WP 3.5.2
  11. TypeError: list indices must be integers or slices, not str
  12. IndexError: too many indices for array
  13. IndexError: too many indices for array
  14. Writing a pandas DataFrame to CSV file
  15. Writing a pandas DataFrame to CSV file
  16. PostgreSQL: Show tables in PostgreSQL
  17. What is this JavaScript “require”?
  18. IndexError: too many indices for array
  19. ValueError : I/O operation on closed file
  20. What is this JavaScript “require”?
  21. PostgreSQL “DESCRIBE TABLE”
  22. Pandas: ValueError: cannot convert float NaN to integer
  23. csv.Error: iterator should return strings, not bytes
  24. Psql could not connect to server: No such file or directory, 5432 error?
  25. Yahoo! Finance CSV file will not return Dow Jones (^DJI)
  26. Python – Reading and writing csv files with utf-8 encoding
  27. Invalid column count in CSV input on line 1 Error
  28. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  29. Invalid column count in CSV input on line 1 Error
  30. How to restart Postgresql
  31. Python Error io.UnsupportedOperation: not readable
  32. load csv into 2D matrix with numpy for plotting
  33. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  34. Dump a NumPy array into a csv file
  35. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  36. How to parse a CSV file using PHP
  37. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  38. How to load a tsv file into a Pandas DataFrame?
  39. Parsing a comma-delimited std::string
  40. What is the format for the PostgreSQL connection string / URL?
  41. Difference between writerow() and writerows() methods of Python csv module
  42. Create a .csv file with values from a Python list
  43. Convert XML to CSV file
  44. TypeError: list indices must be integers or slices, not str
  45. What is the default password for Postgres
  46. “use database_name” command in PostgreSQL
  47. Postgresql 9.2 pg_dump version mismatch
  48. Convert from CSV to array in Python
  49. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  50. psql: FATAL: Ident authentication failed for user “postgres”
  51. ValueError: cannot index with vector containing NA / NaN values
  52. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  53. ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
  54. fe_sendauth: no password supplied
  55. Creating a dictionary from a csv file?
  56. How can I import an Excel file into SQL Server?
  57. Python import csv to list
  58. missing FROM-clause entry for table
  59. How can I drop all the tables in a PostgreSQL database?
  60. How to restart PostgreSQL in Ubuntu 18.04
  61. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  62. ValueError: x and y must be the same size
  63. PostgreSQL: Remotely connecting to Postgres instance using psql command
  64. Simple Random Samples from a Sql database
  65. Insert text with single quotes in PostgreSQL
  66. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  67. Reading CSV file and storing values into an array
  68. Postgresql: Scripting psql execution with password
  69. OSError: Initializing from file failed on csv in Pandas
  70. How to concatenate text from multiple rows into a single text string in SQL Server
  71. append new row to old csv file python
  72. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  73. Cannot simply use PostgreSQL table name (“relation does not exist”)
  74. Writing data into CSV file in C#
  75. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  76. postgresql duplicate key violates unique constraint
  77. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  78. Create mysql table directly from CSV file using the CSV Storage engine?
  79. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  80. could not connect to server: No such file or directory (PG::ConnectionBad)
  81. How to change PostgreSQL user password?
  82. Postgresql tables exists, but getting “relation does not exist” when querying
  83. No function matches the given name and argument types
  84. c++ Read from .csv file
  85. PG::ConnectionBad: fe_sendauth: no password supplied
  86. PostgreSQL error: Fatal: role “username” does not exist
  87. postgresql: error duplicate key value violates unique constraint
  88. Writing a dictionary to a csv file with one line for every ‘key: value’
  89. psql: command not found Mac
  90. pg_ctl: no database directory specified and environment variable PGDATA unset
  91. Python CSV error: line contains NULL byte
  92. psql: FATAL: role “postgres” does not exist
  93. Postgres Error: More than one row returned by a subquery used as an expression
  94. Example JavaScript code to parse CSV data
  95. c++ reading csv file
  96. PostgreSQL: Query has no destination for result data
  97. Bulk load data conversion error (truncation)
  98. Python CSV Error: sequence expected
  99. How to change PostgreSQL user password?
  100. How to exit from PostgreSQL command line utility: psql

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)