ArcGIS Server Banner

PostgreSQL data types

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

When you create a feature class or table in ArcGIS, there are 11 different data types available for each column. These types are mapped to PostgreSQL types in the following table:


ArcGIS data type PostgreSQL data type Notes
OBJECTID INTEGER

SHORT INTEGER SMALLINT

LONG INTEGER INTEGER

FLOAT NUMERIC(38,8)

DOUBLE NUMERIC(38,8)

TEXT CHARACTER VARYING

DATE TIME WITHOUT TIME ZONE

BLOB BYTEA

GUID CHARACTER VARYING(38)

GEOMETRY ST_GEOMETRY*

PG_GEOMETRY

Data type depends on the geometry storage specified for the layer.
RASTER INTEGER

* ST_Geometry is a superclass. The actual data subtype created (such as ST_Multilinestring or ST_Point) depends on what type of feature class you create, whether polygon, line, point, multipoint, or multipatch.

See Also

  • About data types
  • About geometry storage types