[GRASSLIST:1786] db.copy

Hi,

Why is the following command wrong? The opposite way works without problem.

GRASS 5.7.0-cvs:/home/ines > db.copy from_driver=pg from_database=dbname=nuts\
from_table=dejanja to_driver=dbf to_database=./ to_table=dej
dbmi: Protocol error
WARNING: Cannot create new table: 'create table dej ( ks_ime_d varchar(-5),
         127 integer, 129 integer, 133 integer, 134 integer, 135 integer, 136
         integer, 137 integer, 143 integer, 144 integer, 145 integer, 152 integer,
         180 integer, 181 integer, 183 integer, 196 integer, 197 integer, 200
         integer, 201 integer, 202 integer, 203 integer, 211 integer, 212 integer,
         213 integer, 214 integer, 215 integer, 216 integer, 217 integer, 218
         integer, 221 integer, 224 integer, 226 integer, 228 integer, 245 integer,
         254 integer, 256 integer, 299 integer, 302 integer, 303 integer, 309
         integer, 310 integer, 311 integer, 317 integer, 327 integer, 333 integer,
         vsa_dejanja integer, kriminalnost double precision)'
Segmentation fault

Or is there a command I could use to succesfully export a PostgreSQL table to a .dbf table?

Thanks in advance, Miha Staut

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

On Monday 17 November 2003 16:19, Miha STAUT wrote:

Hi,

Why is the following command wrong? The opposite way works without problem.

GRASS 5.7.0-cvs:/home/ines > db.copy from_driver=pg
from_database=dbname=nuts\
from_table=dejanja to_driver=dbf to_database=./ to_table=dej
dbmi: Protocol error
WARNING: Cannot create new table: 'create table dej ( ks_ime_d varchar(-5),
         127 integer, 129 integer, 133 integer, 134 integer, 135 integer,
136
         integer, 137 integer, 143 integer, 144 integer, 145 integer, 152
integer,
         180 integer, 181 integer, 183 integer, 196 integer, 197 integer,
200
         integer, 201 integer, 202 integer, 203 integer, 211 integer, 212
integer,
         213 integer, 214 integer, 215 integer, 216 integer, 217 integer,
218
         integer, 221 integer, 224 integer, 226 integer, 228 integer, 245
integer,
         254 integer, 256 integer, 299 integer, 302 integer, 303 integer,
309
         integer, 310 integer, 311 integer, 317 integer, 327 integer, 333
integer,
         vsa_dejanja integer, kriminalnost double precision)'
Segmentation fault

Or is there a command I could use to succesfully export a PostgreSQL table
to a .dbf table?

Thanks in advance, Miha Staut

What '\d dejanja' in psql says?

BTW, from_database=nuts should be OK.

Radim