db.out.ogr(1grass)

💖 db.out.ogr — the GRASS manual but make it cute ✨

okay bestie, welcome to db.out.ogr(1grass), the GRASS User's Manual page that's about to walk you through yeeting your attribute tables out into literally any format you want 🎀

🌸 NAME 🌸

db.out.ogr — Exports attribute tables into various formats. no cap.

🔑 KEYWORDS 🔑

database, export, output, attribute table ✨

---

📜 SYNOPSIS 📜

db.out.ogr
db.out.ogr --help
db.out.ogr input=name output=name  [layer=string]  format=string
[table=name]   [--overwrite]  [--help]  [--verbose]  [--quiet]  [--ui]

🚩 Flags (the little toggles, she's giving options energy)

• --overwrite — Allow output files to overwrite existing files. she will literally just bulldoze whatever's already there, so be careful bestie 💀
• --help — Print usage summary. your girl explains herself 💅
• --verbose — Verbose module output. so. much. talking.
• --quiet — Quiet module output. no thoughts head empty 🤫
• --ui — Force launching GUI dialog. buttons!! clicking!! 🦋

🎀 Parameters (the actual arguments, the main characters)

• input=name [required] — GRASS table name. Or data source for direct OGR access. either or, she's flexible 🫶
• output=name [required] — Output table file name or DB connection string. like, tell her where it's going.
• layer=string — Layer number or name. Vector features can have category values in different layers. This number determines which layer to use. When used with direct OGR access this is the layer name. Default: 1 🧚
• format=string [required] — Table format. Options: CSV, DBF, GML, MySQL, PostgreSQL, SQLite. Default: CSV ⭐
• table=name — Name for output table (default: input name). if you don't say anything she just copies the input's name, iconic

---

💫 DESCRIPTION 💫

db.out.ogr exports GRASS attribute tables into various formats as supported by the OGR driver on the local system (CSV, DBF, PostgreSQL, SQLite, MySQL, ODBC, etc.). okay so it's giving versatility, it's giving range 🌈

The output parameter is used to define the output file name (if the path is not defined, the module will attempt to write to the current directory). In case of a database connection as output, the connection string has to be specified. yes queen, spell it out for her 📝

The layer parameter is needed if the attribute table to be exported is linked as non-default layer to a vector map. lowkey important, don't skip it 🙈

---

✨ EXAMPLES ✨

Export of GRASS attribute table to a CSV table file (default format)

db.out.ogr input=precip_30ynormals output=precip_30ynormals.csv

Export of a GRASS attribute table to a DBF table

db.out.ogr input=precip_30ynormals output=precip_30ynormals.dbf format=DBF

Export of GRASS attribute table into a PostgreSQL table

db.out.ogr input=precip_30ynormals \
           output="PG:host=localhost dbname=meteo user=neteler" \
           format=PostgreSQL
# verify
echo "SELECT * FROM precip_30ynormals" | psql meteo

look at her go, ate that fr fr 🔥

---

👀 SEE ALSO 👀

• db.tables
• GRASS SQL interface

---

👑 AUTHORS 👑

• Markus Neteler
• Converted to Python by Glynn Clements

---

🛠️ SOURCE CODE 🛠️

Available at: db.out.ogr source code (history)

Latest change: Tuesday Oct 21 09:57:14 2025 in commit: fb0165c2d021b7700528aca09c224847be871729

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

© 2003-2026 GRASS Development Team, GRASS 8.5.0 Reference Manual

---

and that's the whole page bestie 💜 this was GRASS 8.5.0, db.out.ogr(1grass), and she served. go export something gorgeous 🌸🦋💅