Opened 9 years ago

Last modified 7 years ago

#3111 new enhancement

Support for binary input/output for raster

Reported by: cyrilleberger Owned by: Bborie Park
Priority: medium Milestone: PostGIS Fund Me
Component: raster Version: master
Keywords: Cc:

Description

The raster type does not support binary input/output (it only has raster_in and raster_out, and no raster_recv and raster_send). Since sending data to the server is more efficient using the binary protocol, it would be convenient to add support for binary mode when doing SQL queries.

I managed to work around for sending raster data from the server to the client with the following SQL:

CREATE OR REPLACE FUNCTION raster_send(raster) RETURNS bytea AS 'SELECT bytea($1)' LANGUAGE SQL;

UPDATE pg_type SET typsend = 'raster_send' WHERE typname='raster'

Unfortunately, there is no way to create a similar function for raster_recv.

Change History (3)

comment:1 by robe, 9 years ago

Component: postgisraster
Milestone: PostGIS 2.1.8PostGIS 2.2.0
Owner: changed from pramsey to Bborie Park

comment:2 by Bborie Park, 9 years ago

Milestone: PostGIS 2.2.0PostGIS Future
Version: 2.1.xtrunk

comment:3 by robe, 7 years ago

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.