Database Reference
In-Depth Information
Using the Database Manager plugin -
QGIS
The
Database Manager
(
DB Manager
)allowsforamoresophisticatedrelationship
withPostGISbyallowinguserstointeractwiththedatabaseinavarietyofways.The
pluginmimicssomeofthecorefunctionalityofpgAdminwiththeaddedbenefitofdata
visualization.
Inthisrecipe,wewilluseDBManagertocreate,modify,anddeleteitemswithinthe
databaseandthentinkerwiththeSQLwindow.Bytheendofthissection,youwillbe
able to do the following:
• Navigate to the DB Manager menu
• Create, modify, and delete database schemas and tables
• Run SQL queries to add new QGIS layers or create new tables in the data-
base
QGIS needs to be installed for this recipe. Please refer to the first recipe in this
chapter for information on where to download the installer.
Getting ready
Let's make sure theplugin is enabled and connected to the database.
1. Clickonthe
Plugins
menulocatedontheQGISmenubarandselect
Manage
and Install Plugins
from the drop-down menu:
2. TheQGIS
Plugin Manager
windowwillopen.Searchfor
DB Manager
inthe
list of plugins and make sure it is checked (enabled):