1SET postgis.gdal_enabled_drivers = 'GTiff'; 2SET postgis.enable_outdb_rasters = true; 3 4( 5SELECT 6 1, 7 bandnum, 8 isoutdb, 9 CASE 10 WHEN isoutdb IS TRUE 11 THEN strpos(path, 'testraster.tif') > 0 12 ELSE NULL 13 END, 14 outdbbandnum 15FROM ST_BandMetadata((SELECT rast FROM raster_outdb_template WHERE rid = 1), ARRAY[]::int[]) 16UNION ALL 17SELECT 18 2, 19 bandnum, 20 isoutdb, 21 CASE 22 WHEN isoutdb IS TRUE 23 THEN strpos(path, 'testraster.tif') > 0 24 ELSE NULL 25 END, 26 outdbbandnum 27FROM ST_BandMetadata((SELECT ST_SetBandIndex(rast, 1, 2) FROM raster_outdb_template WHERE rid = 1), ARRAY[]::int[]) 28) 29ORDER BY 1, 2; 30