How to realize the data connection between PostGIS and qgis

Editor to share with you how to achieve PostGIS and qgis data connection, I hope you will learn something after reading this article, let's discuss it together!

PostGIS is a widely used spatial extension of open source database Postgresql. Using PostGIS plug-in, you can easily organize and manage spatial data in the database. At the same time, PostGIS also has many spatial processing and analysis functions, which can easily complete the processing of data layers in the database. At present, many open source and commercial software can support direct connection to Postgresql databases with PostGIS spatial expansion. Edit and modify the data in the database, and publish the spatial layer data directly.

The following is a list of how to use the open source software qgis tool to connect to the Postgresql database with expansion, how to import shp file data into the database, how to load the spatial layers in the database directly into qgis for viewing, and how to export the data in the database to spatial data files such as shp.

How to install postgresql+postgis, how to create a database with spatial expansion, please search on the Internet, this article will not introduce.

Open the interface of qgis, right-click on the postgis on the left, create a new database connection, in the database connection interface, add the connection parameters of postgresql, and then test the database connection.

Add a connection to postgresql

After the database connection is successful, if there is a spatial data layer in the database, each table is used as a data layer, drag and drop each layer to the qgis interface, you can view the details of the data, right-click on the layer, you can export the layer.

View layer data in the database

View layer

Save as Vector layer

After reading this article, I believe you have a certain understanding of "how to achieve data connection between PostGIS and qgis". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!