Geography Reference
In-Depth Information
For the purposes of this exercise, however, we'll be creating a new connection to hold our
data. To start, click
New
under
PostgreSQL connections
. The
Create a New PostGIS
connection
dialog will appear.
Figure 22: Creating a New PostGIS Connection
Complete the fields as shown in Figure 22, remembering to substitute your server name,
database name, user name, and password as required for your own Postgres installation.
You don't have to save the password and user name, but it makes connecting easier if you
don't have to type the credentials in every time.
The four deselected options are not required. They are used to control the following:
Only look in the geometry_columns table
: This option means exactly what it says.
By default, QGIS will look at all tables in the database to see if any of them contain
spatial geometry. Selecting this check box prevents this.
Only look in public schema
: If you use different schemas to logically divide your
database, selecting this option will make QGIS only look in the
public
schema
(equivalent to
DBO
in MS SQL).