PostGIS Layers

PostGIS Layers

<A NAME="886"></A> <A NAME="107"></A> <A NAME="label_postgis"></A>

PostGIS layers are stored in a PostgreSQL database. The advantages of PostGIS are the spatial indexing, filtering and query capabilities it provides. Using PostGIS, vector functions such as select and identify work more accurately than with OGR layers in QGIS. <P> To use PostGIS layers you must:<A NAME="109"></A> <P>

• Create a stored connection in QGIS to the PostgreSQL database (if one is not already defined).<A NAME="111"></A>
• Connect to the database.
• Select the layer to add to the map.
• Optionally provide a SQL where clause to define which features to load from the layer.
• Load the layer.

<P>

---

<A NAME="CHILD_LINKS">Subsections</A>

• <A NAME="tex2html263" HREF="node8.html">Creating a stored Connection</A>
• <A NAME="tex2html264" HREF="node9.html">Loading a PostGIS Layer</A>
• <A NAME="tex2html265" HREF="node10.html">Some details about PostgreSQL layers</A>
• <A NAME="tex2html266" HREF="node11.html">Importing Data into PostgreSQL</A>
• <A NAME="tex2html267" HREF="node12.html">Improving Performance</A>
• <A NAME="tex2html268" HREF="node13.html">Vector layers crossing 180 longitude</A>

---