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