Skip to content

Database tools

To learn more about these tool in general, go to Database introduction.

Name Description
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.