[GRASSLIST:10448] Re: connect with selection???

[Dylan Beaudette]

On Monday 20 February 2006 09:45 am, Massimiliano Cannata wrote:
> Hello,
> currently I keep in a pg table X,Y,value,type,date of meteostation and
> import the rain vector with:
>
> echo "SELECT x,y,value FROM observation where type=rain and
> date='200602101200'" | db.select -c | v.in.ascii out=rain.200602101200
>
>
> Conceptually the geometry is static and just the attribute are time
> dependent.
>
> So I wonder if is there a way for select vector attributes based on
> WHERE statement?
> What I need should be a sort of v.db.connect with table="SELECT bla bla
> FROM bla bla WHERE bla bla"...
>
> Do you have some hints for doing the rigth thing?
>
> Thanks,
> Massimiliano

I wonder if the GRASS PG driver support views? -- this would be exactly what 
you are asking for i think.

cheers,

-- 
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341