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

Linux commands

  • 1
    a56-toomf
    a56-toomf
    a56-toomf - Motorola DSP56001 assembler
    - convert to OMF ...
    Run a56-toomf
  • 2
    a56
    a56
    A56 - Motorola DSP56001 assembler ...
    Run a56
  • 3
    cpmrm
    cpmrm
    cpmrm - remove files on CP/M disks ...
    Run cpmrm
  • 4
    cpp-4.7
    cpp-4.7
    cpp - The C Preprocessor ...
    Run cpp-4.7
  • 5
    gapi2-fixup
    gapi2-fixup
    undocumented - No manpage for this
    program. DESCRIPTION: This program does
    not have a manpage. Run this command
    with the help switch to see what it
    does. For f...
    Run gapi2-fixup
  • 6
    gapi2-parser
    gapi2-parser
    undocumented - No manpage for this
    program. DESCRIPTION: This program does
    not have a manpage. Run this command
    with the help switch to see what it
    does. For f...
    Run gapi2-parser
  • More »

Ad