Flags:¶

--overwrite

Allow output files to overwrite existing files

--help

Print usage summary

--verbose

Verbose module output

--quiet

Quiet module output

--ui

Force launching GUI dialog

Parameters:¶

input=name [required]

Table file to be imported or DB connection string

db_table=name

Name of table from given DB to be imported

output=name

Name for output table

key=string

Name for auto-generated unique key column

encoding=string

Encoding value for attribute data

Import CSV file¶

# NOTE: create koeppen_gridcode.csvt first for automated type recognition
db.in.ogr input=koeppen_gridcode.csv output=koeppen_gridcode
db.select table=koeppen_gridcode

Import DBF table¶

db.in.ogr input=/path/to/mydata.dbf output=census_raleigh key=myid
db.describe -c census_raleigh

Import of a SQLite table¶

db.in.ogr input=/path/to/sqlite.db db_table=census_raleigh output=census_raleigh

Import of a PostgreSQL table¶

# HINT: if the database contains spatial tables, but you want to import a non-spatial
table, set the environmental variable PG_LIST_ALL_TABLES to YES before importing
db.in.ogr input="PG:host=localhost dbname=ecad user=neteler" \
          db_table=ecad_verona_tmean output=ecad_verona_tmean
db.select table=ecad_verona_tmean
db.describe -c ecad_verona_tmean

Import XLS file¶

export OGR_XLS_HEADERS=’FORCE’
db.in.ogr input=address.xls db_table=address_data