[GRASS-user] Upper case letters for defining columns via v.db.addtable

Helmut Kudrnovsky hellik at web.de
Mon Oct 13 02:36:41 PDT 2014


Johannes Radinger wrote
> Hi,
> 
> when I want to specify a column in v.db.addtable, all upper case letters
> in
> the column name get converted to lower case. I'm working on GRASS 71
> (trunk). Is this an intended behaviour?
> 
> v.db.addtable map=myMap table=test layer=3 columns="My_COL INT"
> 
> 
> cheers,
> 
> /Johannes
> 
> _______________________________________________
> grass-user mailing list

> grass-user at .osgeo

> http://lists.osgeo.org/mailman/listinfo/grass-user

a quick test here with sqlite as db-backend:

v.db.addcolumn map=mybusstop at user1 columns=My_COL integer 

v.db.addcolumn --verbose map=mybusstop at user1 columns=My_COL2 integer            
Adding column <My_COL2> to the table

v.db.addcolumn --verbose map=mybusstop at user1 columns=My_COL3 INT                
Adding column <My_COL3> to the table

db.columns table=mybusstop                                                      
cat
ROUTES
UPDATED
STREET_1
STREET_2
CAMPUS
SHELTER
BENCHES
DISPLAY_MP
SIGNS
RECEPTACLE
COMMENT_
ID
X
Y
Latitude
Longitude
Map_Size
Time_Pt
WWTm_pt
GoTri_Name
MDTm_Pt
My_COL
My_COL2
My_COL3

seems to work here.





-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Upper-case-letters-for-defining-columns-via-v-db-addtable-tp5167120p5167156.html
Sent from the Grass - Users mailing list archive at Nabble.com.


More information about the grass-user mailing list