Database Reference
In-Depth Information
);
SELECT AddRasterConstraints('prism',
'rast'::name);
The UPDATE will take some time and the output will look as follows:
droprasterconstraints
-----------------------
t
UPDATE 1260
addrasterconstraints
----------------------
t
Thereisnotmuchinformationprovidedintheoutput,sowewillinspecttherasters.
We will look at one raster tile.
SELECT
(ST_Metadata(rast)).numbands
FROM prism
WHERE rid = 550;
The output is as follows:
numbands----------2
The raster has two bands. The following are the details of these two bands:
SELECT
1 AS bandnum,
(ST_BandMetadata(rast, 1)).*
FROM prism
WHERE rid = 550
UNION ALL
SELECT
Search WWH ::




Custom Search