Linux Certif

Toute la documentation sur la certification Linux LPI

db.copy

NAME

db.copy - Copy a table. Either 'from_table' (optionaly with 'where') can be used or 'select' option, but not 'from_table' and 'select' at the same time.

KEYWORDS

database, SQL

SYNOPSIS

db.copy
db.copy help
db.copy [from_driver=string] [from_database=string] [from_table=string] [to_driver=string] [to_database=string] to_table=string [where=string] [select=string] [--verbose] [--quiet]

Parameters:

from_driver=string

Input driver name
Options: ogr,odbc,pg,mysql,sqlite,mesql
Default: dbf

from_database=string

Input database name
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/

from_table=string

Input table name (only, if 'select' is not used)

to_driver=string

Output driver name
Options: ogr,odbc,pg,mysql,sqlite,mesql
Default: dbf

to_database=string

Output database name
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/

to_table=string

Output table name

where=string

Optional where condition (without WHERE key word), e.g.:
               obec = 'Liptakov'

select=string

Full select statement (only, if 'from_table' and 'where' is not used), e.g.:
               SELECT dedek FROM starobince WHERE obec = 'Frimburg'

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 rs

  from_table=markveggy to_driver=pg to_database="host=pgserver,dbname=grass6test" rs

  to_table=markveggy 

PG -> DBF

db.copy from_driver=pg from_database="host=pgserver.itc.it,dbname=testdb" rs

  from_table=origtable to_driver=dbf rs

  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" rs

  from_table=ukraine to_driver=pg to_database="host=localhost,dbname=meteo" rs

  to_table=selection where="cat < 500" 

DBF -> SQLite

db.copy from_driver=dbf from_database=$HOME/grassdata/spearfish60/user1/dbf rs

   from_table=ammprv to_driver=sqlite rs

   to_database=$HOME/grassdata/spearfish60/user1/mysqlite.db to_table=ammprv

# convenient viewer:
sqlitebrowser $HOME/grassdata/spearfish60/user1/mysqlite.db

SQLite -> DBF

db.copy from_driver=sqlite from_database=$HOME/grassdata/spearfish60/user1/mysqlite.db rs

   from_table=ammprv to_driver=dbf to_database=$HOME/grassdata/spearfish60/user1/dbf rs

   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: 2007-06-05 08:01:36 +0200 (Tue, 05 Jun 2007) $

Full index

© 2003-2008 GRASS Development Team