Luego de de nuestra prolongada recopilación de datos dimos con la respuesta este disgusto que presentan algunos de nuestros usuarios. Te brindamos la respuesta y esperamos serte de mucha apoyo.
Ejemplo 1: error: sintaxis de entrada no válida para el tipo entero: “”
ERROR: invalid input syntax for integer: ""
"" isn't a valid integer. PostgreSQL accepts unquoted blank fields as null by default in CSV, but "" would be like writing:
SELECT ''::integer;
and fail for the same reason.
If you want to deal with CSV that has things like quoted empty strings for null integers, you'll need to feed it to PostgreSQL via a pre-processor that can neaten it up a bit. PostgreSQL's CSV input doesn't understand all the weird and wonderful possible abuses of CSV.
Options include:
Loading it in a spreadsheet and exporting sane CSV;
Using the Python csv module, Perl Text::CSV, etc to pre-process it;
Using Perl/Python/whatever to load the CSV and insert it directly into the DB
Using an ETL tool like CloverETL, Talend Studio, or Pentaho KettleEjemplo 2: sintaxis de entrada no válida para el tipo entero:
app.get() method should be in sequence in manner of like i have button of sell first then firstly i have to write app.get("/sell") then app.get("/buy") hope it helps, Thanks..No se te olvide recomendar este ensayo si te valió la pena.
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)