Homepage > Man Pages > Category > General Commands
Homepage > Man Pages > Name > D

db.copy

man page of db.copy

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

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: dbf,odbc,pg,mysql,sqlite,ogr 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: dbf,odbc,pg,mysql,sqlite,ogr 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 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 (C) 2003-2010 GRASS Development Team DB.COPY(1)
 
 
 

Copyright © 2011–2018 by topics-of-interest.com . All rights reserved. Hosted by all-inkl.
Contact · Imprint · Privacy

Page generated in 27.96ms.

amazing-wings.de | Ich brauche eine Berufsunfähigkeitsversicherung | Genug Geld verschwendet!