[GRASS-user] sql and postgis

[Gustavo Martinez]

El Monday 29 October 2007 10:33:40 escribió:
> On 25/10/07 17:20, Gustavo Martinez wrote:
> > Hi all,
> >
> > I am using GRASS 6.3 RC1 compiled from source. I have a big table (2
> > million points) in Postgresql/Postgis that I can map with v.external. The
> > problem is when I try to select a subset of the data. I am using gis.m
> > and when I run the command:
> >
> >
> > d.vect map=monitoreo at PERMANENT color=0:0:0 lcolor=0:0:0
> > fcolor=170:170:170 display=shape type=point icon=basic/circle size=5
> > layer=1 lsize=8 xref=left yref=center llayer=1 {where=vel<4}
> >
> > I get the following error:
> >
> > ERROR 1: ERROR:  error de sintaxis en o cerca de «FROM»
> > LINE 1: SELECT  FROM monitoreo WHERE vel<4
> >                         ^
> >
> > DBMI-OGR driver error:
> > Cannot select:
> > SELECT  FROM monitoreo WHERE vel<4
> >
> > Any clues?
>
> What does v.db.connect -p monitoreo show ?
> Does database access work for v.external maps just as it does for
> imported maps ?
>
> Moritz

Moritz,

the result of  v.db.connect monitoreo -p is:

Vector map <monitoreo> is connected by:
layer <1> table <monitoreo> in database <PG:host=localhost dbname=pesca-new 
user=postgres> through driver <ogr> with key <>


Gustavo

-- 
Lic. Gustavo Martínez
Gestión de Pesquerías
Sub Secretaría de Pesca de la Nación
Paseo Colón 982, Anexo Jardín Pesca
Tel: (54) 11 43492165
Buenos Aires, República Argentina

“Que la tierra se vaya haciendo camino ante tus pasos,
que el viento sople siempre a tus espaldas,
que el sol brille cálido sobre tu cara,
que la lluvia caiga suavemente sobre tus campos y,
hasta tanto volvamos a encontrarnos,
que Dios te lleve en la palma de su mano.”