ST_RasterUtil.describe
定义
ST_RasterUtil.describe 用于返回栅格列属性的描述。如果未提供任何参数或仅提供了详细参数,则 ST_RasterUtil.describe 存储过程会返回数据库中所有栅格列的列表。否则,如果输入表和列,则返回栅格列的描述。
语法
Oracle
sde.ST_RasterUtil.describe () RETURN CLOB sde.ST_RasterUtil.describe (param IN VARCHAR2) RETURN CLOB sde.ST_RasterUtil.describe (tableName IN VARCHAR2, columnName IN VARCHAR2) RETURN CLOB sde.ST_RasterUtil.describe (tableName IN VARCHAR2, columnName IN VARCHAR2, param IN VARCHAR2) RETURN CLOB
PostgreSQL
st_raster_util_describe () RETURN TEXT st_raster_util_describe (parameter IN TEXT) RETURN TEXT st_raster_util_describe (tableName IN TEXT, columnName IN TEXT) RETURN TEXT st_raster_util_describe (tableName IN TEXT, columnName IN TEXT, parameter IN TEXT) RETURN TEXT
SQL Server
st_raster_util_describe (databaseName IN NVARCHAR, tableName IN NVARCHAR, columnName IN NVARCHAR, parameter IN NVARCHAR) RETURN NVARCHAR
返回值
Oracle
CLOB
PostgreSQL
文本
SQL Server
NVARCHAR
参数
参数 | 描述 |
---|---|
tableName | 用户表的名称 |
columnName | 用户表中 ST_Raster 列的名称 |
verbose | 显示投影字符串 |
示例
以下示例返回栅格列 sat.image 的描述:
Oracle
SELECT sde.ST_RasterUtil.descibe('sat','image') FROM dual; Raster Column ID ............: 125 Table Name ..................: SAT Raster Column ...............: IMAGE Storage Type ................: ST_RASTER Configuration Keyword .......: DEFAULTS Coordinate System ...........: 4326 Permission ..................: Full Created .....................: Mon Apr 14 14:49:24 2008
PostgreSQL
SELECT sde.st_raster_util_describe('sat','image'); Raster Column ID ............: 125 Table Name ..................: SAT Raster Column ...............: IMAGE Storage Type ................: ST_RASTER Configuration Keyword .......: DEFAULTS Coordinate System ...........: 4326 Permission ..................: Full Created .....................: Mon Apr 14 14:49:24 2008
SQL Server
SELECT <function_owner>.st_raster_util_describe ('sde94','bobby', 'sat','image',null); Raster Column ID ............: 125 Database ....................: SDE94 Owner .......................: BOBBY Table Name ..................: SAT Raster Column ...............: IMAGE Storage Type ................: ST_RASTER Configuration Keyword .......: DEFAULTS Coordinate System ...........: 4326 Permission ..................: Full Created .....................: Mon Apr 14 14:49:24 2008
函数所有者是 sde 还是 dbo,取决于存储地理数据库系统表、函数和程序的方案。
3/7/2012