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.