[postgis-users] please help "convert raster problem"

Mike Toews mwtoews at gmail.com
Fri Apr 1 02:11:11 PDT 2011


pgAdmin has a confusing behavior to show a blank data cell if the
number of characters is above some threshold in size. You can query
the character length of a text result to see if it at leasts exists in
some form:

select character_length(st_astext(rast)) from tablename;

hopefully you'll see a big number.
-Mike

On 1 April 2011 16:18, Eman Sayed <eman_sayed80 at yahoo.com> wrote:
> hello,
> i am using mapserver for windows (ms4w)
> ,postgres8.4,postgis2.0 and  pmapper template
>
> i converted a jpg(1.45 MB) into postgis by this commands:
>
> aster2pgsql.py -r 555.jpg -t tablename -o image.sql
> psql -h localhost -U postgres -d template_postgis -f image.sql
>
> it is take much time to convert and create one raster table with one row
> but when i open the table on postgres give me that
> "empty table" or postgres backend crash
> and i find nothing on the map with no errors
> can any body help me please
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



More information about the postgis-users mailing list