[GRASSLIST:1787] Re: db.copy

[Radim Blazek]

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