[Qgis-user] text data type conversion migrating from postgis to spatialite

[Pietro Rossin]

Hi
I'm planning a distribution of templates using spatialite.
Data are locally stored into a postgis db.
I made all tables in Postgres with different kind/lenght of text fields.
Some are small lenght and are VARCHAR(n) and some must contain a large
amount of text (mainly abstracts - 150-500 words) and I used the "TEXT" data
type.
I used this string to migrate all tables to spatialite
***************
ogr2ogr --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES -f
"myfile.sqlite -progress PG:"dbname='mydb' active_schema=myschema
schemas=myschema host='localhost' port='5432' user='user'
password='password' " -lco LAUNDER=yes -dsco SPATIALITE=yes -lco
SPATIAL_INDEX=yes -gt 65536
***************
with this operation all "TEXT" fields are converted to VARCHAR (without
lenght) while all VARCHAR(n) are correctly converted.
Using DbManager in Qgis 2.0, making a drag'n drop from postgis schema to
spatialite db I get a spatialite table with all fields converted to "TEXT"
without lenght...

Also
Using the above ogr2ogr string the geom column in postgis is converted to
GEOMETRY in spatialite, while using dbmanager a geom column is created into
spatialite..

Why?
Are there problems if postgis TEXT fields are converted to VARCHAR in
spatialite when I'll return back data to postgis, and VARCHAR in spatialite
can contain large text blocks?

The same for geom/GEOMETRY..

Thanks
Pietro




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/text-data-type-conversion-migrating-from-postgis-to-spatialite-tp5094159.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.