81 reputation
16
bio website geographer.gr
location
age
visits member for 2 years, 1 month
seen 11 hours ago

Oct
2
asked How to change color ramp in graduated classification with standard deviation using pyqgis
Sep
30
comment Does qgis support postgresql range types?
I'm able to load the postgis table in Qgis but the date column field is not listed in table.
Sep
30
asked Does qgis support postgresql range types?
Sep
27
comment Standard deviation classification in QGIS
Yes, but how can I display values above and below the mean. Like that in the example:http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Standard_‌​deviation
Sep
27
asked Standard deviation classification in QGIS
Sep
24
awarded  Teacher
Sep
24
answered Why doesn't QGIS automatically find the new plugin update during startup?
Sep
23
asked Why doesn't QGIS automatically find the new plugin update during startup?
Sep
5
comment How to load style from postgresql?
I'll check it.What's the format of uri?like that? uri=u'dbname=\'dbname\' host=localhost port=5432 user=\'leonidas\' password=\'xxx\' table=\'layer_styles_table_name'\ () sql='
Sep
5
awarded  Curious
Sep
4
asked How to load style from postgresql?
Sep
2
awarded  Supporter
Sep
2
comment Cannot load postgis layer from sql string in pyqgis
Also, the code works only if I don't define schema in DataSource:uri.setDataSource("",sql,"the_geom","","ID")
Sep
2
comment Cannot load postgis layer from sql string in pyqgis
I did CAST(coalesce(ID, 0) AS integer) as ID to cast to integer and now it works fine. Thank you for your help!!!
Sep
2
comment Cannot load postgis layer from sql string in pyqgis
I think that's the problem. The field is character varying. I check it with other data with smallint and it works. But the datasource should be "postgres" not "postgis", else it doesn't work. What are the appropriate data types? Is it possible to use a character varying field?
Sep
2
comment Cannot load postgis layer from sql string in pyqgis
Now I get: Failed to load:unknown error
Sep
2
revised Cannot load postgis layer from sql string in pyqgis
Added Qgis version
Sep
2
awarded  Commentator
Sep
2
comment Cannot load postgis layer from sql string in pyqgis
In that example says that there is an option like that: blog.georepublic.info/2013/joining-tables-with-sql-using-pyqgis I have already manage to load views or tables but I need to load layer from sql string. There is also another example here: carsonfarmer.com/2010/04/…
Sep
1
asked Cannot load postgis layer from sql string in pyqgis