“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. IndexError: too many indices for array
  12. Writing a pandas DataFrame to CSV file
  13. PostgreSQL: Show tables in PostgreSQL
  14. What is this JavaScript “require”?
  15. IndexError: too many indices for array
  16. What is this JavaScript “require”?
  17. Pandas: ValueError: cannot convert float NaN to integer
  18. Psql could not connect to server: No such file or directory, 5432 error?
  19. Python – Reading and writing csv files with utf-8 encoding
  20. Invalid column count in CSV input on line 1 Error
  21. load csv into 2D matrix with numpy for plotting
  22. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  23. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  24. Parsing a comma-delimited std::string
  25. Difference between writerow() and writerows() methods of Python csv module
  26. What is the default password for Postgres
  27. ValueError: cannot index with vector containing NA / NaN values
  28. ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
  29. fe_sendauth: no password supplied
  30. Creating a dictionary from a csv file?
  31. missing FROM-clause entry for table
  32. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  33. Reading CSV file and storing values into an array
  34. Writing data into CSV file in C#
  35. Create mysql table directly from CSV file using the CSV Storage engine?
  36. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  37. Postgresql tables exists, but getting “relation does not exist” when querying
  38. No function matches the given name and argument types
  39. PostgreSQL error: Fatal: role “username” does not exist
  40. Writing a dictionary to a csv file with one line for every ‘key: value’
  41. psql: command not found Mac
  42. pg_ctl: no database directory specified and environment variable PGDATA unset
  43. Postgres Error: More than one row returned by a subquery used as an expression
  44. Example JavaScript code to parse CSV data
  45. c++ reading csv file
  46. Bulk load data conversion error (truncation)
  47. How to exit from PostgreSQL command line utility: psql
  48. AttributeError: ‘float’ object has no attribute ‘split’4
  49. How to add pandas data to an existing csv file?
  50. PHP to write Tab Characters inside a file?
  51. How can I output MySQL query results in CSV format?
  52. PostgreSQL create table if not exists
  53. importing a CSV into phpmyadmin
  54. Dump all tables in CSV format using ‘mysqldump’
  55. Response Content type as CSV
  56. JavaScript array to CSV
  57. PostgreSQL visual interface similar to phpMyAdmin?
  58. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  59. GROUP BY and COUNT using ActiveRecord
  60. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  61. How to read a CSV file from a URL with Python?
  62. Export data as CSV in back end with proper HTTP headers
  63. Using a database view = evil incarnate?
  64. Woocommerce – Hide “add to cart” on free products
  65. file_exists() acting weird
  66. Best practice for adding posts in bulk
  67. Why is file_get_contents returning page source?
  68. Exporting table to csv works in the admin but exports HTML data when used on the front end
  69. code is working properly in Core PHP but writing coding in WordPress
  70. How do I update a field of a meta box?
  71. How to Upload CSV Data into Custom Post Type Data with Metabox programmatically
  72. How to make a wordpress site multilingual by uploading a translated CSV file that has the traslations?
  73. How to export custom database data to excel file
  74. Huge category CSV import does not work
  75. Pulling Data from CSV vs. pulling data from database
  76. WordPress CSV Importer takes a long time to finish
  77. Creating a CSV with PHP inside the plugin directory
  78. get csv of users with user_meta
  79. Can’t upload CSV file to plugin directory using custom upload form in admin panel
  80. Can export gallery but can’t import it Wp all import
  81. How to download CSV from sub directory in uploads folder
  82. Custom database table and custom search
  83. Upload advanced custom field text link array with csv
  84. Creating categories while importing via CSV
  85. How to map data on CSV to web pages?
  86. Imported posts for cpt are imported as scheduled, not published [SOLVED]
  87. Force CSV download with template_redirect
  88. Extracted CSV as Array for Custom Query Loop
  89. Issue: CSV file upload works only when “View page source” is done
  90. WooCommerce – Adding Product Attributes to CSV Export
  91. Create csv file in plugin
  92. How to cdv from a custom CMS to WP
  93. Create CSV for import from File directories?
  94. CSV file header
  95. Reading csv from specific directory and insert it to custom post type (cron job)
  96. Exporting CSV of users with custom user taxonomies out of WordPress
  97. Postgres equivalent to MySQL’s \G?
  98. pg_dump and pg_restore: input file does not appear to be a valid archive
  99. Creating posts with php-script + csv
  100. How to set an exact search box in tablepress plug-in

Leave a Comment