EnglishFrenchSpanish

Ad


OnWorks favicon

db.copygrass - Online in the Cloud

Run db.copygrass in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command db.copygrass that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

PROGRAM:

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]
[--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: mysql, odbc, sqlite, pg, ogr, dbf
Default: sqlite

from_database=name
Input database name
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db

from_table=name
Input table name (only, if ’select’ is not used)

to_driver=name
Output driver name
Options: mysql, odbc, sqlite, pg, ogr, dbf
Default: sqlite

to_database=name
Output database name
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db

to_table=name [required]
Output table name

where=sql_query
WHERE conditions of SQL statement without ’where’ keyword
Example: income < 1000 and inhab >= 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 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

Use db.copygrass online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    itop - ITSM  CMDB OpenSource
    itop - ITSM CMDB OpenSource
    IT Operations Portal: a complete open
    source, ITIL, web based service
    management tool including a fully
    customizable CMDB, a helpdesk system and
    a document man...
    Download itop - ITSM CMDB OpenSource
  • 2
    Clementine
    Clementine
    Clementine is a multi-platform music
    player and library organizer inspired by
    Amarok 1.4. It has a fast and
    easy-to-use interface, and allows you to
    search and ...
    Download Clementine
  • 3
    XISMuS
    XISMuS
    ATTENTION: Cumulative update 2.4.3 has
    been released!! The update works for any
    previous 2.x.x version. If upgrading
    from version v1.x.x, please download and
    i...
    Download XISMuS
  • 4
    facetracknoir
    facetracknoir
    Modular headtracking program that
    supports multiple face-trackers, filters
    and game-protocols. Among the trackers
    are the SM FaceAPI, AIC Inertial Head
    Tracker ...
    Download facetracknoir
  • 5
    PHP QR Code
    PHP QR Code
    PHP QR Code is open source (LGPL)
    library for generating QR Code,
    2-dimensional barcode. Based on
    libqrencode C library, provides API for
    creating QR Code barc...
    Download PHP QR Code
  • 6
    Freeciv
    Freeciv
    Freeciv is a free turn-based
    multiplayer strategy game, in which each
    player becomes the leader of a
    civilization, fighting to obtain the
    ultimate goal: to bec...
    Download Freeciv
  • More »

Linux commands

Ad