I am working in spatialite which is basically sqlite3 and would like to use ".mode column" when I SELECT data FROM my tables. However each attribute is getting printed twice.
Working modes: e.g. tcl and csv (all other modes than column work)
spatialite> .mode tcl
spatialite> select * from footprints;
"id"|"cal_date"|"sat_type"|"scene"|"geom"|
"1"|"151209"|"landsat8"|"p29r122"|""|
"2"|"151207"|"landsat8"|"p47r120"|""|
spatialite> .mode csv
spatialite> select * from footprints;
id,cal_date,sat_type,scene,geom
1,151209,landsat8,p29r122,
2,151207,landsat8,p47r120,
Not working mode: column
spatialite> .mode column
spatialite> select * from footprints;
id cal_date sat_type scene geom
---------- ---------- ---------- ---------- ----------
1 1 151209 151209 landsat8 landsat8 p29r122 p29r122
2 151207 151207 landsat8 landsat8 p47r120 p47r120
spatialite>
What can I do to fix this? By the way I have ".headers on"
Aucun commentaire:
Enregistrer un commentaire