DESCRIPTION

db.in.ogr imports attribute tables in various formats as supported by the OGR driver on the local system (DBF, CSV, PostgreSQL, SQLite, MySQL, ODBC, etc.).

NOTES

EXAMPLES

Import of a CSV table file:
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). 

# NOTE: create koeppen_gridcode.csvt first for type recognition
db.in.ogr dsn=koeppen_gridcode.csv out=koeppen_gridcode
db.select koeppen_gridcode

Import of a SQLite table: 

db.in.ogr dsn=$HOME/sqlite/sqlite.db db_table=census_raleigh out=census_raleigh

Import of a PostgreSQL table: 

db.in.ogr dsn="PG:host=localhost dbname=ecad user=neteler" \
          db_table=ecad_verona_tmean out=ecad_verona_tmean
db.select ecad_verona_tmean
db.describe -c ecad_verona_tmean

SEE ALSO

v.in.ogr
GRASS SQL interface

AUTHOR

Markus Neteler

Last changed: $Date$