db | R Documentation |
Interface with project databases.
writeDBTable(
name,
value,
overwrite = FALSE,
append = FALSE,
row.names = FALSE,
host = getOption("aakmisc.dbhost", "localhost"),
dbname = getOption("aakmisc.dbname", NULL),
port = getOption("aakmisc.port", 5432),
user = getOption("aakmisc.user", NULL),
...
)
getQuery(
statement,
host = getOption("aakmisc.dbhost", "localhost"),
dbname = getOption("aakmisc.dbname", NULL),
port = getOption("aakmisc.port", 5432),
user = getOption("aakmisc.user", NULL),
...
)
getMLEs(
host = getOption("aakmisc.dbhost", "localhost"),
dbname = getOption("aakmisc.dbname", NULL),
port = getOption("aakmisc.port", 5432),
user = getOption("aakmisc.user", NULL),
...
)
recMLEs(
mle,
host = getOption("aakmisc.dbhost", "localhost"),
dbname = getOption("aakmisc.dbname", NULL),
port = getOption("aakmisc.port", 5432),
user = getOption("aakmisc.user", NULL),
...
)
recScript(
files,
host = getOption("aakmisc.dbhost", "localhost"),
dbname = getOption("aakmisc.dbname", NULL),
port = getOption("aakmisc.port", 5432),
user = getOption("aakmisc.user", NULL),
...
)
dropScript(
script,
host = getOption("aakmisc.dbhost", "localhost"),
dbname = getOption("aakmisc.dbname", NULL),
port = getOption("aakmisc.port", 5432),
user = getOption("aakmisc.user", NULL),
...
)
listScripts(
host = getOption("aakmisc.dbhost", "localhost"),
dbname = getOption("aakmisc.dbname", NULL),
port = getOption("aakmisc.port", 5432),
user = getOption("aakmisc.user", NULL),
...
)
catScript(
script,
file = "",
host = getOption("aakmisc.dbhost", "localhost"),
dbname = getOption("aakmisc.dbname", NULL),
port = getOption("aakmisc.port", 5432),
user = getOption("aakmisc.user", NULL),
...
)
name , value |
Name and contents of table to create. |
overwrite , append , row.names |
See |
host |
Hostname on which to connect to the PostgreSQL server. |
dbname |
Name of PostgreSQL database. |
port |
Port on which to connect to PostgreSQL database. If NULL, a random port number will be used. |
user |
Username to use in conneting to PostgreSQL database. If NULL, Sys.getenv("USER") will be used. |
... |
Additional arguments will be passed to |
statement |
SQL statement passed to |
mle |
A data-frame of MLEs to be recorded. |
files |
Files containing R scripts to be recorded. |
script |
Name of script. |
file |
File to which the script will be written. See
|
Aaron A. King
## Not run:
startTunnel()
listScripts()
stopTunnel()
## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.