1db.databases(1)             GRASS GIS User's Manual            db.databases(1)
2
3
4

NAME

6       db.databases  - Lists all databases for a given driver and location.
7

KEYWORDS

9       database, attribute table, SQL
10

SYNOPSIS

12       db.databases
13       db.databases --help
14       db.databases   [driver=name]    [location=name]   [--help]  [--verbose]
15       [--quiet]  [--ui]
16
17   Flags:
18       --help
19           Print usage summary
20
21       --verbose
22           Verbose module output
23
24       --quiet
25           Quiet module output
26
27       --ui
28           Force launching GUI dialog
29
30   Parameters:
31       driver=name
32           Name of database driver
33           Options: dbf, mesql, mysql, odbc, ogr, pg, sqlite
34           Default: sqlite
35
36       location=name
37           Location
38           Path for SQLite driver, or connection string for PostgreSQL driver
39

DESCRIPTION

41       db.databases lists all databases for a given driver and optionally  lo‐
42       cation.
43

NOTES

45       Currently supported database drivers are SQLite, PostgreSQL, and ODBC.
46
47       Default  location  for  SQLite  driver is the full path for the current
48       mapset. For PostgreSQL driver it’s empty connection string.
49

EXAMPLES

51       List SQLite databases in the current mapset:
52       db.databases driver=sqlite
53
54       List SQLite databases in a given directory:
55       db.databases driver=sqlite location=/opt/sqlite
56
57       List PostgreSQL databases from database server running on given port:
58       db.databases driver=pg location="host=server_name port=5333"
59

SEE ALSO

61        db.columns, db.describe, db.drivers, db.execute, db.login, db.tables
62
63       GRASS SQL interface
64

AUTHORS

66       Radim Blazek, ITC-Irst, Trento, Italy
67       Updated for GRASS 7 by Martin  Landa,  Czech  Technical  University  in
68       Prague, Czech Republic
69

SOURCE CODE

71       Available at: db.databases source code (history)
72
73       Accessed: Saturday Jan 21 21:14:03 2023
74
75       Main index | Database index | Topics index | Keywords index | Graphical
76       index | Full index
77
78       © 2003-2023 GRASS Development Team, GRASS GIS 8.2.1 Reference Manual
79
80
81
82GRASS 8.2.1                                                    db.databases(1)