forked from OSGeo/grass
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdb.databases.html
55 lines (39 loc) · 1.35 KB
/
db.databases.html
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
<h2>DESCRIPTION</h2>
<em>db.databases</em> lists all databases for a given <b>driver</b>
and optionally <b>location</b>.
<h2>NOTES</h2>
Currently supported database drivers are
<em><a href="grass-sqlite.html">SQLite</a></em>, <em><a href="grass-pg.html">PostgreSQL</a></em>,
and <em><a href="grass-odbc.html">ODBC</a></em>.
<p>
Default <b>location</b> for SQLite driver is the full path for the
current mapset. For PostgreSQL driver it's empty connection string.
<h2>EXAMPLES</h2>
List SQLite databases in the current mapset:
<div class="code"><pre>
db.databases driver=sqlite
</pre></div>
<p>
List SQLite databases in a given directory:
<div class="code"><pre>
db.databases driver=sqlite location=/opt/sqlite
</pre></div>
<p>
List PostgreSQL databases from database server running on given port:
<div class="code"><pre>
db.databases driver=pg location="host=server_name port=5333"
</pre></div>
<h2>SEE ALSO</h2>
<em>
<a href="db.columns.html">db.columns</a>,
<a href="db.describe.html">db.describe</a>,
<a href="db.drivers.html">db.drivers</a>,
<a href="db.execute.html">db.execute</a>,
<a href="db.login.html">db.login</a>,
<a href="db.tables.html">db.tables</a>
</em>
<p>
<a href="sql.html">GRASS SQL interface</a>
<h2>AUTHORS</h2>
Radim Blazek, ITC-Irst, Trento, Italy<br>
Updated for GRASS 7 by Martin Landa, Czech Technical University in Prague, Czech Republic