database(1)

📦
version 8.4.2 · 5 versions
, in fedora 44

🦋 NAME 🦋

database — it's the whole glow-up tour of GRASS GIS database commands, bestie 💅

✨ DESCRIPTION ✨

okay so. Geographic Resources Analysis Support System, aka GRASS GIS (iykyk), is a Geographic Information System (GIS) used for geospatial data management and analysis, image processing, graphics/maps production, spatial modeling, and visualization. no cap. 🌍

GRASS is currently used in academic and commercial settings around the world, as well as by many governmental agencies and environmental consulting companies. it's giving globally iconic. 👑

This reference manual details the use of modules distributed with Geographic Resources Analysis Support System (GRASS), an open source (GNU GPLed), image processing and geographic information system (GIS). literally everything you need, all documented, all free. 🫶

  • Go to database introduction | topics
  • Go back to help overview

🎀 DATABASE COMMANDS 🎀

the main character list, fr fr. every one of these is a baddie:

  • db.columns — List all columns for a given table. 👀
  • db.connect — Prints/sets general DB connection for current mapset. the vibe check for your whole database linkup.
  • db.copy — Copy a table. dupe it, slay.
  • db.createdb — Creates an empty database. a blank canvas, an empty notebook, so aesthetic. 🎨
  • db.databases — Lists all databases for a given driver and location.
  • db.describe — Describes a table in detail. spill the tea about every field. ☕
  • db.drivers — Lists all database drivers.
  • db.dropcolumn — Drops a column from selected attribute table. bye bestie 👋
  • db.dropdb — Removes an existing database. not me deleting an entire database 😭
  • db.droptable — Drops an attribute table.
  • db.execute — Executes any SQL statement. raw power, no filter, main character energy. 🔥
  • 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.
  • 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. math girlies rise 📊
ngl, db.test is the strict one — the database must exist and must be set by db.connect first, or it's just not happening. 💀

🔍 SEE ALSO 🔍

  • Main index | Topics index | Keywords index | Graphical index | Full index
💖 © 2003-2025 GRASS Development Team, GRASS GIS 8.4.2 Reference Manual 💖

and that's the whole page, periodt. 🌈✨ this was brought to you by GRASS 8.4.2 and the one and only database(1) — stay hydrated, back up your tables, and go read a manual bestie 🎀🦋🌸

📦 where this page comes from