[postgis-users] converting bytea data to postgis raster

[Benjamin Börngen-Schmidt]

Hello Ahmed,

I just posted a similar question a few days before with a solution.
Your problem is, that data is a raw bytea which is passed to 
ST_GeomFromWKB. Try to use escaping 
http://www.postgresql.org/docs/9.4/static/datatype-binary.html

So maybe
select location, st_astext(ST_GeomFromWKB(E'data', 4326))   from 
tiletable_0 where  location='dem2_4326_06_11.tif';
might work.

- Benjamin

Am 20.04.2015 um 09:12 schrieb Ahmet Temiz:
> hello
>
> I am trying to get "data(" bytea ")  , then convert it to postgis raster.
>
> On this table:
>
>   Column  |     Type      | Modifiers
> ----------+---------------+-----------
>  location | character(64) | not null
>  data     | bytea         |
> Indexes:
>     "tiletable_2_pk" PRIMARY KEY, btree (location)
> ​
> ​***  I tried to get "data(" bytea ")  as then convert to postgis raster
>
> tr2=> select location, st_astext(ST_GeomFromWKB(data, 4326))   from 
> tiletable_0 where  location='dem2_4326_06_11.tif';
> ERROR:  Invalid endian flag value encountered.
>
>
> how can I solve the problem ?
>
> regards
>
> -- 
> Ahmet Temiz
> Jeoloji Müh.
> Afet ve Acil Durum Yönetimi Başkanlığı
> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>
>
> ________________________
>
> Ahmet Temiz
> Geological Eng.
> Information Systems - GIS Group
> Disaster and Emergency Management
> of Presidency
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

-- 
Dipl.-Betriebsw. (BA), Bachelor of Science
Benjamin Börngen-Schmidt
Bleichstraße 44
64293 Darmstadt

fon: +49-176-25300297
email: benjamin at boerngen-schmidt.de

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150420/2782e2cc/attachment.html>