db.copy - Copy a table.

       Radim Blazek, ITC-irst, Trento, Italy

db.copy allows the user to copy a table between  two  databases.   Databases  can  be  connected  through
       different drivers (see examples below).

FromDBFtoPostgreSQLStoringtable’geonames.dbf’(incurrentdirectory)intoPostgreSQLthroughODBC:
       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

   FromPostgreSQLtoDBF
       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

   FromPostgreSQLtoPostgreSQLwithcondition
       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"

   FromDBFtoSQLite
       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

   FromSQLitetoDBF
       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

       database, attribute table, SQL

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.

       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.

db.connect,db.drivers,db.login,v.db.connect,v.clean

       GRASS SQL interface

       Available at: db.copy source code (history)

       Accessed: Friday Apr 04 01:18:42 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

GRASS 8.4.1                                                                                      db.copy(1grass)

db.copydb.copy--helpdb.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:--overwrite
           Allow output files to overwrite existing files

       --help
           Print usage summary

       --verbose
           Verbose module output

       --quiet
           Quiet module output

       --ui
           Force launching GUI dialog

   Parameters:from_driver=name
           Input driver name
           Options: dbf,mysql,odbc,ogr,pg,sqlite
           Default: sqlitefrom_database=name
           Input database name
           Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.dbfrom_table=name
           Input table name (only, if ’select’ is not used)

       to_driver=name
           Output driver name
           Options: dbf,mysql,odbc,ogr,pg,sqlite
           Default: sqliteto_database=name
           Output database name
           Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.dbto_table=name[required]
           Output table name

       where=sql_query
           WHERE conditions of SQL statement without ’where’ keyword
           Example: income < 1000 and population >= 10000

       select=string
           Full select statement (only, if ’from_table’ and ’where’ is not used)
           E.g.: SELECT dedek FROM starobince WHERE obec = ’Frimburg’