1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
<h2>DESCRIPTION</h2>
<em>db.copy</em> allows the user to copy a table between two databases. Databases
can be connected through different drivers (see example).
<h2>NOTES</h2>
Attribute tables can be copied manually using db.copy and
<em><a HREF="v.db.connect.html">v.db.connect</a></em>. Current connection
settings are saved in <em>$LOCATION/vector_map/dbln</em>.
<h2>EXAMPLES</h2>
<b>DBF ->PG</a><P>
<em>storing table 'markveggy.dbf' (in current directory) into PostgreSQL
through ODBC:</em><br>
<b>db.copy from_driver=</b><em>dbf</em> <b>from_database=</b><em>./</em>
<b>from_table=</b><em>markveggy</em> <b>to_driver=</b><em>pg</em>
<b>to_database=</b><em>"host=pgserver,dbname=grass51test"</em>
<b>to_table=</b><em>markveggy</em>
<P>
<P>
<b>PG -> DBF</a><P>
<tt>db.copy from_driver=pg from_database="host=pgserver.itc.it,dbname=testdb"
from_table=origtable to_driver=dbf to_database=./ to_table=origtable</tt>
<h2>SEE ALSO</h2>
<em><a HREF="http://grass.itc.it/grass57/tutorial/attrib_storage.html">GRASS 5.7
tutorial pages</a></em><br>
<em><a HREF="v.db.connect.html">v.db.connect</a>,
<a HREF="db.drivers.html">db.drivers</a>,
<a HREF="db.login.html">db.login</a>,
<a HREF="v.clean.html">v.clean</a>,
<a HREF="sql.html">GRASS SQL interface</a></em>
<h2>AUTHOR</h2>
Radim Blazek, ITC-Irst, Trento, Italy
<p><i>Last changed: $Date: 2004/12/08 13:45:39 $</i>
|
