` `

Complemento Gerenciador BD

The DB Manager Plugin is officially part of the QGIS core and is intended to be the main tool to integrate and manage spatial database formats supported by QGIS (PostGIS, SpatiaLite, GeoPackage, Oracle Spatial, Virtual layers) in one user interface. The dbManager DB Manager Plugin provides several features. You can drag layers from the QGIS Browser into the DB Manager, and it will import your layer into your spatial database. You can drag and drop tables between spatial databases and they will get imported.

../../../_images/db_manager.png

DB Manager dialog

O menu Base de Dados permite ligar a uma base de dados existente, para começar a janela de SQL e sair do complemento Gerenciador BD. Quando estiver ligado a uma base de dados existente os menus Esquema e Tabela apareceram adicionalmente.

O menu Esquema inclui ferramentas para criar e apagar esquemas (vazias) e, se estiver topologia disponível (ex.: PostGIS 2), para iniciar o TopoViewer.

The Table menu allows you to create and edit tables and to delete tables and views. It is also possible to empty tables and to move tables from one schema to another. As further functionality, you can perform a VACUUM and then an ANALYZE for each selected table. Plain VACUUM simply reclaims space and makes it available for reuse. ANALYZE updates statistics to determine the most efficient way to execute a query. Finally, you can import layers/files, if they are loaded in QGIS or exist in the file system. And you can export database tables to shape with the Export File feature.

The Tree window lists all existing databases supported by QGIS. With a double-click, you can connect to the database. With the right mouse button, you can rename and delete existing schemas and tables. Tables can also be added to the QGIS canvas with the context menu.

Se estiver ligado à base de dados, a janela principal do Gerenciador BD oferece três separadores. O separador Informação fornecem informação sobre a tabela e a sua geometria assim como os campos existentes, restrições e índices. Permite também correr a Análise de Vácuo e criar um índice espacial na tabela selecionada, se não estiver atualmente feita. O separador Tabela mostra todos os atributos e o separador Pré-visualização renderiza as geometrias como pré-visualização.

Trabalhando com a Janela SQL

You can also use the DB Manager to execute SQL queries against your spatial database and then view the spatial output for queries by adding the results to QGIS as a query layer. It is possible to highlight a portion of the SQL and only that portion will be executed when you press F5 or click the Execute (F5) button.

../../../_images/db_manager_sql.png

Executing SQL queries in the DB Manager SQL window

Nota

The SQL Window can also be used to create Virtual Layers. In that case, instead of selecting a database, select QGIS Layers under Virtual Layers before opening the SQL Window. See Virtual layers for instructions on the SQL syntax to use.