Changes between Initial Version and Version 1 of Ticket #4654
- Timestamp:
- May 4, 2012, 7:02:54 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #4654 – Description
initial v1 1 1 Data exported from R (and others I'm sure), will often contain a null column name over an ID column. Something like, 2 2 3 "", "Name","Species", "Geom" 4 1, "Boxelder", "Acer negundo", "some geom" 5 2, "Juneberry", "Amelanchier arborea", "some geom" 3 "", "Name","Species", "Geom"[[BR]] 4 1, "Boxelder", "Acer negundo", "some geom"[[BR]] 5 2, "Juneberry", "Amelanchier arborea", "some geom"[[BR]] 6 6 7 7 These files are imported to PostgreSQL (via -f "PostgreSQL") incorrectly. The data are shifted over one column, and one column is dropped. Alternatively, in the quoted example above, even a space will make the file work correctly, 8 8 9 " ", "Name","Species", "Geom" 10 1, "Boxelder", "Acer negundo", "some geom" 11 2, "Juneberry", "Amelanchier arborea", "some geom" 9 " ", "Name","Species", "Geom"[[BR]] 10 1, "Boxelder", "Acer negundo", "some geom"[[BR]] 11 2, "Juneberry", "Amelanchier arborea", "some geom"[[BR]] 12