database(1grass)

✨ GRASS 8.5.0 Reference Manual ✨

okay bestie, welcome to database(1grass) β€” the group chat where all the GRASS database modules hang out πŸ’…

Geographic Resources Analysis Support System, aka GRASS (yes we say it out loud, it's iconic), is a Geographic Information System (GIS) used for geospatial data management and analysis, image processing, graphics/maps production, spatial modeling, and visualization. GRASS is literally being used right now in academic and commercial settings all around the world 🌍, plus by sooo many governmental agencies and environmental consulting companies. main character energy fr fr πŸ‘‘

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

Go to Database introduction | topics

Go back to help overview


πŸ—„οΈ Database commands:

no cap, this is the whole squad β€” every single one of them πŸ‘‡

  • db.columns β€” list ALL the columns for a given table. every last one. 🧐
  • db.connect β€” prints or sets the general DB connection for the current mapset. your connection's home base 🏠
  • db.copy β€” copy a table. that's it, that's the job πŸ’«
  • db.createdb β€” makes you a brand new, empty database πŸŽ€
  • db.databases β€” lists every database for a given driver and location πŸ”
  • db.describe β€” describes a table in detail. tell me everything bestie 🫢
  • db.drivers β€” lists all the database drivers πŸš—
  • db.dropcolumn β€” drops a column from the selected attribute table πŸͺ‚
  • db.dropdb β€” removes an existing database. bye babe 😭
  • db.droptable β€” drops an attribute table πŸ—‘οΈ
  • db.execute β€” executes ANY SQL statement. any. go off πŸ’…
  • db.in.ogr β€” imports attribute tables in various formats πŸ“₯
  • db.login β€” sets the user/password for a DB driver/database πŸ”
  • db.out.ogr β€” exports attribute tables into various formats πŸ“€
  • db.select β€” selects data from an attribute table βœ…
  • db.tables β€” lists all tables for a given database πŸ“‹
  • db.test β€” tests the database driver. heads up tho: the database must already exist and be set by db.connect ⚠️
  • db.univar β€” calculates univariate statistics on a selected table column πŸ“Š

Main index | Topics index | Keywords index | Graphical index | Full index


okay that's the whole vibe check, you're officially a database girlie now 🌈

Β© 2003-2026 GRASS Development Team, GRASS 8.5.0 Reference Manual πŸ’–

and that's a wrap on our little chat β€” this was brought to you by GRASS 8.5.0 and the one and only database(1grass). bye bestie, slay responsibly πŸ¦‹πŸŽ€βœ¨

πŸ“¦ where this page comes from