jeudi 4 février 2016

Column mode in sqlite3/spatialite printing data twice. (Other display modes working fine)

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