ArcGIS Server Banner

ST_GeoSize

ST_GeoSize

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Note: This topic was updated for 9.3.1.

NOTE: Spatial type for PostgreSQL only

Definition

ST_GeoSize takes a geometry and returns its size in bytes.

Syntax

st_geosize (st_geometry)

Return type

Integer

Example

You can discover the size of the features created in the ST_GeomFromWKB example by querying the geometry column of the sample_geometries table.

SELECT st_geosize (geometry) FROM sample_geometries;

st_geosize
	512
	592
	616

See Also

  • An overview of SQL functions used with ST_Geometry types