PostGis connections

Working using QGIS as interface using PostGIS connections.

  • Server: gisdb.csr.av
  • Database: avgis
  • Leave Service empty

Adding tables (With geometries) in form of shape files from database using Browser panel-

Go to QGIS> view> Panels> Browser panel> PostGIS> Expand the connection> give credentials> add the desired file by double clicking on it.

Adding tables (For non-geometry type) using PostGIS connections-

Add PostGIS Layers > Give credentials > select "Also list tables with no geometry" > expand public > click on the desired table> add.

Joining tables

Right click/double click on file> go to Join > perform the desired joins - add/subtract the joins.