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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
<h2>DESCRIPTION</h2>
<em>db.connect</em> allows the user to set parameters for
connection to database. These parameters are then taken by
modules as default values and user do not need enter
parameters each time. Values are stored in user file.
<h2>OPTIONS</h2>
Typing <em>db.connect -p</em> displays current connection parameters.
<h2>EXAMPLES</h2>
<h3>DBF</h3>
(the dbf/ subdirectory in the mapset must exist or must be created by the user):<br>
<b>db.connect driver=</b><em>dbf</em> <b>database=</b><em>'$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/'</em> <br>
<b>db.tables -p</b>
<h3>ODBC</h3>
(may require the use of <a href=db.login.html>db.login</a>):<br>
<b>db.connect driver=</b><em>odbc</em> <b>database=</b><em>gtest</em> <br>
<b>db.login user=myname pass=secret</b> <br>
<b>db.connect -p</b> <br>
<b>db.tables -p</b>
<h3>PostgreSQL</h3>
(may require the use of <a href=db.login.html>db.login</a>):<br>
<b>db.connect driver=</b><em>pg</em> <b>database=</b><em>"host=myserver.itc.it,dbname=mydb"</em> <br>
<b>db.login user=myname pass=secret</b> <br>
<b>db.connect -p</b> <br>
<b>db.tables -p</b>
<h3>PostgreSQL with different port</h3>
(may require the use of <a href=db.login.html>db.login</a>):<br>
<b>db.connect driver=</b><em>pg</em> <b>database=</b><em>"host=myserver.itc.it,dbname=mydb,port=6666"</em> <br>
<b>db.login user=myname pass=secret</b> <br>
<b>db.connect -p</b> <br>
<b>db.tables -p</b>
<h2>NOTES</h2>
To connect a vector map to a database table, use <em>v.db.connect</em>.
<h2>SEE ALSO</h2>
<em>
<a HREF="db.columns.html">db.columns</a>,
<a HREF="db.drivers.html">db.drivers</a>,
<a HREF="db.login.html">db.login</a>,
<a HREF="db.tables.html">db.tables</a>,
<a HREF="v.db.connect.html">v.db.connect</a>,
<a HREF="sql.html">GRASS SQL interface</a></em>
<h2>AUTHOR</h2>
Radim Blazek, ITC-Irst, Trento, Italy
<p><i>Last changed: $Date: 2005/10/19 09:00:29 $</i>
|
