Скачать или смотреть DB Manager in QGIS | Introduction to SQL and DB Manager

DB Manager in QGIS | Introduction to SQL and DB Manager
What is SQL?
SQL is the standard language used to:
Create and manage databases
Insert, update, delete data
Query data to retrieve useful information
Set permissions and control access
SQL helps you query, filter, and analyze spatial data in GIS software and spatial databases.
It is used to:
• Select features by attribute (e.g., “Give me all parcels where land use = ‘Residential’”)
• Join attribute tables
• Run spatial queries (e.g., “Find schools within 500m of a highway”)
• Create or modify data structures (tables, fields, indexes) in spatial databases (e.g., PostGIS, Oracle Spatial)
• Calculate statistics and summarize data
What is DB Manager?
DB Manager is a built-in tool in QGIS that provides a graphical interface to manage, query, and interact with spatial databases — all without leaving QGIS.
It helps you:
Connect to spatial databases (like PostGIS, SpatiaLite, GeoPackage, Oracle, MSSQL Spatial)
Browse database schemas, tables, and views
Run SQL queries directly on your spatial databases
Import/export layers between databases or to files (e.g., Shapefile, GeoPackage)
Create, delete, or edit tables and columns
Create indexes, primary keys, and even views