In lieu of an informed answer, logic would suggest the geometry must be in the table (if it is displaying correctly in a GIS application).
Therefore, I would suggest that there may be some aspect of displaying it other than in a GIS application that is the problem. Are you using pgAdmin to view the table data? What operating system? There is a character limit - the normal limit on postgres rows is 2048 characters. But geometry data are not actually stored in the table, rather they are stored in a TOAST table. I would suggest that you try looking at it in psql (the command line application) or I believe there is a plug-in for pgAdmin that might help display the data there. Be aware also that if your geometries are large, the rows will be wide, and so displaying them in psql might be somewhat frustrating as you will have a large amount of blank space in the table heading etc. cheers Ben On 18/07/2011, at 8:30 PM, Phil James wrote: > I have loaded some geometry into a postgis table but although the geometry is > there (displays in Quantum and can query with ST_various correctly) it does > not appear with AsText() or in the Edit Table view. The type is MultiPolygon > using postgres 9 Postgis 1.5. Is there some character limit it exceeds? If > so why does the the_geom column appear blank in Edit Table using PGADMIN as > well? I have checked the geometry and it is valid. > > Thanks > > Phil > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
