.TH db.out.ogr 1grass "" "GRASS 6.4.2" "Grass User's Manual"
.SH NAME
\fI\fBdb.out.ogr\fR\fR  - Exports attribute tables into various formats.
.SH KEYWORDS
database, attribute table
.SH SYNOPSIS
\fBdb.out.ogr\fR
.br
\fBdb.out.ogr help\fR
.br
\fBdb.out.ogr input\fR=\fIname\fR \fBdsn\fR=\fIname\fR \fBformat\fR=\fIstring\fR  [\fBdb_table\fR=\fIname\fR]   [--\fBverbose\fR]  [--\fBquiet\fR] 
.SS Parameters:
.IP "\fBinput\fR=\fIname\fR" 4m
.br
GRASS table name
.IP "\fBdsn\fR=\fIname\fR" 4m
.br
Table file to be exported or DB connection string
.IP "\fBformat\fR=\fIstring\fR" 4m
.br
Table format
.br
Options: \fICSV,DBF,GML,MySQL,PostgreSQL,SQLite\fR
.br
Default: \fIDBF\fR
.IP "\fBdb_table\fR=\fIname\fR" 4m
.br
Name for output table
.PP
.SH DESCRIPTION
\fIdb.out.ogr\fR exports GRASS attribute tables into various formats as
supported by the OGR driver on the local system (CSV, DBF,
PostgreSQL, SQLite, MySQL, ODBC, etc.).
.SH EXAMPLES
Export of GRASS table to a DBF table (default format):
.PP
\fC
.DS
.br
db.out.ogr precip_30ynormals dsn=/tmp/precip_30ynormals.dbf
.br
.DE
\fR
.PP
Export of GRASS table to a CSV table file:
.br
.PP
\fC
.DS
.br
db.out.ogr precip_30ynormals dsn=precip_30ynormals.csv format=CSV
.br
.DE
\fR
.PP
Export of GRASS table into a PostgreSQL table:
.PP
\fC
.DS
.br
db.out.ogr precip_30ynormals dsn="PG:host=localhost dbname=meteo user=neteler" \(rs
.br
           format=PostgreSQL
.br
echo "SELECT * FROM precip_30ynormals" | psql meteo
.br
.DE
\fR
.SH SEE ALSO
\fIGRASS SQL interface\fR
.SH AUTHOR
Markus Neteler
.PP
\fILast changed: $Date: 2011-09-04 15:23:30 +0200 (Sun, 04 Sep 2011) $\fR
.PP
Full index
.PP
© 2003-2011 GRASS Development Team