[GRASS-user] postgresql driver

[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

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

jachym

> 
> Thanks & Regards
> 
> Basil
> 
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
-- 
Jachym Cepicky
e-mail: jachym.cepicky gmail com
URL: http://les-ejk.cz
GPG: http://www.les-ejk.cz/pgp/jachym_cepicky-gpg.pub
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Toto je =?UTF-8?Q?digit=C3=A1ln=C4=9B?=
	=?ISO-8859-1?Q?_podepsan=E1?= =?UTF-8?Q?_=C4=8D=C3=A1st?=
	=?ISO-8859-1?Q?_zpr=E1vy?=
Url : http://lists.osgeo.org/pipermail/grass-user/attachments/20080226/e886acea/attachment.bin