Rich Shepard wrote: On Sat, 12 Mar 2011, Micha Silver wrote: Hmmm is right. On my (debian) I get: # check columns in a vector GRASS 6.4.0RC6 (ITM):~ > v.info -c idan_catchments Displaying column types/names for database connection of layer 1: INTEGER|cat CHARACTER|label DOUBLE PRECISION|area_sqm INTEGER|area_dunam # Which current db connection? GRASS 6.4.0RC6 (ITM):~ > v.db.connect -p idan_catchments Vector map <idan_catchments@idan> is connected by: layer <1> table <idan_catchments> in database </home/micha/geodata/grass/ITM/idan/dbf/> through driver <dbf> with key <cat> GRASS 6.4.0RC6 (ITM):~ > # Copy to postgres GRASS 6.4.0RC6 (ITM):~ > db.copy from_dri=dbf to_dri=pg to_data="host=localhost,dbname=geodata" from_tab=idan_catchments to_tab=idan_catchments # Check for data in new table GRASS 6.4.0RC6 (ITM):~ > psql -d geodata -c "SELECT * FROM idan_catchments" cat | label | area_sqm | area_dunam -----+-------+--------------+------------ 2 | | 455240.625 | 455 4 | | 9070862.5 | 9070 6 | | 1637971.875 | 1637 8 | | 11677375 | 11677 10 | | 2449587.5 | 2449 12 | | 4955384.375 | 4955 14 | | 5248571.875 | 5248 16 | | 7726990.625 | 7726 18 | | 2845550 | 2845 ...... Why don't you try with g.copy?
|
_______________________________________________ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user