.TH db.in.ogr 1grass "" "GRASS 6.4.4" "Grass User's Manual"
.SH NAME
\fI\fBdb.in.ogr\fR\fR  - Imports attribute tables in various formats.
.SH KEYWORDS
database, attribute table
.SH SYNOPSIS
\fBdb.in.ogr\fR
.br
\fBdb.in.ogr help\fR
.br
\fBdb.in.ogr dsn\fR=\fIname\fR  [\fBdb_table\fR=\fIname\fR]   [\fBoutput\fR=\fIstring\fR]   [\fBkey\fR=\fIstring\fR]   [\-\-\fBverbose\fR]  [\-\-\fBquiet\fR] 
.SS Parameters:
.IP "\fBdsn\fR=\fIname\fR" 4m
.br
Table file to be imported or DB connection string
.IP "\fBdb_table\fR=\fIname\fR" 4m
.br
Table name of SQL DB table
.IP "\fBoutput\fR=\fIstring\fR" 4m
.br
Name for output table
.IP "\fBkey\fR=\fIstring\fR" 4m
.br
Name for auto-generated unique key column
.PP
.SH DESCRIPTION
\fIdb.in.ogr\fR imports attribute tables in various formats as
supported by the OGR driver on the local system (DBF, CSV,
PostgreSQL, SQLite, MySQL, ODBC, etc.). Optionally a unique key (ID)
column can be added to the table.
.SH NOTES
.SH EXAMPLES
Import of a CSV table file:
.br
Limited type recognition can be done for Integer, Real, String, Date, Time and DateTime
columns through a descriptive file with same name as the CSV file, but .csvt extension
(see details here).
.PP
\fC
.DS
.br
# NOTE: create koeppen_gridcode.csvt first for type recognition
.br
db.in.ogr dsn=koeppen_gridcode.csv output=koeppen_gridcode
.br
db.select koeppen_gridcode
.br
.DE
\fR
.PP
Import of a DBF table with additional unique key column (e.g., needed for \fIv.in.db\fR):
.PP
\fC
.DS
.br
db.in.ogr dsn=$HOME/mydata.dbf output=census_raleigh key=myid
.br
db.describe \-c census_raleigh
.br
.DE
\fR
.PP
Import of a SQLite table:
.PP
\fC
.DS
.br
db.in.ogr dsn=$HOME/sqlite/sqlite.db db_table=census_raleigh output=census_raleigh
.br
.DE
\fR
.PP
Import of a PostgreSQL table:
.PP
\fC
.DS
.br
db.in.ogr dsn="PG:host=localhost dbname=ecad user=neteler" \(rs
.br
          db_table=ecad_verona_tmean output=ecad_verona_tmean
.br
db.select ecad_verona_tmean
.br
db.describe \-c ecad_verona_tmean
.br
.DE
\fR
.SH SEE ALSO
\fIv.in.ogr\fR
.br
\fIGRASS SQL interface\fR
.SH AUTHOR
Markus Neteler
.PP
\fILast changed: $Date: 2011-11-08 10:42:51 +0100 (Tue, 08 Nov 2011) $\fR
.PP
Full index
.PP
© 2003-2014 GRASS Development Team