[GRASS-user] howto change arrtibute column name

[Markus Neteler]

On Tue, Oct 03, 2006 at 02:29:18PM +0200, Moritz Lennert wrote:
> Maciej Sieczka wrote:
> >Zbigniew Perski wrote:
> >>Hi,
> >>I have imported successfully a large dataset to grass. After the import
> >>the attribute columns are named like this: dbl_1 dbl_2......
> >>I would like to change this names for something more friendly. I tried
> >>some dbf editors but the allow only to change values but not the
> >>database structure.
> >>Any ideas?
> >
> >OO.org let's you edit column names.
> >
> >If more than 64k row use db.execute to copy all the attributes from
> >column 'oryg_name' in the input table to a column 'new_name' in the
> >output table, v.db.connect to change connection with tables.
> 
> You can actually use oobase to connect to your dbf file using the dbase 
> driver (in the launch dialog chose "connect to existing database").
> 
> Then you don't have any problems with row number limits ...
 

Now it's a FAQ article :-)

http://grass.gdf-hannover.de/wiki/SQL_rename_columns

Markus