Rechercher une page de manuel
db.copy.1grass
Langue: en
Version: 331505 (ubuntu - 24/10/10)
Section: 1 (Commandes utilisateur)
Sommaire
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, SQLSYNOPSIS
db.copydb.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/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 \
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 interfaceAUTHOR
Radim Blazek, ITC-irst, Trento, ItalyLast changed: $Date: 2007-06-05 08:01:36 +0200 (mar, 05 giu 2007) $
Full index
© 2003-2010 GRASS Development Team
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre