<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello Ahmed,<br>
<br>
I just posted a similar question a few days before with a solution.<br>
Your problem is, that data is a raw bytea which is passed to
ST_GeomFromWKB. Try to use escaping
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/9.4/static/datatype-binary.html">http://www.postgresql.org/docs/9.4/static/datatype-binary.html</a><br>
<br>
So maybe <br>
select location, st_astext(ST_GeomFromWKB(E'data', 4326)) from
tiletable_0 where location='dem2_4326_06_11.tif';<br>
might work.<br>
<br>
- Benjamin<br>
<br>
<div class="moz-cite-prefix">Am 20.04.2015 um 09:12 schrieb Ahmet
Temiz:<br>
</div>
<blockquote
cite="mid:CAJKO1Yv3WEjqQi56rn9cvvpRuo-SufdGR=G2b=tZab54kSMa6A@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-size:small">
<div class="gmail_default" style="">hello</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">I am trying to get "data(" bytea ")
, then convert it to postgis raster.<br>
</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">On this table:</div>
<div class="gmail_default"><br>
</div>
<div style="font-size:12.800000190734863px">
<div class="gmail_default"> Column | Type |
Modifiers </div>
<div class="gmail_default">----------+---------------+-----------</div>
<div class="gmail_default"> location | character(64) | not
null</div>
<div class="gmail_default"> data | bytea | </div>
<div class="gmail_default">Indexes:</div>
<div class="gmail_default"> "tiletable_2_pk" PRIMARY KEY,
btree (location)</div>
<div class="gmail_default" style="font-size:small"></div>
<div class="gmail_default" style="font-size:small">*** I
tried to get "data(" bytea ") as then convert to postgis
raster</div>
<div class="gmail_default" style="font-size:small"><br>
</div>
<div class="gmail_default">
<div class="gmail_default">tr2=> select location,
st_astext(ST_GeomFromWKB(data, 4326)) from tiletable_0
where location='dem2_4326_06_11.tif';</div>
<div class="gmail_default">ERROR: Invalid endian flag
value encountered.</div>
<div style="font-size:small"><br>
</div>
<div style="font-size:small"><br>
</div>
<div style="font-size:small">how can I solve the problem ?</div>
<div style="font-size:small"><br>
</div>
<div style="font-size:small">regards</div>
</div>
</div>
</div>
<div><br>
</div>
-- <br>
<div class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>Ahmet Temiz<br>
Jeoloji Müh.<br>
Afet ve Acil Durum Yönetimi Başkanlığı<br>
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu<br>
<br>
<br>
________________________<br>
<br>
Ahmet Temiz<br>
Geological Eng.<br>
Information Systems - GIS Group<br>
Disaster and Emergency Management<br>
of Presidency</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Dipl.-Betriebsw. (BA), Bachelor of Science
Benjamin Börngen-Schmidt
Bleichstraße 44
64293 Darmstadt
fon: +49-176-25300297
email: <a class="moz-txt-link-abbreviated" href="mailto:benjamin@boerngen-schmidt.de">benjamin@boerngen-schmidt.de</a></pre>
</body>
</html>