[GRASS-user] reorder columns in vector attribute table

[Stefan Blumentrath]

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 <grass-user-bounces at lists.osgeo.org> On Behalf Of Veronica Andreo
Sent: onsdag 23. mai 2018 12.12
To: grass-user <grass-user at lists.osgeo.org>
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20180523/ec2e2e66/attachment.html>