Rasters are supported only in geodatabases. The ArcGIS type ObjectID is the registered row ID column for the table (or feature class).
See your PostgreSQL documentation for more information.
Postgresql create table install#
To use the PostGIS geometry or geography type, you must install PostGIS in your PostgreSQL database cluster, and the database itself must be enabled to use PostGIS. See Add the ST_Geometry type to a PostgreSQL database for information. To use ST_Geometry in a database (not a geodatabase), you must install it. In a geodatabase, the GEOMETRY_STORAGE setting of the configuration keyword used when creating the feature class determines which data type is created in the database. ST_Geometry, Geometry ( PostGIS), Geography ( PostGIS) See ArcGIS field data types for more information. The precision and scale specified in ArcGIS can affect the resultant data type created in the database. Other PostgreSQL data types that can be viewedĭate, time without time zone, time with time zone, timestamp with time zone The last column provides additional information when needed. The third column shows what other PostgreSQL data types, if any, map to the ArcGIS data type when you view a table that you created outside ArcGIS (not registered with the geodatabase). The second column lists the PostgreSQL data type that ArcGIS creates.
The first column in the following table lists the ArcGIS data types. Similarly, when you use ArcGIS to copy and paste tables containing unsupported data types from one database to another, ArcGIS only pastes columns that use a supported data type. ArcGIS does not display unsupported data types, and you cannot edit unsupported data types through ArcGIS. When you access a database table through a Database Connection, query layer, or web service, ArcGIS filters out any unsupported data types. How the data in that column is stored in the databaseĪrcGIS works with specific data types.What operations you can use on the data in that column.
What values you can store in the column.When you create a table or add a column to a table in a database, you define a specific data type for the column.
0 kommentar(er)
