Go to database introduction | topics
Database tools
db.columns List all columns for a given table.- db.connect Prints/sets general DB connection for current mapset.
- db.copy Copy a table. Either 'from_table' (optionally with 'where') can be used or 'select' option, but not 'from_table' and 'select' at the same time.
- db.createdb Creates an empty database.
- db.databases Lists all databases for a given driver and location.
- db.describe Describes a table in detail.
- db.drivers Lists all database drivers.
- db.dropcolumn Drops a column from selected attribute table.
- db.dropdb Removes an existing database.
- db.droptable Drops an attribute table.
- db.execute Executes any SQL statement. For SELECT statements use 'db.select'.
- db.in.ogr Imports attribute tables in various formats.
- db.login Sets user/password for DB driver/database.
- db.out.ogr Exports attribute tables into various formats.
- db.select Selects data from attribute table. Performs SQL query statement(s).
- db.tables Lists all tables for a given database.
- db.test Test database driver, database must exist and set by db.connect.
- db.univar Calculates univariate statistics on selected table column.