If you use the psql (command line) client, you can use the \o command to direct output to a text file. That way, you can capture very large text blocks.
Documentation on psql is available at http://www.postgresql.org/docs/8.3/static/app-psql.html -----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
