Opened 2 years ago

Last modified 2 years ago

#3111 new enhancement

Support for binary input/output for raster

Reported by: cyrilleberger Owned by: dustymugs
Priority: medium Milestone: PostGIS Future
Component: raster Version: trunk
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 (2)

comment:1 Changed 2 years ago by robe

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

comment:2 Changed 2 years ago by dustymugs

Milestone: PostGIS 2.2.0PostGIS Future
Version: 2.1.xtrunk
Note: See TracTickets for help on using tickets.