[postgis-users] I can't see the geometry column by console

[Eduin Yezid Carrillo Vega]

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 <pramsey at opengeo.org> 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
> <mviceromgvsig at gmail.com> 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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>