[GRASSLIST:8994] Re: db.copy fails with DBMI driver error

[Jed O. Kaplan]

Kirk,

I had success by specifying the complete path to the DBF database in  
the from_database= argument instead of ./ as in the example in the  
man pages.

GRASS 6.1.cvs (engadin-swissgrid):~ > db.copy from_driver=dbf  
from_database='/Users/jkaplan/Documents/grass/engadin-swissgrid/ 
PERMANENT/dbf/' from_table=mapcodes2 to_driver=pg  
to_database="host=localhost,dbname=engadin" to_table=mapcodes3

Seems to work!

Cheers,

Jed

On 10 Nov 2005, at 20:16, Kirk R. Wythers wrote:

>
> On Nov 8, 2005, at 4:24 AM, Jed O. Kaplan wrote:
>
>> GRASS 6.1.cvs (engadin-swissgrid):~ > db.copy from_driver=dbf  
>> from_database=./ from_table=mapcodes2 to_driver=pg  
>> to_database="host=localhost,dbname=engadin" to_table=mapcodes2
>> DBMI-DBF driver error:
>> Table 'mapcodes2' doesn't exist.
>
> Did you try creating the table 'mapcodes' in postgres first before  
> copying from dbf? Does anyone know if this is a required step?
>
>
> Kirk
>
>> Error in db_open_select_cursor()
>