[GRASS5] dropping or renaming a column

Kirk R. Wythers kwythers at umn.edu
Thu Apr 28 15:38:42 EDT 2005

On Apr 27, 2005, at 11:11 AM, Jachym Cepicky wrote:

> for adding columns to the table see manual of db.execute
>     echo "alter table vector_file add column column_name 
> varchar(50)"|db.execute


How about removing a column or changing a column name? I've tried:

 > echo "ALTER TABLE table_name DROP COLUMN column_name double" | 


  > echo "ALTER TABLE table_name CHANGE COLUMN old_column_name 
new_column_name double" | db.execute

with no success...


More information about the grass-dev mailing list