<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:-moz-fixed;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#467886;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#467886" vlink="#96607D" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>I think it’s because postgis raster is not an OGC standard or any kind of standard outside of PostGIS so there hasn’t been much need for it.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>For example if you wanted to backup your postgis raster table, you’d just use standard pg_dump / pg_restore tools.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Most use cases beyond that are importing from a different raster format or exporting to a different raster format which functions <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="https://postgis.net/docs/en/RT_ST_FromGDALRaster.html">https://postgis.net/docs/en/RT_ST_FromGDALRaster.html</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>and <a href="https://postgis.net/docs/en/RT_ST_AsGDALRaster.html">https://postgis.net/docs/en/RT_ST_AsGDALRaster.html</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>as well as the raster2pgsql commandline tool.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Lukas Panhirsch via postgis-users <postgis-users@lists.osgeo.org> <br><b>Sent:</b> Tuesday, April 8, 2025 9:28 AM<br><b>To:</b> postgis-users@lists.osgeo.org<br><b>Subject:</b> Why does the raster type not have send/receive defined?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"-moz-fixed",serif'>Hello, <br><br>I haven't used this mailing list before and couldn't figure out how to search in the archives, so I apologize if this has been answered before. <br><br>Is there any specific reason why the raster type does not have the send/receive functions in its SQL type definition? <br>The geometry type has these defined as conversions to/from EWKB, which are equivalent to ST_AsEWKB/ST_GeomFromEWKB if I understand correctly. <br>Equivalent (E?)WKB conversion functions exist for rasters in the form of (RT_)ST_AsBinary/ST_RastFromWKB, but have to be called explicitly. <br>I would like to use PostgreSQL features like COPY ... WITH BINARY with rasters, but it seems this is preventing me from doing so. <br><br>Sincerely, <br><br>Lukas <o:p></o:p></span></p></div></div></div></body></html>