[GRASSLIST:2772] Problem with v.in.db

Leonardo Lami leo.lami at katamail.com
Fri Feb 27 09:58:08 EST 2004


I'd like to import a vector form a database (Postgre SQL), I used the command 
string: 
v.in.db driver=pg database=host=server.ufficio.net,dbname=renato,user=ekoclub 
table=anfibi_count x=latitud y=longitud key=count output=anfibi

The output message say:
...
...
D2/3: SQL: select count, latitud, longitud from anfibi_c_05000_count_tab
D3/3: describe_table()
D3/3: kcols = 0
D3/3: col: count, kcols 0, pgtype : 0, sqltype 0, fsize : 0
WARNING: pg driver: column 'count', type 0 is not supported
D3/3: col: latitud, kcols 0, pgtype : 0, sqltype 0, fsize : 0
WARNING: pg driver: column 'latitud', type 0 is not supported
D3/3: col: longitud, kcols 0, pgtype : 0, sqltype 0, fsize : 0
WARNING: pg driver: column 'longitud', type 0 is not supported
D3/3: row = 0 nrows = 74
D3/3: Row fetched

The type specified is the type of the field in the tables?
I setted it as "int8" and there aren't any 0 value in the fields.

What's the problem?

Thank you of all

Leonardo Lami




More information about the grass-user mailing list