PivotalR (version 0.1.18.5)

db.list: List all the currently active connections with their information

Description

List all the currently active connections with their information including the connection ID, host, user, database, DBMS (database management system), MADlib schema name in the database, and the R package name used to connect to the database.

Usage

db.list()

Value

No value is returned.

See Also

db.connect connects to database.

db.disconnect disconnects a connection.

connection info the functions that extract information about the connection.

conn.eql tests whether two connections are the same.

Examples

# NOT RUN {
<!-- %% @test .port Database port number -->
<!-- %% @test .dbname Database name -->
## set up the database connection
## Assume that .port is port number and .dbname is the database name
cid1 <- db.connect(port = .port, dbname = .dbname, verbose = FALSE)
cid2 <- db.connect(port = .port, dbname = .dbname, verbose = FALSE)

db.list() # list the two connections

db.disconnect(cid1, verbose = FALSE)
db.disconnect(cid2, verbose = FALSE)
# }