[GRASS-user] howto change arrtibute column name

GRASS GRASS user
1

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?

Regards

Zbigniew

2

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.

Maciek

3

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 ...

Moritz

Maciek

_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser

4

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 :slight_smile:

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

Markus