NAME¶

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

KEYWORDS¶

database, attribute table, SQL

SYNOPSIS¶

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

Flags:¶

--overwrite

 

Allow output files to overwrite existing files

--verbose

 

Verbose module output

--quiet

 

Quiet module output

Parameters:¶

from_driver=name

 

Input driver name

 

Options: pg,dbf,ogr,odbc,mysql,sqlite

 

Default: dbf

from_database=name

 

Input database name

 

Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/

from_table=name

 

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

to_driver=name

 

Output driver name

 

Options: pg,dbf,ogr,odbc,mysql,sqlite

 

Default: dbf

to_database=name

 

Output database name

 

Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/

to_table=name

 

Output table name

where=sql_query

 

WHERE conditions of SQL statement without 'where' keyword

 

Example: income = 10000

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 using db.copy and, when to be associated to a vector map, assigned to the map with v.db.connect. Current connection settings are saved in the file $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: 2013-03-18 18:51:35 +0100 (Mon, 18 Mar 2013) $ Full index © 2003-2014 GRASS Development Team