Geography Reference
In-Depth Information
This problem will most likely arise when opening database layers in QGIS. If you create a
database connection using a given set of credentials, and create the database in pgAdmin
using the
Postgres
user account, you'll find that the spatial metadata tables will have
Postgres
as their owner. When this happens, QGIS will be unable to open the metadata
tables and will show no layers available for you to use in the application.
The solution to this is very simple. Using pgAdmin, right-click on one of the metadata tables
and select the
Properties
option as shown in the following figure:
Figure 16: Editing Metadata Table Properties
The table's
Properties
dialog will appear.
