Manage database connection
1 2 3 4 5
name of the database or a valid
named optional connection parameters
the service name
If no connection parameters are supplied, the connection will fallback to default parameters. Usually this establishes a connection on the localhost to a database, if it exists, with the same name as the user.
Valid keywords and their defaults can be obtained by calling
get_conn_defaults(all = TRUE). A valid
connection string is composed of
keyword = value pairs
separated by whitespace. You can either pass the entire string
or use named arguments. The names of the arguments will be used
as keywords and their values as values.
If a password was required but not provided,
will open a dialog and prompt for a password. The connection is
then re-tried and the status returned.
disconnect will free any query results as well
as clean up the connection data. It is called in the pakcage
.Last.lib function when exiting
make_service function will write the current connection
settings to a special set of files recognized by PostgreSQL's libpq.
After calling this function, you will be able to reconnect using the
service name as in
connect(service=name). If the connection
requires a password, that will be saved as well. This is not likely
to work on Windows since the file locations are different between
Unix-like and Windows. File a bug with the libpq folks if that
connect returns one of:
Do not open a connection and then fork the R
process. The behavior will be unpredictable. It is perfectly
acceptable however to call
connect within each
Timothy H. Keitt
1 2 3 4 5 6 7 8
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.