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):
Search WWH ::




Custom Search