ST_SetBandPath

ST_SetBandPath
Prev	12.8. 栅格波段编辑器	Next

Name

ST_SetBandPath — 更新数据库外波段的外部路径和波段编号

Synopsis

raster ST_SetBandPath ( raster rast , integer band , text outdbpath , integer outdbindex , boolean force=false ) ;

描述

更新外部数据库波段的外部栅格文件路径和外部波段编号。


	如果 `force` 设置为True，则不执行任何测试以确保外部栅格文件和PostGIS栅格之间的兼容性(例如，对齐、像素支持)。此模式适用于外部栅格所在的文件系统更改。


	在内部，此方法将在索引处替换PostGIS栅格的波段 `band` 而不是更新现有路径信息。

可用性：2.5.0

示例

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
    1 AS query,
    *
FROM ST_BandMetadata(
    (SELECT rast FROM foo),
    ARRAY[1,3,2]::int[]
)
UNION ALL
SELECT
    2,
    *
FROM ST_BandMetadata(
    (
        SELECT
             AS rast
        FROM foo
    ),
    ARRAY[1,3,2]::int[]
)
ORDER BY 1, 2;

 query | bandnum | pixeltype | nodatavalue | isoutdb |                                      path                                       | outdbbandnum
-------+---------+-----------+-------------+---------+---------------------------------------------------------------------------------+--------------
     1 |       1 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            1
     1 |       2 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            2
     1 |       3 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            3
     2 |       1 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            1

     2 |       3 | 8BUI      |             | t       | /home/pele/devel/geo/postgis-git/raster/test/regress/loader/Projected.tif       |            3

另请参阅

ST_BandMetaData , ST_SetBandIndex