ogr2ogr will not recognise a CSV file unless it has at least one delimiter in header.

[marklit]

This was run on Ubuntu 20 LTS, PostgreSQL 15, PostGIS 3.2.1.

$ ~/duckdb_spatial/build/release/duckdb \
      -unsigned \
      census.duckdb

COPY (SELECT wkb_geometry WKT
      FROM census_2010
      ORDER BY LENGTH(wkb_geometry::text) DESC
      LIMIT 1)
TO 'out.csv' WITH (HEADER 1);

$ head -c40 out.csv 

WKT
"POLYGON ((-89.859552 30.004109, -89

$ ogr2ogr \
    -f GPKG \
    out.gpkg \
    CSV:out.csv \
    -a_srs EPSG:4326

FAILURE:
Unable to open datasource `CSV:out.csv' with the following drivers.
...
  -> `CSV'

I have to add a delimiter to the first line of the file before ogr2ogr will open it properly.

$ sed -i '1 s|$|,|' out.csv
$ ogr2ogr \
    -f GPKG \
    out.gpkg \
    CSV:out.csv \
    -a_srs EPSG:4326

[marklit]

Thank you.