db.copy1grass
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.
Usage
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]
[--help]
[--verbose]
[--quiet]
[--ui]
Keywords
database, attribute table, SQL
Overview
db.copy allows the user to copy a table between two databases. Databases can be connected through different drivers (see examples below).
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
From DBF to PostgreSQL
Storing 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 DBF
db.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 condition
db.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 SQLite
db.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 DBF
db.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
Source code
Available at: db.copy source code (history)
Accessed: Monday Feb 24 17:50:22 2025
Main index | Database index | Topics index | Keywords index | Graphical index | Full index
© 2003-2025 GRASS Development Team, GRASS GIS 8.4.1 Reference Manual
Releases
10 releases since Debian 4.0 (Etch); the text changed 9 times.