Strange query result

View: New views
2 Messages — Rating Filter:   Alert me  

Strange query result

by _DR_ :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi folks!

I have a postgis table with 1 row.
When I try to do simple query: select ST_AsText(the_geom) from table,
i get very strange result (see attachement).

It looks like one very long blank string, and then WKT result.

Thanks.

-DR




_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: Strange query result

by Paul Ramsey-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

That's the table header, as psql valiantly tries to fit your
multi-megabyte output into an ASCII column aligned output.
Fundamentally, a lot of the assumptions database tools have about
column widths don't work so well for geometry.

P.

On Sun, Nov 1, 2009 at 10:29 AM, Rykov Denis <rykovd@...> wrote:

> Hi folks!
>
> I have a postgis table with 1 row.
> When I try to do simple query: select ST_AsText(the_geom) from table,
> i get very strange result (see attachement).
>
> It looks like one very long blank string, and then WKT result.
>
> Thanks.
>
> -DR
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@...
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users