Exporting data using GIS clients is no different to what we have seen already: simply connect to a database, read the data, and then output to a format of your choice. Once a connection can be established, the output formats are totally up to the client used.
In this section, we'll use two GIS clients:QGIS and Manifold.
In order to connect to PostGIS from QGIS, go to Database\DB Manager and pick DB Manager. DB Manager is a very powerful tool that lets one not only simply connect and read data from a database, but also manage the database objects, such as tables, their columns, constraints, and indexes. In this scenario, we will not go into the details of how to manage a database using QGIS DB Manger, but instead we will focus on the task and simply use it to get to the data we want exported.
First, let's make sure we can connect to our database. When you expand the database node, you will see the schemas present in the database:
If you...