<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Yes this. The utility of the send/recv function are in supporting a client that is using a binary cursor. This doesn’t even happen much for vector data anymore (there was a brief period when we all felt it was de rigeur, and then it got benchmarked and it wasn’t that noticeable at all as a performance tweak, so everyone stopped, because it added complexity).<div><br></div><div>P<br id="lineBreakAtBeginningOfMessage"><div><br><blockquote type="cite"><div>On Apr 8, 2025, at 8:15 AM, <lr@pcorp.us> <lr@pcorp.us> wrote:</div><br class="Apple-interchange-newline"><div><meta charset="UTF-8"><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: HelveticaNeue; font-size: 13px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;">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></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;">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></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;">Most use cases beyond that are importing from a different raster format or exporting to a different raster format which functions<span class="Apple-converted-space"> </span><o:p></o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><a href="https://postgis.net/docs/en/RT_ST_FromGDALRaster.html" style="color: rgb(70, 120, 134); text-decoration: underline;">https://postgis.net/docs/en/RT_ST_FromGDALRaster.html</a><o:p></o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;">and<span class="Apple-converted-space"> </span><a href="https://postgis.net/docs/en/RT_ST_AsGDALRaster.html" style="color: rgb(70, 120, 134); text-decoration: underline;">https://postgis.net/docs/en/RT_ST_AsGDALRaster.html</a><o:p></o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;">as well as the raster2pgsql commandline tool.<o:p></o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div style="border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: currentcolor currentcolor currentcolor blue; border-image: none; padding: 0in 0in 0in 4pt;"><div><div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(225, 225, 225) currentcolor currentcolor; border-image: none; padding: 3pt 0in 0in;"><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><b><span style="font-size: 11pt; font-family: Calibri, sans-serif;">From:</span></b><span style="font-size: 11pt; font-family: Calibri, sans-serif;"><span class="Apple-converted-space"> </span>Lukas Panhirsch via postgis-users <postgis-users@lists.osgeo.org><span class="Apple-converted-space"> </span><br><b>Sent:</b><span class="Apple-converted-space"> </span>Tuesday, April 8, 2025 9:28 AM<br><b>To:</b><span class="Apple-converted-space"> </span>postgis-users@lists.osgeo.org<br><b>Subject:</b><span class="Apple-converted-space"> </span>Why does the raster type not have send/receive defined?<o:p></o:p></span></div></div></div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><o:p> </o:p></div><div><div style="margin: 0in; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 9pt; font-family: -moz-fixed, serif;">Hello,<span class="Apple-converted-space"> </span><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.<span class="Apple-converted-space"> </span><br><br>Is there any specific reason why the raster type does not have the send/receive functions in its SQL type definition?<span class="Apple-converted-space"> </span><br>The geometry type has these defined as conversions to/from EWKB, which are equivalent to ST_AsEWKB/ST_GeomFromEWKB if I understand correctly.<span class="Apple-converted-space"> </span><br>Equivalent (E?)WKB conversion functions exist for rasters in the form of (RT_)ST_AsBinary/ST_RastFromWKB, but have to be called explicitly.<span class="Apple-converted-space"> </span><br>I would like to use PostgreSQL features like COPY ... WITH BINARY with rasters, but it seems this is preventing me from doing so.<span class="Apple-converted-space"> </span><br><br>Sincerely,<span class="Apple-converted-space"> </span><br><br>Lukas<span class="Apple-converted-space"> </span></span></div></div></div></div></div></blockquote></div><br></div></body></html>