Use save results to file in pgadmin. It's the icon with arrow by the floppy.
> -----Original Message----- > From: [email protected] > [mailto:[email protected]] On > Behalf Of Bob Pawley > Sent: Tuesday, October 20, 2009 9:11 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] St_within problem > > > Even with astext the geomery is so complex the text can not > be deciphered > as shown in the Output pane. > > And pgadmin doesn't have a copy feature (as far as I know). > > Bob > ----- Original Message ----- > From: "Michael Smedberg" <[email protected]> > To: "PostGIS Users Discussion" <[email protected]> > Sent: Tuesday, October 20, 2009 8:29 AM > Subject: Re: [postgis-users] St_within problem > > > > You can use the astext function to get the WKT ("well known text".) > > E.g. you could do something like: > > > > SELECT astext(the_geom) FROM library.dgm_process > > > > which would return a textual representation of the geometries. > > ST_GeomFromText is the opposite of astext- it'll convert > the text to a > > geometry object. > > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of > > Bob Pawley > > Sent: Tuesday, October 20, 2009 8:09 AM > > To: PostGIS Users Discussion > > Subject: Re: [postgis-users] St_within problem > > > > The geometry comes up true for st_isvalid and yes the points are > > covering the geometry and beyond. > > > > I'm curious as to how I could retrieve the geometry in order to > > include them in an e-mail. > > > > As a shapefile perhaps?? > > > > Bob > > > > > > > > ----- Original Message ----- > > From: "Maxime van Noppen" <[email protected]> > > To: "PostGIS Users Discussion" > <[email protected]> > > Sent: Monday, October 19, 2009 9:55 AM > > Subject: Re: [postgis-users] St_within problem > > > > > >> Bob Pawley wrote: > >>> Funny this does work when I include st_box2d as in - > >>> > >>> st_within( graphics.point_grid.the_geom, > >>> st_box2d(library.dgm_process.the_geom)) > >>> > >>> However, this will include points within the box yet > outside of the > >>> actual geometry. > >> > >> It's hard to help without some additionnal data. Did you check that > > your > >> geometry is valid (ST_IsValid) ? Did you manually check that it > > actually > >> contains points ? > >> > >> -- > >> Maxime > >> _______________________________________________ > >> postgis-users mailing list > >> [email protected] > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > _______________________________________________ > > postgis-users mailing list [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > _______________________________________________ > > postgis-users mailing list [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
