Now that we know the basis of QGIS, we can start to use it to see the data that is stored in our data tables. First, we will take a look inside the tbl_landmarks
table; to do this, we will have to perform the following steps:
In the Layers menu, select Add PostGIS Layers:
Now, you can see a window where you will have to specify the necessary data in order to establish a connection with your PostGIS server:
Click on the New button to create a new connection, and you will see the following window:
Fill it with the appropriate data; you can click on the Test Connect button to check that the data is okay. If you are working from your personal machine or think it's secure enough to save your username and password on it, you can check those checkboxes to avoid QGIS from asking you for them every time you connect to the server. Click on the OK button to finish.
You will see a warning dialog box if you choose to store the username and password; click on OK to continue.
Now, you are...