Geografic-Information-System/scripts/db.out.ogr/db.out.ogr.html

<h2>DESCRIPTION</h2>

<em>db.out.ogr</em> exports GRASS GIS attribute tables into various formats as
supported by the OGR driver on the local system (CSV, DBF,
PostgreSQL, SQLite, MySQL, ODBC, etc.).
<p>
The <em>dsn</em> parameter is commonly the output file name (if the path is not
defined, too, the module will attempt write to the current directory). In case
of a database connection as output, the connection string has to be specified.
<p>
The <em>layer</em> parameter is needed if the attribute table to be exported
is linked as non-default layer to a vector map.

<h2>EXAMPLES</h2>

Export of GRASS table to a DBF table (default format):
<p><div class="code"><pre>
db.out.ogr precip_30ynormals dsn=/tmp/precip_30ynormals.dbf
</pre></div>

<p>Export of GRASS table to a CSV table file:<br>
<p><div class="code"><pre>
db.out.ogr precip_30ynormals dsn=precip_30ynormals.csv format=CSV
</pre></div>

<p>Export of GRASS table into a PostgreSQL table:
<p><div class="code"><pre>
db.out.ogr precip_30ynormals dsn="PG:host=localhost dbname=meteo user=neteler" \
           format=PostgreSQL
echo "SELECT * FROM precip_30ynormals" | psql meteo
</pre></div>


<h2>SEE ALSO</h2>

<em><a href="sql.html">GRASS SQL interface</a></em>

<h2>AUTHOR</h2>

Markus Neteler

<p><i>Last changed: $Date$</i>