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