[GRASSLIST:1817] Re: db.copy

[Miha STAUT]

>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?

     Table "dejanja"
   Column    |  Type   |
-------------+---------+-
ks_ime_     | text    |
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| real    |

>BTW, from_database=nuts should be OK.
>
>Radim

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