Ciao Vero, Unfortunately, it seems you have to create a new table with desired column order, copy data into it (INSERT INTO FROM SELECT) and then link the new table to your vector map (v.db.connect)…: https://stackoverflow.com/questions/20574113/sqlite3-how-to-reorder-columns-in-a-table
Note that SQLite will launder column names to lower case if you don`t quote them. Then they may not match even if in proper order (speculating here)… Cheers Stefan From: grass-user <[email protected]> On Behalf Of Veronica Andreo Sent: onsdag 23. mai 2018 12.12 To: grass-user <[email protected]> Subject: [GRASS-user] reorder columns in vector attribute table Hi all, I want to use v.patch -e to patch geometries and attributes of polygon maps belonging to different states in Australia and the column names in the attr tables are the same (they only vary in the order in which they are) but when making an attempt, I get: v.patch -e input=act_bushfire_2012_2017,tas_bushfire_2012_2017 output=test ERROR: Column names differ Column names here: v.db.select tas_bushfire_2012_2017 | head cat|FIRE_TYPE|OBJECTID|START_DATE|END_DATE|STATE|AREA_ha|PERIMETER_km v.db.select act_bushfire_2012_2017 cat|OBJECTID|FIRE_TYPE|START_DATE|END_DATE|STATE|AREA_ha|PERIMETER_km only OBJECTID and FIRE_TYPE are shifted. Is there an easy way to reorder columns in the attribute table of a vector map?? I thought v.patch would match column names in the attr table... Thanks much in advance, Vero
_______________________________________________ grass-user mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/grass-user
