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.