Advertisement
Guest User

Untitled

a guest
Sep 11th, 2017
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. from osgeo import ogr
  2. import sys
  3.  
  4. databaseServer = "postgrestest1"
  5. port = "5433" # <-- I know default is 5432, bu this server uses 5433
  6. databaseName = "pgv_2017"
  7. databaseUser = "myname"
  8. databasePW = "mypassw"
  9. connString = "PG: host=%s port=%s dbname=%s user=%s password=%s" %(databaseServer,port,databaseName,databaseUser,databasePW)
  10.  
  11. lyr_name = "k.jis"
  12.  
  13.  
  14. def GetPGLayerFields( lyr_name ):
  15. conn = ogr.Open(connString)
  16. print "conn:", conn
  17.  
  18. lyr = conn.GetLayer( lyr_name )
  19. print "lyr:", lyr
  20.  
  21. lyrDefn = lyr.GetLayerDefn()
  22. print "lyrDefn:", lyrDefn
  23.  
  24. num_flds = lyrDefn.GetFieldCount()
  25. print "num_flds:", num_flds
  26.  
  27. for i in range(num_flds):
  28. print lyrDefn.GetFieldDefn( i ).GetName()
  29.  
  30. conn.Destroy()
  31.  
  32.  
  33. if __name__ == '__main__':
  34.  
  35. GetPGLayerFields( lyr_name )
  36.  
  37. C:MartinWork>python test_pg_connect.py
  38. conn: <osgeo.ogr.DataSource; proxy of <Swig Object of type 'OGRDataSourceShadow *' at 0x00000000021C0720> >
  39. lyr: <osgeo.ogr.Layer; proxy of <Swig Object of type 'OGRLayerShadow *' at 0x00000000021C0660> >
  40. lyrDefn: <osgeo.ogr.FeatureDefn; proxy of <Swig Object of type 'OGRFeatureDefnShadow *' at 0x0000000004541030> >
  41. num_flds: 0
  42.  
  43. C:MartinWork>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement