I am trying to convert from PostGIS to FileGDB using GDAL (ogr2ogr). One of my fields is an integer field and declared in PostGIS as an int4. However when I do a standard ogr2ogr export looking at the FileGDB the field comes out as a Long Integer. So I am trying to override the defaults using COLUMN_TYPES but I cannot seem to find a list of correct values to use.
ogr2ogr -f OpenFileGDB Output.gdb PG:"dbname=x user=x password=x host=x port=x" -sql "SELECT * from table" -lco COLUMN_TYPES=featurecode=Int16
I have tried Short Integer, smallint, and lots of different things including OFSTInt16
Does anyone know where a definitive list of field types is?
int4
(long long/int8
won't be supported until Pro 3.1/ArcGIS 11.1)