PostgreSQL data types |
|
Release 9.3 |
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 |