|
NAMEdb.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. KEYWORDSdatabase, attribute table, SQLSYNOPSISdb.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] [--help] [--verbose] [--quiet] [--ui] Flags:
Parameters:
DESCRIPTIONdb.copy allows the user to copy a table between two databases. Databases can be connected through different drivers (see examples below).NOTESAttribute 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.EXAMPLESFrom DBF to PostgreSQLStoring table ’geonames.dbf’ (in current directory) into PostgreSQL through ODBC:db.copy from_driver=dbf from_database=’$GISDBASE/$LOCATION_NAME/PERMANENT/dbf’ \ from_table=geonames to_driver=pg to_database="host=pgserver,dbname=testdb" \ to_table=geonames From PostgreSQL to DBFdb.copy from_driver=pg from_database="host=pgserver.example.org,dbname=testdb" \ from_table=origtable to_driver=dbf \ to_database=’$GISDBASE/$LOCATION_NAME/$MAPSET/dbf’ to_table=origtable From PostgreSQL to PostgreSQL with conditiondb.copy from_driver=pg from_database="host=localhost,dbname=testdb" \ from_table=geonames to_driver=pg to_database="host=localhost,dbname=testdb" \ to_table=selection where="cat < 500" From DBF to SQLitedb.copy from_driver=dbf from_database=’$GISDBASE/$LOCATION_NAME/PERMANENT/dbf’ \ from_table=geonames_features to_driver=sqlite \ to_database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’ to_table=geonames_features # convenient viewer: sqlitebrowser $HOME/grassdata/nc_spm_08/user1/sqlite/sqlite.db From SQLite to DBFdb.copy from_driver=sqlite from_database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’ \ from_table=ammprv to_driver=dbf to_database=’$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/’ \ to_table=ammprv SEE ALSOdb.connect, db.drivers, db.login, v.db.connect, v.cleanGRASS SQL interface AUTHORRadim Blazek, ITC-irst, Trento, ItalySOURCE CODEAvailable at: db.copy source code (history)Main index | Database index | Topics index | Keywords index | Graphical index | Full index © 2003-2021 GRASS Development Team, GRASS GIS 7.8.6 Reference Manual
Visit the GSP FreeBSD Man Page Interface. |