Guest User

Untitled

a guest
Mar 25th, 2018
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. uri = QgsDataSourceUri()
  2. # set host name, port, database name, username and password
  3. uri.setConnection("geoerpdev2", "5432", "LAIS_SPACIAL", "postgres", "Passsword")
  4. # set database schema, table name, geometry column and optionally
  5. # subset (WHERE clause)
  6.  
  7. uri.setDataSource("spacial", "parcels", "geom","cell_code=3030404")
  8. if uri:
  9. print (uri)
  10.  
  11. vlayer = QgsVectorLayer(uri.uri(), "parcels", "postgres")
  12. if not vlayer.isValid():
  13. print (uri)
  14. print (vlayer)
  15. QgsProject.instance().addMapLayers([vlayer])
  16.  
  17. <qgis._core.QgsDataSourceUri object at 0x000002F5CA5C9EE8>
  18. <qgis._core.QgsVectorLayer object at 0x000002F5CA5E8C18>
  19. dbname='LAIS_SPACIAL' host=geoerpdev2 port=5432 user='postgres' password='Password' table="spacial"."parcels" (geom) sql=cell_code=3030404
Add Comment
Please, Sign In to add comment