CREATE TABLE newrasttable AS SELECT ST_MapAlgebraExpr(rast, '8BUI', '[rast]') rast FROM oldrasttable
Pierre > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of George Washington > Sent: Monday, April 30, 2012 7:33 AM > To: postgis-users@postgis.refractions.net > Subject: [postgis-users] Changing band pixel type > > Hi, I imported a raster image in postgis 2.0 (Win 7) and it shows a pixel > type of > 32BF, an overkill for my needs. > Is there a way of changing the pixel type to, say, 8BUI or 16BUI? I found > st_bandpixeltype to access the type, but not yet a way to set it. > Many thanks > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
