[GRASS-user] postgresql driver

[Vassily Poddubny]

Hi, Jachym!

Thanks!

Jachym Cepicky пишет:
> hi,
> 
> Vassily Poddubny píše v Út 26. 02. 2008 v 20:18 +0500:
>> Hi!
>>
>> I have postgresql table with point data type column "mypointloc". When i 
>> have tried to create vectors (points) object in GRASS 6.2.2
>>
>> v.in.db driver=pg database="localhost,dbname=aeronet" table=mytable 
>> x=mypointloc[0] y=mypointloc[1] key=myid output=mynewtable
>>
>> I have got message " WARNING: pg driver: column 'mypointloc', type 600 
>> is not supported"!
>> Result table "mynewtable" have not x and y columns.
> 
> 
> afaik you have to specify two new collumns of types (float or double),
> for x and y coordinates.
> 
> grass does not support "point" column type used in potgresql
> 

Does you mean - it is better do not use postgresql tables with point 
type? It is strange for me!


>> How I have create vectors(points) objects from postgresql table?
>>
>> Is it possible to create new vectors(points) without creation new 
>> attribute table?
> 
> yes, v.in.ascii should do the job
> 

OK! I think it is lucky thought. I will try to create ascii file from 
postgresql table and then I will use v.in.ascii.
Thank you!

Basil