[GRASS-user] v.patch ERROR: Column names differ

[Craig Leat]

Philipp Steigenberger wrote:
> I had a similar problem the other day while renaming columns. As 
> Markus said its a problem that new columns are added to the right.So 
> its a little tricky to get the correct order.
> To see the current order use
> db.select sewer_MN | line
> this prints the first line of the table:
> comment|cat|pipe_id|pipe_length_m|pipe_size_mm
>
> Now use
> v.db.renamecol sewer_MN col=pipe_length_m,pipe_length_m_tmp
> and you get
> db.select sewer_MN | line
> comment|cat|pipe_id|pipe_size_mm|pipe_length_m_tmp

Hi Philipp

Thanks very much for the pointer, the v.db.renamecol trick to re-order 
the columns worked for me.

Best regards

Craig.