Database Reference
In-Depth Information
How it works...
Connecting to a PostGIS database (see the
Adding PostGIS layers - QGIS
recipe
inthischapter)allowsyoutoutilizetheDBManagerplugin.OncetheDBManager
wasenabled,wewereabletotogglebetweenthe
Info
,
Table
,and
Preview
tabsto
efficiently view metadata, tabular data, and data visualization.
Next, we made changes to the database by adding a new schema and moving an
existing table to the new schema. A query was then run on the table in order to
transformtheprojection.Notetheautocompletefeatureinthe
SQL Window
,which
makes writing queries a breeze.