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