Connect QGIS with PostGIS tutorial
Open QGIS.
Select PostgreSQL icon on the left hand side of QGIS.
A menu name “Add PostGIS table” will appear.
Select “New” to create a connection to PostGIS and enter the “Name”, “Host”, “Port” and “Database”.
After fill up all required data, please select “Connect” to connect PostGIS. Layers that available in database will be shown.
Select layers that you need.
Selected layers will be shown in QGIS.