db.copy(1)

NAME
db.copy

DESCRIPTION
db.copy allows the user to copy a table between two databases. Databases can be connected through different drivers (see example).

NOTES
Attribute tables can be copied manually using db.copy and v.db.connect. Current connection settings are saved in $LOCATION/vector_map/dbln.

EXAMPLES

  DBF -> PG
Storing table 'markveggy.dbf' (in current directory) into PostgreSQL through ODBC:
db.copy from_driver=dbf from_database=$HOME/grassdata/spearfish60/user1/dbf \
  from_table=markveggy to_driver=pg to_database="host=pgserver,dbname=grass6test" \
  to_table=markveggy

  PG -> DBF
db.copy from_driver=pg from_database="host=pgserver.itc.it,dbname=testdb" \
  from_table=origtable to_driver=dbf \
  to_database=$HOME/grassdata/spearfish60/user1/dbf to_table=origtable

  PG -> PG with condition
db.copy from_driver=pg from_database="host=localhost,dbname=meteo" \
  from_table=ukraine to_driver=pg to_database="host=localhost,dbname=meteo" \
  to_table=selection where="cat < 500"

  DBF -> SQLite
db.copy from_driver=dbf from_database=$HOME/grassdata/spearfish60/user1/dbf \
   from_table=ammprv to_driver=sqlite \
   to_database=$HOME/grassdata/spearfish60/user1/sqlite.db to_table=ammprv
# convenient viewer:
sqlitebrowser $HOME/grassdata/spearfish60/user1/sqlite.db

  SQLite -> DBF
db.copy from_driver=sqlite from_database=$HOME/grassdata/spearfish60/user1/sqlite.db \
   from_table=ammprv to_driver=dbf to_database=$HOME/grassdata/spearfish60/user1/dbf \
   to_table=ammprv

SEE ALSO
v.db.connect, db.drivers, db.login, v.clean, GRASS SQL interface

AUTHOR
Radim Blazek, ITC-irst, Trento, Italy

Last changed: $Date: 2010-12-14 12:21:58 +0100 (Tue, 14 Dec 2010) $

Full index

© 2003-2010 GRASS Development Team