ST_BandPath
上一页  11.5. 栅格波段访问器  下一页

名称

ST_BandPath — 返回存储在文件系统中的波段的系统文件路径。 如果未指定波段号，则假定为 1。

大纲

text ST_BandPath(raster rast, integer bandnum=1);

Description

返回指定波段的系统文件路径。如果调用时使用数据库中的波段，则会抛出错误。

示例

Code
WITH foo AS (
    SELECT ST_AddBand(
        NULL::raster,
        '/home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif',
        NULL::int[]
    ) AS rast
)
SELECT bandnum, ST_BandPath(rast, bandnum) AS path
FROM foo
CROSS JOIN generate_series(1, 3) AS bandnum;
栅格输出
bandnum |                                    path
---------+----------------------------------------------------------------------------
       1 | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif
       2 | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif
       3 | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif