Do a SELECT ST_as EWKT(the_geom) instead of SELECT the_geom to show the geometry in text form.
Eduin Yesid Carrillo Vega Ingeniero Civil, Esp. Sistemas de Información Geográfica Centro de Investigación y Desarrollo en Información Geográfica Instituto Geográfico Agustín Codazzi - IGAC Cr 30 48-51 Tel +57 1 3694000 ext 4593 Bogotá D.C., Colombia On Tue, Mar 3, 2009 at 12:37 PM, Paul Ramsey <[email protected]> wrote: > The problem is the console is probably choking on large strings > (geometries in text form can get pretty darn large). It really should > not matter to you, I hope. You've confirmed the data is in the > database with other means, so now you can go ahead and do things with > it. > > Yours, > > P. > > On Tue, Mar 3, 2009 at 9:24 AM, marta vicente romero > <[email protected]> wrote: >> Hello >> >> I have a table with geographics dates >> I can't see the geometry column in the console >> however with a GIS or pgadmin it shows correctly .. >> what is the problem? >> >> with linux it shows, but I need work with windows >> I do an text file whith pg_dump .. >> when I put this file in de BD by windows, it fails. >> >> >> (sorry I don't speak English very well) >> >> thanks you very much >> _______________________________________________ >> 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
