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
|